[ADMIN] PG 9.0 Replcation

2011-03-31 Thread Rangi, Jai
All, I have PG 9.03 setup with master slave native replication. Everything seems to be fine. I have few question or concerns. Coming from MySql background, so trying to setup my expectations for PG. 1. Very Large wal log size. Specially archiving WAL is bigger pain. In our env, the

[ADMIN] Postgres Replication Options

2011-02-08 Thread Rangi, Jai
Hello, I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How about slony? Which option will keep the slave nodes in

Re: [ADMIN] Pgsql Training.

2010-03-16 Thread Rangi, Jai
Chander Ganesan Sent: Tuesday, March 16, 2010 1:39 PM To: Rangi, Jai Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Pgsql Training. Rangi, Jai wrote: > > All, > > Just signed up on the list. We are in the process of adopting pgsql > over mysql. I was wondering if someone

[ADMIN] Pgsql Training.

2010-03-16 Thread Rangi, Jai
All, Just signed up on the list. We are in the process of adopting pgsql over mysql. I was wondering if someone can suggest any reasonably priced training for pgsql Administration and development. We are in southern CA. So anything closer to LA will be convenient and preferred. There is lots of