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

2024-06-07 Thread Meera Nair
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

2024-06-07 Thread Meera Nair
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

2024-06-05 Thread Meera Nair
2 0/6300 before 2000-01-01 05:30:00+05:30 3 0/E800 no recovery target specified 4 1/6800 before 2000-01-01 05:30:00+05:30 Despite our efforts to troubleshoot, the problem persists. Please help to find a solution. Regards, Meera

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

2023-12-01 Thread Meera Nair
backup. Regards, Meera

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

2023-08-09 Thread Meera Nair
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

2023-08-08 Thread Meera Nair
047 [root@gkstandby2 wal]# /usr/pgsql-14/bin/pg_waldump 000400020046 | grep BACKUP rmgr: XLOGlen (rec/tot): 34/34, tx: 0, lsn: 2/46000110, prev 2/4698, desc: BACKUP_END 2/45005AE0 [root@gkstandby2 wal]# We are restoring all the transaction logs required for base backup to be consistent. BACKUP_END is present in the 000400020046 segment. Why did recovery fail to find this? Regards, Meera

RE: Unable to archive logs in standby server

2022-09-05 Thread Meera Nair
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-09-02 Thread Meera Nair
Hi Christophe, If pg_stop_backup is executed in master OR if standby server is restarted, I can see the archiving completing fine. Only issue is while manually executing the pg_stop_backup in standby Regards, Meera -Original Message- From: Christophe Pettus Sent: Friday, September 2

RE: Unable to archive logs in standby server

2022-09-02 Thread Meera Nair
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

2022-08-30 Thread Meera Nair
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

2022-07-24 Thread Meera Nair
ow wal_level; wal_level --- replica (1 row) postgres=# show archive_mode; archive_mode -- on (1 row) postgres=# show archive_command; archive_command copy "%p" "D:\PostgreSQL\14\standby_14\wal\%f" (1 row) Regards, Meera

Unable to archive logs in standby server

2022-07-21 Thread Meera Nair
ow wal_level; wal_level --- replica (1 row) postgres=# show archive_mode; archive_mode -- on (1 row) postgres=# show archive_command; archive_command copy "%p" "D:\PostgreSQL\14\standby_14\wal\%f" (1 row) Regards, Meera

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

2022-07-19 Thread Meera Nair
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

2022-07-19 Thread Meera Nair
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

2022-07-19 Thread Meera Nair
y not to use C:\ for this? Regards, Meera

Re: Plan for exclusive backup method

2021-05-21 Thread MEERA
Hi Magnus, Thank you. On Wed, May 19, 2021 at 3:30 PM Magnus Hagander wrote: > On Wed, May 19, 2021 at 11:58 AM MEERA wrote: > > > > Hi team, > > > > https://www.postgresql.org/docs/12/continuous-archiving.html > > > > It is mentioned here that ex

Plan for exclusive backup method

2021-05-19 Thread MEERA
label', false, *true*) is deprecated? In a future version, will it not allow the third argument to be true? -- thanks and regards, Meera R Nair