| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Turbo Fredriksson <turbo(at)bayour(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Database mirroring |
| Date: | 2001-11-22 10:13:41 |
| Message-ID: | 20011122111341.E5427@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Nov 22, 2001 at 10:31:04AM +0100, Turbo Fredriksson wrote:
> Is it possible to specify WHERE (on a filesystem) a certain database
> should be located?
>
> This would be nice to have when doing mirroring (with rServ for example).
> That way i can replicate/mirror a database on a different disk...
See docs about CREATE DATABASE statement and things pertinent to
this process.
CREATE DATABASE name
[ WITH [ LOCATION = 'dbpath' ]
^^^^^^^^^^^^^^^^^^^^^
[ TEMPLATE = template ]
[ ENCODING = encoding ] ]
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-11-22 11:01:54 | ALTER OR REPLACE feature |
| Previous Message | Hannu Krosing | 2001-11-22 09:49:19 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |