On 09/04/2018 10:51 AM, David Steele wrote:
[snip]
This will work, but I don't think it's what Ron is getting at.
To be clear, it is not possible to restore a database into an *existing*
cluster using pgBackRest selective restore. This is a limitation of
PostgreSQL file-level backups.
To do what Ron wants you would need to restore it to a new cluster, then
use pg_dump to logically dump and restore it to whatever cluster you
want it in. This still saves time since there is less to restore but is
obviously not ideal.
That's exactly what I'm referring to.
Presumably I could restore it to a new cluster on the same VM via initdb on
a different port and PGDATA directory?
--
Angular momentum makes the world go 'round.
