pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_dumpall error 2+ messages / 2 participants [nested] [flat]
* pg_dumpall error @ 2007-11-13 10:37 frant101@googlemail.com 0 siblings, 1 reply; 2+ messages in thread From: frant101@googlemail.com @ 2007-11-13 10:37 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dumpall error @ 2007-11-13 16:54 Tom Lane <tgl@sss.pgh.pa.us> parent: frant101@googlemail.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-11-13 16:54 UTC (permalink / raw) To: frant101@googlemail.com; +Cc: pgsql-admin frant101@googlemail.com writes: > 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. You mean that if you issue the same command by hand, it works? That would be bizarre. > We are running PostgreSQL 8.1.3 and the pg_dumpall command is Update to something current (preferably 8.1.10). Then try REINDEXing pg_class. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-13 16:54 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-11-13 10:37 pg_dumpall error frant101@googlemail.com 2007-11-13 16:54 ` Tom Lane <tgl@sss.pgh.pa.us>
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