From: | Sebastián Baioni <sebaioni-postgresql(at)yahoo(dot)com(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Can't make backup |
Date: | 2008-01-03 11:59:29 |
Message-ID: | 132231.97829.qm@web36114.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't have any table called pg_locks in pg_catalog.
We let running pg_dump 8.2.5 at 1:30 AM after an automatic reboot of the PostgreSQL service and it didn't finish. When I came to the office at 9:00 there were a lot of locks, but all of them were from the pg_dump conection.
Thanks
Sebastián
Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> escribió: Sebastián Baioni wrote:
> Every day we run a Windows Programmed pg_dump, it used to
> work fine with PostgreSQL 8.0, but since we installed the new
> version we are not able to make a backup. We tried to make a
> whole database backup and it never ends. We tried to backup
> table by table and it reachs a table of 50,000 rows and it
> keeps for hours in that table, we started it again and
> pg_dump backups that same table in seconds, but it stops in
> another different table.
> If we watch the server message.# we don't have any error,
> it's like some tables were locked and pg_dump would keep
> waiting for the table to be unlocked.
If pg_dump is locked out, there should be entries in
pg_catalog.pg_locks. Check when the dump hangs!
Does the dump file keep growing or not?
Yours,
Laurenz Albe
---------------------------------
Los referentes más importantes en compra/venta de autos se juntaron:
Demotores y Yahoo!.Ahora comprar o vender tu auto es más fácil.
Visitá http://ar.autos.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2008-01-03 12:27:14 | Re: Argentinian timezone change at the last moment. How to change pgsql tz db? |
Previous Message | Ow Mun Heng | 2008-01-03 09:26:25 | [OT] Slony (initial) Replication - Slow |