Re: Replaying xlogs from beginning

Поиск
Список
Период
Сортировка
От otheus uibk
Тема Re: Replaying xlogs from beginning
Дата
Msg-id CALbQNd24fUh0-Q4d=qCGfs5QTADm485k1ABZLZB5tMeFwx0gOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replaying xlogs from beginning  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


You're assuming that the only significant aspect of initdb's output that can vary from run to run is the database system ID.

I prefer to call it "optimistic prediction". But yes. :)

> If you're lucky this technique will work, but it's not reliable and not supported.  You really need to take an initial base backup after running initdb.

Thanks, but it's too late in retrospect.  Since that is the case, to whom can I make a feature request that initdb have an implicitly enabled option to make this base backup?

OK, back to question. Provided the system is the same, the postgresql executable and libraries are identical, the locales are unchanged, we have:

1.  bitwise variances in the system catalog

-- can be solved with David's suggestion of full dump/restore after the steps I listed. Confer?

2.  other things you couldn't think of yet.

-- anything come to mind yet?

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

Предыдущее
От: Daniel Gallo
Дата:
Сообщение: How Restricting user
Следующее
От: Ben Primrose
Дата:
Сообщение: Re: CTE and function