Thread: pg_dump problem with PostgreSQL v7.1.2
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. '.
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
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
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: > > > 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
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
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