Re: stopping "wal"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: stopping "wal"
Дата
Msg-id 21480.1013526979@sss.pgh.pa.us
обсуждение исходный текст
Ответ на stopping "wal"  (Manuel Trujillo <manueltrujillo@dorna.es>)
Ответы Re: stopping "wal"
Список pgsql-admin
Manuel Trujillo <manueltrujillo@dorna.es> writes:
> When more or two or three processes are working, and I stop the
> database, if I have any problem stopping the DB, I kill the backends (is
> a tester machine).

This is a bad idea.

> When I start the process "postmaster", the wal make a "recover of
> processes", returning to the last situation.
> I would like to know how to "say" to postmaster don't make a "recover"
> from the wal files.

And this would be worse.

If you don't care about your data, you can "initdb" to get rid of the
messed-up database.  If you do care, you shouldn't be doing any of the
above.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: "sreedhar"
Дата:
Сообщение: I could not able to install "ActiveTcl8.3.4.2-1-win32-ix86" on my Windows-NT client.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: problem with view/function after upgrade to 7.2