[clug] Postgres sync / duplication
david at tulloh.id.au
Sun May 7 04:57:36 GMT 2006
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.
More information about the linux