>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! >> >> I don't have any table called pg_locks in pg_catalog.
It is a view. > 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. > >Is there any row in pg_locks that has a "false" in "granted"? >That would be a wait for a lock to be released. > >Does pg_dump consume any processor cycles? > >You say "Windows Programmed pg_dump" - what exactly is that? >Can you use a debugger to see where your program hangs? > >Yours, >Laurenz Albe -- I don't know how it is "Tareas programadas" in english, I have Windows in spanish, but it's the tool where yuo set a work to execute in a determinated time. We call a .bat that execute pg_dump: "C:\Archivos de programa\PostgreSQL\8.2\bin\pg_dump.exe" -i -h 192.168.0.1 -p 5432 -U MyUser -F c -b -v -f "C:\back\pd_dump\si\si.backup" MyDB -- >Erik Jones wrote: >The pg_locks view most certainly exists. Here's the list of all of >the system catalog tables and view: http://www.postgresql.org/docs/ >8.2/interactive/catalogs.html. If you haven't looked at pg_locks how >do you know "there were a lot of locks"? With the Server Status in the pg Admin III. Thanks Sebastián --------------------------------- 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/
