Re: pg_dump Running Slow

2024-01-16 Thread Jim Nasby
On 1/16/24 12:55 PM, Yongye Serkfem wrote: Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I

Re: pg_dump Running Slow

2024-01-16 Thread Adrian Klaver
On 1/16/24 10:55 AM, Yongye Serkfem wrote: Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I

pg_dump Running Slow

2024-01-16 Thread Yongye Serkfem
Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I check on the progression of the process? Sincer