Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-05 Thread Tom Lane
Terry Khatri writes: > Okay, I have found a reference to that oid in pg_type as under : > select * from pg_type where typnamespace=74363 ; Okay, so you have a composite type named "city" (either a table's rowtype, or a standalone composite type --- hard to tell from just this entry) that somehow

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-05 Thread Terry Khatri
Hi Okay, I have found a reference to that oid in pg_type as under : select * from pg_type where typnamespace=74363 ; -[ RECORD 1 ]--+- typname | city typnamespace | 74363 typowner | 10 typlen | -1 typbyval | f typtype | c typcategory | C typispreferred | f typisdefined |

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-05 Thread Lukasz Brodziak
2012/11/3 Craig Ringer : > On 11/01/2012 10:05 PM, Terry Khatri wrote: > > Somebody PLEASE HELP ! is Tome Lane around ! > > > http://www.postgresql.org/support/professional_support/ Hi, Run the following SELECT on the database: select oid,* from pg_namespace this will bring up all the schemas in

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-02 Thread Craig Ringer
On 11/01/2012 10:05 PM, Terry Khatri wrote: > Somebody PLEASE HELP ! is Tome Lane around ! > http://www.postgresql.org/support/professional_support/

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-02 Thread raghu ram
> > > 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 > > - >

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-01 Thread Fernando Hevia
Oops. You were posting to the right list. I took it for the pgAdmin list. Sorry. :) On Thu, Nov 1, 2012 at 6:06 PM, Fernando Hevia wrote: > You are posting to the wrong list. > You should address this in the > pgsql-admin > list. > > > > > On Thu,

Re: [ADMIN] Fwd: Errors on pg_dumpall

2012-11-01 Thread Fernando Hevia
You are posting to the wrong list. You should address this in the pgsql-admin list. On Thu, Nov 1, 2012 at 11:05 AM, Terry Khatri wrote: > Somebody PLEASE HELP ! is Tome Lane around ! > Tks > T > > -- Forwarded message -- > From: Te

[ADMIN] Fwd: Errors on pg_dumpall

2012-11-01 Thread Terry Khatri
Somebody PLEASE HELP ! is Tome Lane around ! Tks T -- Forwarded message -- From: Terry Khatri Date: 22 October 2012 00:20 Subject: Errors on pg_dumpall To: pgsql-admin-ow...@postgresql.org Hi I am getting the following error msg when I do a pg_dumpall - TK@OraLinux /usr/l