Fwd: Errors on pg_dumpall

From: Terry Khatri <terrykhatri531(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fwd: Errors on pg_dumpall
Date: 2012-11-01 14:05:38
Message-ID: CANH4f+h_iU7SZ+aoK36i18dFV6CH1Rx5-38dbqngoWUa8f-6Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Somebody PLEASE HELP ! is Tome Lane around !
Tks
T

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

Hi

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

-----

TK(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj Gandhi 2012-11-01 15:10:08 Re: Detecting DB corruption
Previous Message Gunnar "Nick" Bluth 2012-11-01 08:06:10 Re: Detecting DB corruption