Re: Can't make backup - Mailing list pgsql-general

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