Streaming Replication on a Single Database
Results 1 to 4 of 4

Thread: Streaming Replication on a Single Database

  1. #1
    Join Date
    Jan 2012

    Question 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?

  2. #2
    Join Date
    May 2014
    I believe you can do what you are trying to do with streaming replication, though I'd have to try it. A second option you could try is to run two instances of Postgres on the backup as the streaming replication target and the other as your training database. It isn't ideal, but it should work.

  3. #3
    Join Date
    Feb 2014
    Riviera Beach, Maryland, USA
    Note that the OP was looking for a solution 2 years, 3 months, 4 weeks and 1 day ago.
    \____________________ ____.-.____ ____________________/
    \_____________\ -._)!(_.- /_____________/
    \_______\. ~\ /~ ./_______/

  4. #4
    Join Date
    May 2014
    Wow. I should have caught that. I was mistaken to begin with. You can do what he is wanting with Slony, but not with Streaming Replication.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts