| From: | Sebastián Baioni <sebaioni-postgresql(at)yahoo(dot)com(dot)ar> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Can't make backup |
| Date: | 2007-12-31 12:15:21 |
| Message-ID: | 931317.44588.qm@web36112.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
We are running PostgreSQL 8.2.5 on amd64-portbld-freebsd6.2. We have 2 databases, one is a small one (and the pg_dump works ok) and the other one with 14,553,106 rows (the larget table has 3,700,000 rows).
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.
Do we need to configure the server to be able to make a backup as we used to do it with 8.0 version?
Thanks.
Sebastián
---------------------------------
Yahoo! Encuentros
Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros.
Visitá http://yahoo.cupidovirtual.com/servlet/NewRegistration
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vincent.moreau | 2007-12-31 14:45:57 | Mandatory AS keyword in SELECT statements |
| Previous Message | Tom Lane | 2007-12-30 16:10:00 | Re: Cluster table |