Re: index numbers in pg_restore list

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index numbers in pg_restore list
Дата
Msg-id 648142.1597423517@sss.pgh.pa.us
обсуждение исходный текст
Ответ на index numbers in pg_restore list  (Ben Madin <ben@ausvet.com.au>)
Ответы Re: index numbers in pg_restore list  (Ben Madin <ben@ausvet.com.au>)
Список pgsql-general
Ben Madin <ben@ausvet.com.au> writes:
> " Is the index number ( the archive ID)  assigned at the time of creation
> of the archive and not otherwise related to the item in the
> original database?"

Yes, it's just assigned internally during pg_dump.  I think the numbers
would hold still as long as you make no DDL changes in the database, but
as soon as you do, all bets are off.

            regards, tom lane



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

Предыдущее
От: PegoraroF10
Дата:
Сообщение: Re: Server goes to Recovery Mode when run a SQL
Следующее
От: Ben Madin
Дата:
Сообщение: Re: index numbers in pg_restore list