-----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-----