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...

-- 
 Turbo     __ _     Debian GNU     Unix _IS_ user friendly - it's just 
 ^^^^^    / /(_)_ __  _   ___  __  selective about who its friends are 
         / / | | '_ \| | | \ \/ /    Debian Certified Linux Developer  
  _ /// / /__| | | | | |_| |>  <  Turbo Fredriksson   turbo@bayour.com
  \\\/  \____/_|_| |_|\__,_/_/\_\         Gothenburg/Sweden

Uzi Nazi Rule Psix $400 million in gold bullion iodine pits AK-47 Cuba
Qaddafi subway tritium toluene NORAD Delta Force KGB
[See http://www.aclu.org/echelonwatch/index.html for more about this]

22 Nov 2001 10:31:04 +0100
Turbo Fredriksson <turbo@bayour.com>
Database mirroring
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

Thu, 22 Nov 2001 11:13:41 +0100
Karel Zak <zakkr@zf.jcu.cz>
Re: Database mirroring
Quoting Karel Zak <zakkr@zf.jcu.cz>:

> 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 ] ]

Cool, thanx!


Now my idea to replicate with rServ got a whole new meaning.

Could anyone make it easy for me, and give me some examples on how to use rServ
to syncronize/replicate to a remote database?

I successfully tried rServ to replicate to a db on the same host (using the
examples).

-- 
 Turbo     __ _     Debian GNU     Unix _IS_ user friendly - it's just 
 ^^^^^    / /(_)_ __  _   ___  __  selective about who its friends are 
         / / | | '_ \| | | \ \/ /    Debian Certified Linux Developer  
  _ /// / /__| | | | | |_| |>  <  Turbo Fredriksson   turbo@bayour.com
  \\\/  \____/_|_| |_|\__,_/_/\_\         Gothenburg/Sweden

South Africa counter-intelligence cryptographic Khaddafi class
struggle FSF Panama Uzi 767 tritium Saddam Hussein critical president
AK-47 munitions
[See http://www.aclu.org/echelonwatch/index.html for more about this]

22 Nov 2001 12:04:32 +0100
Turbo Fredriksson <turbo@bayour.com>
Re: Database mirroring
did yo take a look a the replication projects ?:
http://www.erserver.com/
http://pgreplicator.sourceforge.net/
http://gborg.postgresql.org/project/pgreplication/projdisplay.php

On 22 Nov 2001 12:04:32 +0100
Turbo Fredriksson <turbo@bayour.com> was typing:

> Could anyone make it easy for me, and give me some examples on how to use rServ
> to syncronize/replicate to a remote database?
> 
> I successfully tried rServ to replicate to a db on the same host (using the
> examples).

Wed, 28 Nov 2001 19:08:08 +0100
Jaume Teixi <teixi@6tems.com>
Re: Database mirroring