There's two servers, a Primary Server and a Backup Server. Both have Postgres installed. The Primary Server has one database, and the Backup Server has two - one for a warm backup/standby of the Primary Server's database, and another for Training and whatnot.
I need a way to maintain a warm standby on a single database, the Backup Database, without using some sort of log-shipping method that will overwrite all the data on the Training Database.
I'm thinking about trying to use Streaming Replication. What I need to know is if I will be able to keep up a warm backup of the Primary Database on one database, without overwriting the Training Database on the machine.