Re: missing data
От | Peter Eisentraut |
---|---|
Тема | Re: missing data |
Дата | |
Msg-id | Pine.LNX.4.30.0103292136440.2091-100000@peter.localdomain обсуждение исходный текст |
Ответ на | missing data (Dave Perkins <drp@shore.net>) |
Ответы |
Re: missing data
|
Список | pgsql-general |
Dave Perkins writes: > I'm running postgresql 6.5 on Red Hat Linux 6.2 and have run into a > situation where I am able to open a database connection using psql yet > there is no trace of any tables in the database even though all the data > files are present when I browse the database directory. Depending on your definition of "no trace", this might work: Try select relname, relowner from pg_class; If this shows table names that sound familiar, then it is likely that the user indicated by "relowner" disappeared. Look into the table pg_shadow to make sure some user's usesysid column matches relowner. (It's safe to change these with update commands.) -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-general по дате отправления: