Re: How about putting distinct DB-schemas in extra DMBS

From: thomas(dot)revell(at)powerconv(dot)alstom(dot)com
To: pgsql-admin(at)postgresql(dot)org
Cc: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Subject: Re: How about putting distinct DB-schemas in extra DMBS
Date: 2005-03-03 12:50:06
Message-ID: OF64C84428.94EAB24A-ON80256FB9.0046493C-80256FB9.0046EA72@transport.alstom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)postgresql(dot)org

Just make sure you keep the backup directories for each postmaster
completely seperate, and you shouldn't have any problems at all.

:._______________
CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Hammond 2005-03-03 19:56:58 Re: How about putting distinct DB-schemas in extra DMBS instances
Previous Message Daniel Rubio 2005-03-03 12:49:54 Re: schema sizes