Dear all,
--
![Ausvet Logo]( "Ausvet Website")
I was hoping for some quick guidance on the structure of the pg_restore list.
We have a database which we are restoring each day for a data warehouse. For efficiency, we are not restoring a number of tables and functions, just the tables, indexes and data.
(the database is being dumped on a postgresql 10.13 database, and restored on a 12.4)
To do this we had been using a template list file, with the items we wanted (around 1900 of them) However, after a week or so it started failing with a message the ID 9601 was missing. on checking this was:
9601; 0 19580 TABLE DATA backoffice animalid angus
when we ran the list option on the dump, the above row was present, but the index number is now 9602 (this was previously something else).
The text in the manual pages notes:
the numbers at the start of lines refer to the internal archive ID assigned to each item.
we were under the impression that this number was like an oid? I guess then my question is:
" 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?"
If this is mutable, I presume we need to write a script to grep the lines we need out of the list of the current dump, not re-use the same list file?
cheers
Ben
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
