Hi Kyotaro,
This helped, thanks.
Regards,
Meera
-Original Message-
From: Kyotaro Horiguchi
Sent: Monday, September 5, 2022 7:31 AM
To: Meera Nair
Cc: guilla...@lelarge.info; pgsql-general@lists.postgresql.org; Punit Pranesh
Koujalgi
Subject: Re: Unable to archive logs in standby
At Tue, 30 Aug 2022 05:22:56 +, Meera Nair 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 whe
, 2022 7:43 PM
To: Meera Nair
Cc: pgsql-general@lists.postgresql.org; Punit Pranesh Koujalgi
Subject: Re: Unable to archive logs in standby server
External email. Inspect before opening.
> On Sep 1, 2022, at 21:41, Meera Nair wrote:
> Archival hangs. Is this expected?
> postgres
> On Sep 1, 2022, at 21:41, Meera Nair wrote:
> Archival hangs. Is this expected?
> postgres=# select pg_start_backup('test', true, false);
> pg_start_backup
> -
> 1/F960
> (1 row)
>
> postgres=# select pg_stop_backup('f');
> NOTICE: base backup done, waiting for required
ll the
WAL segments.
……..
Regards,
Meera
From: subin
Sent: Friday, September 2, 2022 12:36 AM
To: Meera Nair
Subject: Re: Unable to archive logs in standby server
External email. Inspect before opening.
Hope you had a good time.
On Tue, Aug 30, 2022 at 6:00 PM Meera Nair
mailto:mn...@c
version
-
PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623
(Red Hat 4.8.5-39), 64-bit
(1 row)
Regards,
Meera
From: Guillaume Lelarge
Sent: Thursday, July 21, 2022 6:01 PM
To: Meera Nair
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Unable to archive lo
Hi,
Le jeu. 21 juil. 2022 à 13:58, Meera Nair a écrit :
> Hi team,
>
>
>
> With non-exclusive backup method, trying backup from standby node.
>
> But pg_stop_backup function returns “WAL archiving is not enabled…” and
> the logs are not archived to WAL directory configured.
>
>
>
> Please check