| From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
|---|---|
| To: | "Khadtare, Sharad" <sharad(dot)khadtare(at)teamaol(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: postgres 9 streaming replication |
| Date: | 2011-01-25 10:05:56 |
| Message-ID: | 4D3EA084.8050201@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
-----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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2011-01-25 10:07:42 | Re: postgres 9 streaming replication |
| Previous Message | Khadtare, Sharad | 2011-01-25 08:01:08 | postgres 9 streaming replication |