Thread: pg_dump problem with PostgreSQL v7.1.2

pg_dump problem with PostgreSQL v7.1.2

From
Dominick
Date:
I keep the same message when trying to dump any database. I haven't a clue; consequently, I'd appreciate any help that
youcould provide. 

postgres@ibook:/usr/local/pgsql/bin > ./pg_dump -o discuss -f /tmp/ibook_discuss_db

getDatabase(): SELECT failed.  Explanation from backend: 'ERROR:  More than one tuple returned by a subselect used as
anexpression. 
'.

Re: pg_dump problem with PostgreSQL v7.1.2

From
Peter Eisentraut
Date:
Dominick writes:

> I keep the same message when trying to dump any database. I haven't a clue; consequently, I'd appreciate any help
thatyou could provide. 
>
> postgres@ibook:/usr/local/pgsql/bin > ./pg_dump -o discuss -f /tmp/ibook_discuss_db
>
> getDatabase(): SELECT failed.  Explanation from backend: 'ERROR:  More than one tuple returned by a subselect used as
anexpression. 
> '.

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


Re: pg_dump problem with PostgreSQL v7.1.2

From
Dominick
Date:
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?


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

Re: pg_dump problem with PostgreSQL v7.1.2

From
Peter Eisentraut
Date:
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@gmx.net   http://funkturm.homeip.net/~peter
>
>

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Re: pg_dump problem with PostgreSQL v7.1.2

From
Dominick
Date:
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?


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

Re: pg_dump problem with PostgreSQL v7.1.2

From
Peter Eisentraut
Date:
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


Re: pg_dump problem with PostgreSQL v7.1.2

From
Dominick
Date:
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