pg_dump problem with PostgreSQL v7.1.2

Dominick writes:

I keep the same message when trying to dump any database. I haven't a clue; consequently, I'd appreciate any help that you 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 an expression.
'.

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

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:

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

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:

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@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

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: