From: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
---|---|
To: | mnair(at)commvault(dot)com |
Cc: | guillaume(at)lelarge(dot)info, pgsql-general(at)lists(dot)postgresql(dot)org, pkoujalgi(at)commvault(dot)com |
Subject: | Re: Unable to archive logs in standby server |
Date: | 2022-09-05 02:00:44 |
Message-ID: | 20220905.110044.1946634667129910717.horikyota.ntt@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At Tue, 30 Aug 2022 05:22:56 +0000, Meera Nair <mnair(at)commvault(dot)com> wrote in
> Hi Guillaume/team,
>
> I set archive_mode = always in master and standby.
> Archival to standby WAL directory completed when
>
> * standby server was restarted
> * pg_stop_backup was executed in master
>
> But archival hangs when pg_stop_backup is executed in standby.
> Could someone help to get this working?
https://www.postgresql.org/docs/12/continuous-archiving.html
> In the same connection as before, issue the command:
>
> SELECT * FROM pg_stop_backup(false, true);
>
> This terminates backup mode. On a primary, it also performs an
> automatic switch to the next WAL segment. On a standby, it is not
> possible to automatically switch WAL segments, so you may wish to run
> pg_switch_wal on the primary to perform a manual switch. The reason
> for the switch is to arrange for the last WAL segment file written
> during the backup interval to be ready to archive.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | sivapostgres@yahoo.com | 2022-09-05 06:02:51 | Re: Creating constraint dynamically |
Previous Message | Mladen Gogala | 2022-09-03 20:35:47 | Re: [Beginner Querstion]Where can I find the news of database? |