From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Moving several databases into one database with several schemas |
Date: | 2012-09-05 18:30:18 |
Message-ID: | BLU0-SMTP4476673BF2DD21000169FCCCFA90@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear list,
_*Scenario:*_
I'm using PostgreSQL 9.1 on Linux x64 running over CentOS 5. Everything
is fine, but now I do have 4 separate databases running on different
servers, and every server has some shared tables.
I've been working on a complex logic that is able to "replicate" these
tables in a way that is almost impossible to use existing solutions
(I've to merge records when replicating). My conclusion is that the
logic is just too complex to maintain, and I would like to consolidate
databases but keep data separate. Few days ago, I've posted this query
in this list, and got the orientation to try using schemas.
That's what I want to do know: I would like to consolidate these 4
separate databases in 1 database with 5 schemas:
- Main schema: will have all shared tables, that will be read only most
of time;
- Schema1 to Schema4: will have their own tables, read write.
_*Now the questions:*_
1) Is there a way to "backup" database1 and "restore" in the
consolidated database, but in "schema1" (not overwriting everything)?
2) Is there a way to specify the default schema in JDBC url (or command
I can issue to change the default schema at runtime, like "set path...")?
Thanks in advance,
Edson Richter
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksey Tsalolikhin | 2012-09-05 18:44:45 | Re: postgres process got stuck in "notify interrupt waiting" status |
Previous Message | Sahagian, David | 2012-09-05 18:04:36 | Re: values from txid_current() |