barman@prod-usw2-cs-main-dbbackups:~$ time barman recover --target-time "2022-02-25 03:51:21.494358+00:00" --remote-ssh-command "ssh postgres@remote-server-ip" dbname 20220225T033001 /mnt/data/postgresql/10/main Starting remote restore for server halberd_streaming using backup 20220225T033001 Destination directory: /mnt/data/postgresql/10/main Remote command: ssh postgres@remote-server-ip Doing PITR. Recovery target time: '2022-02-25 03:51:21.494358+00:00' Copying the base backup. Your PostgreSQL server has been successfully prepared for recovery! real 16m31.532s user 8m34.357s sys 3m56.060s
--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB
---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/97d0cad1-babc-40d7-9f92-4742bd5eae89n%40googlegroups.com.
The recover command is used to recover a whole server after a backup is executed using the backup command.
This is achieved issuing a command like the following:
IMPORTANT: Do not issue a recover command using a target data directory where a PostgreSQL instance is running. In that case, remember to stop it before issuing the recovery. This applies also to tablespace directories.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/e562c92d-6773-4c07-9509-f65022fd5f0an%40googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/CAMAE62%2BLKyDuweBiYeW6Upjd76qd3JBL9KKaVP8fZP71vkbVXA%40mail.gmail.com.
barman@prod-usw2-cs-main-dbbackups:/mnt/data/barman/bmshard1/config$ barman recover --target-time "2022-02-26 05:03:10.894436+00:00" --remote-ssh-command "ssh postgres@host-ip" db 20220226T050001 /mnt/data/postgresql/10/main/ Starting remote restore for server bmshard1 using backup 20220226T050001 Destination directory: /mnt/data/postgresql/10/main/ Remote command: ssh post...@10.5.84.61 Doing PITR. Recovery target time: '2022-02-26 05:03:10.894436+00:00' Copying the base backup. Copying required WAL segments. Generating recovery configuration Identify dangerous settings in destination directory. WARNING The following configuration files have not been saved during backup, hence they have not been restored. You need to manually restore them in order to start the recovered PostgreSQL instance: postgresql.conf pg_hba.conf pg_ident.conf Recovery completed (start time: 2022-02-26 20:33:53.416241, elapsed time: 10 minutes, 41 seconds) Your PostgreSQL server has been successfully prepared for recovery!
I start my recovered postgresql server like/usr/lib/postgresql/10/bin/pg_ctl -D /mnt/data/postgresql/10/main -l logfile start waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output.PostgreSQL logspostgres: could not access the server configuration file "/mnt/data/postgresql/10/main/postgresql.conf": No such file or directoryI have postgresql.conf in below directoryconf.d environment pg_ctl.conf pg_hba.conf pg_ident.conf postgresql.conf start.conf /etc/postgresql/10/mainmy data directory is in different directory/mnt/data/postgresql/10/main/ PG_VERSION current_logfiles pg_logical pg_serial pg_subtrans pg_xact recovery_conf.source backup_label global pg_multixact pg_snapshots pg_tblspc postgresql.auto.conf barman_wal pg_commit_ts pg_notify pg_stat pg_twophase postgresql.auto.conf.origin base pg_dynshmem pg_replslot pg_stat_tmp pg_wal recovery.conf
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/CAGxDL9KJMWRxWMXA_UjVG9xN48ZdKeN3%2BQFcqMOUABeP%3DWG6sg%40mail.gmail.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/CAMAE62J3MkaiLZ%2BKjXhx03C29_sefh%2B3By45jdenMc6wfg_L4g%40mail.gmail.com.
--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB
---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/CAKoxK%2B6q5hDwW_GAgEAwrdaHuBmPr94pGFx76wz2LvZd6H1wEA%40mail.gmail.com.