Horton
Menu

Re: Database mirroring

Karel Zak <zakkr@zf.jcu.cz>

View thread
From: Karel Zak <zakkr@zf.jcu.cz>
To: Turbo Fredriksson <turbo@bayour.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-11-22T10:13:41Z
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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz