Re: postgres 9 streaming replication

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Khadtare, Sharad wrote:
> Hi,
>
> Configured postgres 9 streaming replication and changed parameter in
> postgresql.conf & pg_hba.conf file
>
> Problem is wal sender & receiver process not started , is there any way
> to check process please suggest.

1. Make no changes in pg_hba.conf of standby. Use the default one.
2. Add "host   replication    postgres          172.18.221.211/32   trust" to pg_hba.conf of primary.
3. Add "wal_keep_segments = 32" to postgresql.conf of primary and standby.
4. Add "archive_mode = off" to postgresql.conf of standby.

You can check if the WAL sender and receiver processes are running using ps command.



- --
regards,
tushar
Lead QA Engineer
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
www.enterprisedb.com




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFNPqCEfQNodY2PIRoRAuVjAJsFd0NN8lsHxbj4RQ2YE8thOWYMngCfcWgL
EBCVKLZb5JpKOAFr2gAggYA=
=/tIc
-----END PGP SIGNATURE-----