Re: postgres 9 streaming replication

Hi Tushar,

Thx for immediate response.

I verified with ps commmand and there is no process running on host.

Regards,
Sharad K

-----Original Message-----
From: tushar [mailto:tushar(dot)ahuja(at)enterprisedb(dot)com]
Sent: Tuesday, January 25, 2011 3:36 PM
To: Khadtare, Sharad
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] 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-----