Re: [GENERAL] Can't restart Postgres

Поиск
Список
Период
Сортировка
От Shawn Thomas
Тема Re: [GENERAL] Can't restart Postgres
Дата
Msg-id 4049504B-D235-4081-AAE8-A8CCD9E329ED@u.washington.edu
обсуждение исходный текст
Ответ на Re: [GENERAL] Can't restart Postgres  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: [GENERAL] Can't restart Postgres
Список pgsql-general
Which would you recommend?  Leave the data directory in place and re-install PG or copy it to somewhere else, delete it and then re-install PG?

-Shawn

On Feb 15, 2017, at 9:36 AM, Magnus Hagander <magnus@hagander.net> wrote:

On Wed, Feb 15, 2017 at 6:28 PM, Shawn Thomas <thomassd@u.washington.edu> wrote:
Well that would make more sense of things.  I had removed and re-installed the postresql-common package:


and thought that it would leave the main PG package in place.  But perhaps I was wrong.  I’ll follow Tom’s advice and just re-install everything (saving the old data directory) and hope the new installation can use the old data data directory.

If you removed it and then installed it, then the removal would remove all dependent packages and if you then only intalled that one and not the dependencies that would explain it.

If you had run a reinstall on it, then it would've kept them around.

 
One question about this approach though:  the Debian package installation automatically initializes the new data directory and starts PG.  If I shut it down and copy the old data directory into the newly installed one, will there be an xlog issue?

You have to copy the xlog along with the database.

Or if you leave it in place where it is, the packages won't initialize a new data directory.

--

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Can't restart Postgres
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Can't restart Postgres