I have a database server running PostgreSQL 8.4 on Debian Linux and today we suffered a catastrophic hardware failure. The server literally died to a point we couldn't recover regardless of RAID. So now we've got two brand new identical Dell servers which I just performed the O.S. install on both systems but my question is it possible to replicate the data from PostgreSQL across the network to a slave PostgreSQL server?
I did do a search for clustering PostgreSQL however I think my terminology is off. Is there support for such a process and if so, has anyone done easy to follow write-ups?
I would recommend you upgrade to 9.x and use streaming replication with a hot or warm standby server.
Whether or not you need synchronous replication is something you need to decide. Synchronous means you will never lose any data, but the downside is that it has a performance impact on the main server.
If you start implementing that, I strongly recommend to subscribe to the Postgres mailing lists (-general and -admin)
You'll get excellent help there (directly from the developers!)