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 eat my 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 ../pgsql subdirectory 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 it in 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
> > > >
> > > >
> > >
> > > --
> > > Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
> >
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter