Backup and Restore of Partitioned Table in PG-15

Hi Gayatri Singh,

Could you try pgBackRest ?
Its advantages are speed, support for incremental backups, minimal
locking, and robust point in time recovery options besides several advanced
features.
Best suites for large-scale and critical PostgreSQL deployments.

Regards,
Muhammad Ikram
Bitnine Global

On Sun, Jun 16, 2024 at 4:09 AM Gayatri Singh <gayatripremselvi@gmail.com>
wrote:

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

--
Muhammad Ikram

Hi Gayatri,

On Sun, Jun 16, 2024 at 4:39 AM Gayatri Singh <gayatripremselvi@gmail.com>
wrote:

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.

This mailing list is for discussing development topics - bugs and features.
Please provide more details about the issues - URL where the issue is
reported, a reproducer etc. If the issues are already being discussed,
please participate in the relevant threads.

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.

These questions are appropriate for pgsql-general mailing list.

--
Best Wishes,
Ashutosh Bapat