Le mar. 8 janv., vers 11:26, Achilleas Mantzios exprimait : > On 8/1/19 11:01 π.μ., Stéphane KANSCHINE wrote: > > > > Le lun. 7 janv., vers 22:51, Natalie Wenz exprimait : > > > > > > I understand that the recommended, safest, approach would be to > > > dump/restore. We intend to do that wherever possible. > > > > It's not anymore since PostgreSQL have logical replication. You can > > initialize you FreeBSD cluster with a pg_basebackup and you follow > > updates with logical streaming. > > Hmm, maybe you mean pg_dump --schema-only? I cannot see how taking physical > copy with pg_basebackup will help with logical replication. You're right, it's useless and counterproductive. I'm still on holydays. But still, take a look at logical replication, it's way more efficient than pg_dump. -- Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./ ＠ stephane@xxxxxxxxx +33 6 64 31 72 52
