Re: Backup and Restore of Partitioned Table in PG-15

2024-06-18 Thread Ashutosh Bapat
Hi Gayatri, On Sun, Jun 16, 2024 at 4:39 AM Gayatri Singh 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

Re: Backup and Restore of Partitioned Table in PG-15

2024-06-16 Thread Muhammad Ikram
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 G

Backup and Restore of Partitioned Table in PG-15

2024-06-15 Thread Gayatri Singh
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