Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DDD692E096D for ; Tue, 13 Nov 2007 06:44:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33475-09 for ; Tue, 13 Nov 2007 06:44:06 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 99C732E08D3 for ; Tue, 13 Nov 2007 06:44:05 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lADAi19r006633 for ; Tue, 13 Nov 2007 06:44:01 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lADAbqXM005524 for pgsql-admin@postgresql.org; Tue, 13 Nov 2007 06:37:52 -0400 (AST) (envelope-from news) From: frant101@googlemail.com X-Newsgroups: pgsql.admin Subject: pg_dumpall error Date: Tue, 13 Nov 2007 02:37:55 -0800 Organization: http://groups.google.com Lines: 26 Message-ID: <1194950275.303346.276410@v3g2000hsg.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: v3g2000hsg.googlegroups.com; posting-host=213.249.208.130; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/103 X-Sequence-Number: 27346 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