Streaming Replication on a Single Database
I have an environment set up like so: There is one primary server that has one database, and one backup server that has two databases - a database intended as a warm backup to the primary server, and a second database for use as a training database.
I want to set up a system where that's possible - having a db on the primary server, and a db on the backup server, and them being just about the same because the db on the backup needs to be a warm backup of the primary db.
However, I want the backup db and the primary db to be synced, WITHOUT losing any of the data for the training db. I know that doesn't work with log based file shipping, because that syncs two postgres systems, not two databases.
Does streaming replication make this possible?