From: frant101@googlemail.com
To: pgsql-admin@postgresql.org
Subject: pg_dumpall error
Date: Tue, 13 Nov 2007 02:37:55 -0800
Message-ID: <1194950275.303346.276410@v3g2000hsg.googlegroups.com> (raw)
Hi there, I hope that you can help
I am getting the following error message when i run the pg_dumpall
command
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation
"esales.invoiceline" does not exist
pg_dump: The command was: LOCK TABLE esales.invoiceline IN ACCESS
SHARE MODE
pg_dumpall: pg_dump failed on database "hermes", exiting
The esales.invoiceline table is there are can be accessed. We do run
overnight updates to this table and i was wondering if the updates are
conflicting with backup processs ?
We are running PostgreSQL 8.1.3 and the pg_dumpall command is
pg_dumpall -s --disable_triggers -h $CURRENT_HOST -U USER_AUTH >
schema.sql
Any help would be really appriceated.
Thanks
Fran
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: frant101@googlemail.com
Subject: Re: pg_dumpall error
In-Reply-To: <1194950275.303346.276410@v3g2000hsg.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox