[Pgpool-general] What is the recommended way to migrate a DB to replicate it with pgpool
Christian Nolte
ch.nolte at noltec.org
Wed Aug 8 20:23:51 UTC 2007
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Felix J. Ogris schrieb:
> Hi,
>
>> Let's say the postgresql admin is the only user active on the source
>> backend during the replication. As WAL is already enabled on that host I
>> guess a server restart would make sure that the tx-logs are synced, or
>
> yip, the source node has to be shut down for the pg_xlogs written to disk.
>
>> am I wrong here? Would a dump ( made to the destination backend (not
>> using pgpool, but directly through postgresql) then be save, or is the
>> WAL-method you've described necessary for some other reason?
>
> If nobody modifies the source database meanwhile, then pg_dump / pg_restore
> will do the job. The WAL method just minimizes downtime and time needed for
> the actual copy, probably.
Ok then, thank you! I will try both methods in a test environment before
letting it go productive.
- --
For more than 4 generations the IT Professionals were the
guardians of quality and stability in software. Before the
dark times. Before Microsoft...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFGuiZXCNjA0nfhW7wRAguaAJ97DhxEgDNCYsWBQoT8YwaHuregbQCg/sPg
gu46B1TXMZEluRLhEPMneoY=
=C5tP
-----END PGP SIGNATURE-----
More information about the Pgpool-general
mailing list