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 <gayatripremse...@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
