On 11/18/22 04:33, Joseph Kennedy wrote:
> I would like to copy databases from two different pg_basebackup backups
> to one lab environment database cluster on another server. Is it possible ?
>
> It's a good idea to do it in that way.
>
> Databases has your oid in pg_basebackup we can find it id in base
> directory for example:
> Is it a good or very bad idea ?
Bad idea.
For why see:
https://www.postgresql.org/docs/current/storage-file-layout.html
and
https://www.postgresql.org/docs/current/storage-page-layout.html
There is more to a cluster then what is found in a given databases
directory. You can't, at the file(binary) level, just rip a database out
of one cluster and graft it into another.
If you want to do this then the options are:
1) As Ron suggested dump/restore.
2) Setting up logical replication.
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com