pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Hammond <ahammond@ca.afilias.info>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: How about putting distinct DB-schemas in extra DMBS instances
Date: Thu, 03 Mar 2005 14:56:58 -0500
Message-ID: <42276C0A.6090401@ca.afilias.info> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB1660B@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB1660B@neptun.sonorys.at>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

We do this extensively at Afilias. It is an effective approach has the
associated cost of increasing the level of complexity of your systems.

I'll speak to the higher ups about posting the script we use to manage
multiple postgres instances in production.

- --
Andrew Hammond    416-673-4138    ahammond@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A


KÖPFERL Robert wrote:
| Hi,
|
| we are fascinated about the point in time recovery feature. In order
to have
| that feature for each database(schema) extra and to make them disturb each
| other even less, we would like to run several postmasters. So for each
| DB-schema (3) there should be an extra DBMS running (in an own PGDATA
dir).
|
| Is that possible (of course, I think)?
| But is that really what we want or will that make just more problems than
| use?
| Where's special care needed, Questions all over?
| Answer anything.
|
|
|
| Thanks.
|
| ---------------------------(end of broadcast)---------------------------
| TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFCJ2wIgfzn5SevSpoRAppNAKCNJZl9hIYR2Emaxozu4cxNeWtNzQCdEb2I
XwK5c8PeHYDxPibcCPWsJdQ=
=s51R
-----END PGP SIGNATURE-----



view thread (3+ messages)

Message-ID: <42276C0A.6090401@ca.afilias.info>
Permalink:  ../42276C0A.6090401@ca.afilias.info/
Also on:    postgresql.org/message-id/42276C0A.6090401@ca.afilias.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: ahammond@ca.afilias.info, robert.koepferl@sonorys.at
  Subject: Re: How about putting distinct DB-schemas in extra DMBS instances
  In-Reply-To: <42276C0A.6090401@ca.afilias.info>
  References: <ED4E30DD9C43D5118DFB00508BBBA76EB1660B@neptun.sonorys.at> <42276C0A.6090401@ca.afilias.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox