Thread

1. Database mirroring

   Turbo Fredriksson <turbo@bayour.com> — 2001-11-22T09:31:04Z

   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]
   
   

2. Re: Database mirroring

   Karel Zak <zakkr@zf.jcu.cz> — 2001-11-22T10:13:41Z

   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
   
   

3. Re: Database mirroring

   Turbo Fredriksson <turbo@bayour.com> — 2001-11-22T11:04:32Z

   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]
   
   

4. Re: Database mirroring

   Jaume Teixi <teixi@6tems.com> — 2001-11-28T18:08:08Z

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