Re: pg_dump problem with PostgreSQL v7.1.2

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
inthe ../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