- 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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
