Re: Can't make backup

>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/