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 wrote:
> Ben Madin writes:
> > " Is the index number ( the archive ID) assigned at the time of creation
> > of the archive and not
Ben Madin 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 cha
On 8/14/20 9:16 AM, Ben Madin wrote:
Dear all,
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, index
