Re: Difference in the tablespace folders on primary and secondary nodes

Greetings, On Wed, Jul 26, 2023 at 21:31 Abhishek Bhola wrote: > Thank you for the very detailed reply. I tried the above method and it > works. I'm still setting up pgBackRest. > > I have one last question if you can answer that too please. > >> A delta restore will only restore those >> files

Re: Difference in the tablespace folders on primary and secondary nodes

Hi Stephen Thank you for the very detailed reply. I tried the above method and it works. I'm still setting up pgBackRest. I have one last question if you can answer that too please. > A delta restore will only restore those > files on the replica which are different from what was in the backup a

Re: Difference in the tablespace folders on primary and secondary nodes

Greetings, * Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote: > > Basically, this is not a valid way to perform a backup/restore of PG. > > Is it not valid only for PG 15 or even for earlier versions? I have always > referred to this https://www.postgresql.org/docs/8.1/backup-online.html F

Re: Difference in the tablespace folders on primary and secondary nodes

Hi Stephen I got the latest documentation and understood that I was supposed to run `select * from pg_backup_stop();` and store the labelfile output to a file in the data directory of the secondary node

Re: Difference in the tablespace folders on primary and secondary nodes

Hi Stephen Thank you for your reply. Basically, this is not a valid way to perform a backup/restore of PG. Is it not valid only for PG 15 or even for earlier versions? I have always referred to this https://www.postgresql.org/docs/8.1/backup-online.html > better, use an existing well maintaine

Re: Difference in the tablespace folders on primary and secondary nodes

Greetings, * Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote: > I recently set up a Postgres15 master-slave (Primary-secondary) cluster on > 2 nodes. At the time of starting, I ensured that data files are exactly the > same on both the nodes. The size of the DB is 1.5TB. > The directory stru

Difference in the tablespace folders on primary and secondary nodes

I recently set up a Postgres15 master-slave (Primary-secondary) cluster on 2 nodes. At the time of starting, I ensured that data files are exactly the same on both the nodes. The size of the DB is 1.5TB. The directory structure on both nodes looks as follows: ``` - /PROD/datadg/ | |-> /PROD