Re: postgres 9 streaming replication - Mailing list pgsql-bugs

From Khadtare, Sharad
Subject Re: postgres 9 streaming replication
Date
Msg-id 951D39B8B6185A4D852967EB943E7AE701CEA224@AOLE1AMEC31.ad.aol.aoltw.net
Whole thread Raw
In response to Re: postgres 9 streaming replication  (tushar <tushar.ahuja@enterprisedb.com>)
List pgsql-bugs
Hi Tushar,

Thx for immediate response.

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

Regards,
Sharad K
=20

-----Original Message-----
From: tushar [mailto:tushar.ahuja@enterprisedb.com]=20
Sent: Tuesday, January 25, 2011 3:36 PM
To: Khadtare, Sharad
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] postgres 9 streaming replication

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

Khadtare, Sharad wrote:
> Hi,
>=20=20
> Configured postgres 9 streaming replication and changed parameter in=20
> postgresql.conf & pg_hba.conf file
>=20=20
> Problem is wal sender & receiver process not started , is there any=20
> 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 =3D 32" to postgresql.conf of primary and standby.
4. Add "archive_mode =3D 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=3D
=3D/tIc
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: Fujii Masao
Date:
Subject: Re: postgres 9 streaming replication
Next
From: "Khadtare, Sharad"
Date:
Subject: Re: postgres 9 streaming replication