pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How about putting distinct DB-schemas in extra DMBS instances 3+ messages / 3 participants [nested] [flat]
* How about putting distinct DB-schemas in extra DMBS instances @ 2005-03-03 12:37 KÖPFERL Robert <robert.koepferl@sonorys.at> 0 siblings, 1 reply; 3+ messages in thread From: KÖPFERL Robert @ 2005-03-03 12:37 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How about putting distinct DB-schemas in extra DMBS @ 2005-03-03 12:50 thomas.revell@powerconv.alstom.com 0 siblings, 0 replies; 3+ messages in thread From: thomas.revell@powerconv.alstom.com @ 2005-03-03 12:50 UTC (permalink / raw) To: pgsql-admin; +Cc: KÖPFERL Robert <robert.koepferl@sonorys.at> 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 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How about putting distinct DB-schemas in extra DMBS instances @ 2005-03-03 19:56 Andrew Hammond <ahammond@ca.afilias.info> parent: KÖPFERL Robert <robert.koepferl@sonorys.at> 0 siblings, 0 replies; 3+ messages in thread From: Andrew Hammond @ 2005-03-03 19:56 UTC (permalink / raw) To: KÖPFERL Robert <robert.koepferl@sonorys.at>; +Cc: pgsql-admin -----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----- ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-03-03 19:56 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-03-03 12:37 How about putting distinct DB-schemas in extra DMBS instances KÖPFERL Robert <robert.koepferl@sonorys.at> 2005-03-03 19:56 ` Andrew Hammond <ahammond@ca.afilias.info> 2005-03-03 12:50 Re: How about putting distinct DB-schemas in extra DMBS thomas.revell@powerconv.alstom.com
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