Databases there, tables away
От | KÖPFERL Robert |
---|---|
Тема | Databases there, tables away |
Дата | |
Msg-id | ED4E30DD9C43D5118DFB00508BBBA76EB1665A@neptun.sonorys.at обсуждение исходный текст |
Ответы |
Re: Databases there, tables away
|
Список | pgsql-admin |
Hi, I am concerned. I played around with test database clusters of postgres. I wanted to simulate a WAL-Replay. So what I did was: I have a data dir, where some databases exist. I stressed them to produce a couple of Wal files. Then I shut down postgres (SIGQUIT *hm*) created + initdb'ed another dir put the wal files in the pg_xlog restarted the server on the new dir. I made it wrong, so forget this dir and shut down postgres So restarting postgres on the former data directory lead to the situation where all databases exist but with no objects populated. No table no function. What can hav happened? It is not do bar that someone else did something. But what can happen do a data dir if postgres is run on another dir? There's nothing lost, but I want to unterstand that
В списке pgsql-admin по дате отправления: