high availability for a lamp app

[anandx]

Hi,

I have a single server running a lamp app (apache+php+postgresql), for which i want to do high availability with 2 servers instead of the present 1.

Now i have seen howtos for apache and php setup, and mysql master-slave, however haven't seen any master-slave / replication howtos for postgresql. Does anyone have any experience / any pointers on how it can be achieved ?

Thanks

[falko]

I haven't tried this with PostgreSQL yet, so I don't know if/how it can be done.

[anandx]

I haven't tried this with PostgreSQL yet, so I don't know if/how it can be done.
Thanks for the reply. I have been googling on this, have come across couple of implementations, will go through them. Incase i am successfully able to implenment anything, i will post a howto. Could help someone else ;)

[marpada]

Check this

http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Poolin g