Re: index numbers in pg_restore list

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Madin <ben(at)ausvet(dot)com(dot)au>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: index numbers in pg_restore list
Date: 2020-08-14 16:45:17
Message-ID: 648142.1597423517@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ben Madin <ben(at)ausvet(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Madin 2020-08-14 17:15:39 Re: index numbers in pg_restore list
Previous Message PegoraroF10 2020-08-14 16:34:09 Re: Server goes to Recovery Mode when run a SQL