Re: index numbers in pg_restore list - Mailing list pgsql-general

From Tom Lane
Subject Re: index numbers in pg_restore list
Date
Msg-id 648142.1597423517@sss.pgh.pa.us
Whole thread Raw
In response to index numbers in pg_restore list  (Ben Madin <ben@ausvet.com.au>)
Responses Re: index numbers in pg_restore list
List 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 by date:

Previous
From: PegoraroF10
Date:
Subject: Re: Server goes to Recovery Mode when run a SQL
Next
From: Ben Madin
Date:
Subject: Re: index numbers in pg_restore list