Re: [GENERAL] Data checksum with pg upgradecluster

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: [GENERAL] Data checksum with pg upgradecluster
Дата
Msg-id trinity-c2e72d0a-80f4-419a-b997-c92c77eeedb3-1502023415857@3capp-gmx-bs24
обсуждение исходный текст
Ответ на [GENERAL] Data checksum with pg upgradecluster  (Dan <ganchya@gmail.com>)
Ответы Re: [GENERAL] Data checksum with pg upgradecluster
Список pgsql-general
> I'm updating my database from 9.4 to 9.6 (Debian Jessie to Stretch). I
> think that it is a good opportunity to turn on data checksum.
>
> I don't have experience with cluster creation or moving a DB to a new cluster.
>
> I'll use pg_upgradecluster, but I don't see any option to turn of data checksum.
>
> I took a look to the pg_upgradecluster script. I think that it invokes
> pg_createcluster. Therefore I think that I should get data checksums
> if I add in the file /etc/postgresql-common/createcluster.conf the
> following line:
> initdb_options = '--data-checksums'
>
> Is this correct?

Yes. Been there done that.

Karsten


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

Предыдущее
От: Dan
Дата:
Сообщение: [GENERAL] Data checksum with pg upgradecluster
Следующее
От: "Dan Cooperstock at Software4Nonprofits"
Дата:
Сообщение: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)