Re: pg_dump problem with PostgreSQL v7.1.2
От | Peter Eisentraut |
---|---|
Тема | Re: pg_dump problem with PostgreSQL v7.1.2 |
Дата | |
Msg-id | Pine.LNX.4.30.0107152344200.677-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: pg_dump problem with PostgreSQL v7.1.2 (Dominick <haystack@email.rentzone.org>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: