Re: Replication and Switchover - Mailing list pgsql-admin

From Christoph Berg
Subject Re: Replication and Switchover
Date
Msg-id aEMEoSPkw8HqEiPR@msg.df7cb.de
Whole thread Raw
In response to Replication and Switchover  (Sam Stearns <sam.stearns@dat.com>)
Responses Re: Replication and Switchover
List pgsql-admin
Re: Sam Stearns
> We would like to switchover the database that is ready now so we can start
> performing load testing against it.  Is it possible to switchover one
> database in a cluster while not switching over the other?

Create a second database cluster, and move one of the databases into
that cluster.

"Move" is either dump-restore, or a full restore of the old cluster
and dropping the other database.

Christoph



pgsql-admin by date:

Previous
From: Антон Глушаков
Date:
Subject: Re: order of pg_dump command "create sequence"
Next
From: Sam Stearns
Date:
Subject: Re: Replication and Switchover