Porstgress forgot all ! Help !
Porstgress forgot all ! Help !
От:
Jean-Arthur Silve <jeanarthur@eurovox.fr>
Дата:
Hi ! I did a pgdump on a database. It was ok After, all tables have dissapeard ,even those in other databases ! when I check in the data directories, all datas are here, but in pg_class, there is no more tables ! (except system tables !) Is there a way to retrieve my lost tables ????? jean-arthur ---------------------------------------------------------------- Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.
precisions on : Porstgress forgot all ! Help !
От:
Jean-Arthur Silve <jeanarthur@eurovox.fr>
Дата:
when i do a vacuum, i see in debug message that my datas are there (1800 tuples etc...) when i do a select..0 rows ! when i try to insert a data with a duplicate key, i ve got the message that postgres cannot insert a duplcate key... so my datas are here..but i can't see them !! helpp!! At 14:12 12/02/01 +0100, Jean-Arthur Silve wrote: >Hi ! > >I did a pgdump on a database. It was ok > >After, all tables have dissapeard ,even those in other databases ! > >when I check in the data directories, all datas are here, but in pg_class, >there is no more tables ! (except system tables !) > >Is there a way to retrieve my lost tables ????? > >jean-arthur >---------------------------------------------------------------- >Le simple fait de passer par la fenetre ne suffit pas a la transformer en >porte. ---------------------------------------------------------------- Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.