[clug] Postgres sync / duplication

[David Tulloh]

Michael Carden wrote:
> My idea is that a link would be put in place for the purposes of synch-ing and 
> then removed.
> 
> I had hoped for (but admittedly not found in the docs) some inbuilt Postgres 
> function that lets one server synch itself with another. Because the two live 
> on different OSes, I'd hoped to avoid doing it at the filesystem level 
> because I just *know* I'll miss something.
> 

Postgres databases are generally copied using the pg_dump tool.  It
generates a plaintext file of SQL commands to recreate the database.
It's human readable, portable, ugly, huge and slow.

It might be a good start for what you are after.


David