Re: pg_dump problem with PostgreSQL v7.1.2

THANK YOU SO VERY, VERY MUCH!!!

I just dumped all my data bases on the 7.1.2 version. After I encrypt my data, and archive it off site, I'll be able to
eatmy breakfast, lunch and dinner all at once, and catch a movie. :) 

I take it that PostgreSQL has changed the way it stores the info, as there used to be a pg_shadow file/table in the
../pgsqlsubdirectory in the 6.5.3 version, but now it's stored with each DB??? 

THANKS AGAIN!!!


Peter Eisentraut wrote:
>
> Dominick writes:
>
> > Can I create or generate this "TABLE" somehow???
> >
> > Since it doesn't APPEAR to be on the system, how is preventing the pg_dump from working properly?
>
> It most certainly is there.  Try SELECT * FROM pg_shadow; and look at the
> usesysid column.
>
> >
> >
> > Peter Eisentraut wrote:
> > >
> > > Dominick writes:
> > >
> > > > I can't find a pg_shadow file anywhere on my system with the 7.1.2 version, but my other box running 6.5.3 has
itin the ../pgsql directory. 
> > > >
> > > > Can I create or generate this file somehow?
> > >
> > > It's not a file, it's a table.
> > >
> > > >
> > > >
> > > > Peter Eisentraut wrote:
> > > > >
> > > > > You have more than one user in pg_shadow with the same id.  Assign a
> > > > > different id to one of them.
> > > > >
> > > > > --
> > > > > Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
> > > >
> > > >
> > >
> > > --
> > > Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >
>
> --
> Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter