RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi Laurenz, Thanks a lot! Regards, Meera -Original Message- From: Laurenz Albe Sent: Wednesday, June 5, 2024 3:56 PM To: Meera Nair ; pgsql-general@lists.postgresql.org Cc: Punit Pranesh Koujalgi ; B Ganesh Kishan Subject: Re: Logical replication type- WAL recovery fails and

RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

tml> Regards, Meera From: Ron Johnson Sent: Thursday, June 6, 2024 9:56 PM To: Laurenz Albe Cc: Meera Nair ; pgsql-general@lists.postgresql.org; Punit Pranesh Koujalgi ; B Ganesh Kishan Subject: Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedi

Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi team, With wal_level = 'logical', backup was taken using non-exclusive backup method. Following procedure here for restore and recovery - PostgreSQL: Documentation: 16: 26.3. Continuous Archiving and Point-in-Time Recovery (PITR)

Query related to pg_dump write to a pipe on a windows client and with compressed format

Hi all, https://www.postgresql.org/message-id/flat/CAKKd065aJ1LuUMw_bhBgmgoM6Ng-cLdBobpzRiU%2BUsdsmW2aOg%40mail.gmail.com#996021734fa788bd1bc737254002ad11 We tried pg_dump write to a pipe with compressed format and faced issue as in thread referred here. It was on windows client and for postgres

RE: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored

049 [root@gkstandby2 wal]# Regards, Meera -Original Message- From: Stephen Frost mailto:sfr...@snowman.net>> Sent: Tuesday, August 8, 2023 7:48 PM To: Meera Nair mailto:mn...@commvault.com>> Cc: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org&

PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored

Hi Team, We are following https://www.postgresql.org/docs/14/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP Making An Exclusive Low-Level Backup. After restoring, we see the server fails to start with below error: PostgreSQL server log: 2023-08-04 16:47:47.227 IST [40582] LOG: starting

RE: Unable to archive logs in standby server

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

RE: Unable to archive logs in standby server

, 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

RE: Unable to archive logs in standby server

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

RE: Unable to archive logs in standby server

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

Unable to archive logs in standby server

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 if I am missing anything in configuring this properly, Server was restarted af

Unable to archive logs in standby server

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 if I am missing anything in configuring this properly, Server was restarted af

RE: pg_dump is filling C: drive up to 100 percent

Hi Thomas, This worked for me, thanks a lot. Regards, Meera From: Thomas Boussekey Sent: Tuesday, July 19, 2022 5:33 PM To: Meera Nair Cc: Abdul Qoyyuum ; pgsql-general@lists.postgresql.org Subject: Re: pg_dump is filling C: drive up to 100 percent External email. Inspect before opening

RE: pg_dump is filling C: drive up to 100 percent

Hi Abdul, We do realize that. With tar format, is there a way to customize the path used for temporary local files? Some way to configure another drive instead of using C:\? Regards, Meera From: Abdul Qoyyuum Sent: Tuesday, July 19, 2022 3:40 PM To: Meera Nair Cc: pgsql-general

pg_dump is filling C: drive up to 100 percent

Hi team, pg_dump is filling C:\ This is for postgres version 12. Binary directory, data directory are in E:\ I'm redirecting pg_dump output also to E:\, I was taking a tar dump output. But C:\ is getting filled up . Looks like it is used for some sort of temporary staging. Is there a way not to