Re: pg_restore and create FK without verification check

Tom Lane wrote:

>>- how to restore a single database
>>
>>
>
>You don't. As I said, any physical backup is going to be
>all-or-nothing. These techniques are not a replacement for pg_dump.
>
>
>

That's sad. I've been backing up and restoring single databases from a
cluster frequently, so I'd really like the database to be selectable.

>That's part of the management code that we need to write before this
>will really be very useful; you need to be able to associate the
>starting time of a tar dump with the most recent previous CHECKPOINT
>in the WAL logs. Not hard in principle, just takes some code we ain't
>got yet.
>
>

So I lay back patiently (more or less :-)

Regards,
Andreas