Re: index numbers in pg_restore list

Thanks Tom and Adrian,

The clarity is helpful - We'll run up a solution to specifically choose the
elements.

cheers

Ben

On Sat, 15 Aug 2020 at 00:45, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>

--

[image: Ausvet Logo] <https://www.ausvet.com.au/>

Dr Ben Madin

BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
ben(at)ausvet(dot)com(dot)au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia