Search Postgresql Archives
pg_dump and very slow database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Greetings,
I started a process last night that is reading records from one table,
applying some business rules (validation) and then moving some data to
another table.
I had a cron job which I forgot about that ran last night too. This
simply executes pg_dump :
/usr/local/pgsql/bin/pg_dump -U postgres -b -f
/home/backup/postgres_db/mydatabase.pgd -Fc mydatabase
The backup has been running for more than 140 minutes, according to
"ps". The processing of the records is still going but it is very slow
compared to when I first started it. I suspect there to be a problem
with running my process and this backup running at the same time. The
"locks" tab on the pgAdmin Server Status screen is full of locks for the
pg_dump command.
I do not have to have this backup done now, I can run it later today
manually.
Is it safe for me to just "kill -9" the pg_dump process? Or is there a
more graceful way to stop the pg_dump process.
Thanks in advance,
James
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]