Shreehari Vaasistha Lshreehari.hashnode.dev·Oct 31, 2024Boost PostgreSQL Export and Import with ParallelismIf you’ve ever had to move a hefty database, you know how painful it can be to sit through long export and import times. When speed is of the essence but configuration tweaks aren’t an option (maybe you don’t have permissions, or the team is on edge ...pg_restore
DbVisualizerthetable.hashnode.dev·Jul 1, 2024Efficient PostgreSQL Backups with pg_dumppg_dump is a key tool for PostgreSQL database backups. This guide offers a succinct summary with practical examples to help you get started. SQL Script Format pg_dump -U admin -d company -f company_backup.sql Restore with: psql -d new_company -f com...pg_dump