Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Errors on pg_dumpall - Mailing list pgsql-admin

From Terry Khatri
Subject Fwd: Errors on pg_dumpall
Date
Msg-id CANH4f+h_iU7SZ+aoK36i18dFV6CH1Rx5-38dbqngoWUa8f-6Fg@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: Errors on pg_dumpall
Re: Fwd: Errors on pg_dumpall
Re: Fwd: Errors on pg_dumpall
List pgsql-admin
Tree view
Somebody PLEASE HELP ! is Tome Lane around !
Tks
T

---------- Forwarded message ----------
From: Terry Khatri <terrykhatri531@gmail.com>
Date: 22 October 2012 00:20
Subject: Errors on pg_dumpall
To: pgsql-admin-owner@postgresql.org


Hi

I am getting the following error msg when I do a pg_dumpall

-----

TK@OraLinux /usr/local/pgsql/backups
$ pg_dumpall -U sns84 > completebackup20121020,sql
pg_dump: schema with OID 74363 does not exist
pg_dumpall: pg_dump failed on database "bihistory", exiting

-----

I have set the logs to debug5 to catch where the problem is while taking the dump but nothing shows up there.

If you have any ideas please help me.

And thanks to all for responding to my earlier post.

Rgds
T




pgsql-admin by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: Detecting DB corruption
Next
From: Fernando Hevia
Date:
Subject: Re: Fwd: Errors on pg_dumpall