Postgres Pro
Downloads
Home   >   mailing lists

Backup and Restore of Partitioned Table in PG-15 - Mailing list pgsql-hackers

From Gayatri Singh
Subject Backup and Restore of Partitioned Table in PG-15
Date
Msg-id CABDbDcZewETKePRqajVjr5KPA+qVd3Bvuzo4kydKJ5CNG9A4PA@mail.gmail.com
Whole thread Raw
Responses Re: Backup and Restore of Partitioned Table in PG-15
Re: Backup and Restore of Partitioned Table in PG-15
List pgsql-hackers
Tree view
Hi Team,

Greetings of the day!!

We are planning to partition tables using pg_partman. Like we are planning for their backup and restoration process. 

Got a few URLs where pg_dump had issues while restoring some data that was lost.

kindly guide me the process or steps I need to follow for backing up partitioned tables correctly so that while restoration I don't face any issue.

Another question, currently we are using pg_dump for database backup which locks tables and completely puts db transactions on hold. For this I want tables shouldnt get locked also the backup process should complete in less time.

Thanks in advance!!

Thanks & Regards,
Gayatri


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Inval reliability, especially for inplace updates
Next
From: Noah Misch
Date:
Subject: IPC::Run accepts bug reports