From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Can I run two Postgres sessions at the same time? |
Date: | 2005-06-27 18:00:59 |
Message-ID: | 5.2.1.1.0.20050627135522.00aa5e30@pop6.sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
At 12:36 PM 6/27/05, Steve Poe wrote:
>I have a small business I am helping with their Postgresql server. They
>may need to move one of two databases onto a seperate disk system. They
>don't want another physical server. Can I run two postmasters pointing
>to different disk areas
>(i.e. /usr/local/db1/data , /usr/local/db2/data)? Can they be on the
>same port?
Your example shows two data directories (which contain subdirectories for
databases), but your question was about moving a database, not a data
directory. If you want to move one database to another disk, you can do
that without much trouble...
- stop postmaster
- move database directory to new disk system
- create link from old db2 location to new disk system
- restart postmaster
Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Joel da Silva | 2005-06-27 20:08:14 | PostGis Extension |
Previous Message | Andreas | 2005-06-27 17:52:44 | Re: DANGER Windows version might hurt you |