Re: Alternate locations of DB's

["Adam Lang" <aalang(at)rutgersinsurance(dot)com>]

But I think he wants to know how to have 3 different databases in three
different locations.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Wade D. Oberpriller" <oberpwd(at)anubis(dot)network(dot)com>
To: "Brian C. Doyle" <brian(at)jbbent(dot)com>
Cc: "general-help postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 26, 2000 10:16 AM
Subject: Re: [GENERAL] Alternate locations of DB's


> You must use initlocation to initialize the location and have the path to
the
> location in an environment variable before postmaster is started.
>
> For example:
>
> > setenv PGDATA2 /home/someuser/data
> > initlocation 'PGDATA2'
> > pg_ctl -D /home/pgsql/data start
> > createdb mydb -D 'PGDATA2'
>
> This will start postmaster with the knowlegde of the PGDATA2 environment
> variable. Then you can create databases in this alternate location.
> PostgreSQL can also be compiled with an option to allow absolute paths, so
>
> >createdb cdt -D /home/someuser/data
>
> can be done, but I forget the option. The user's manual describes all of
this
> under CREATEDB.
>
> Wade Oberpriller
> StorageTek
> oberpwd(at)network(dot)com
>
> >
> > Hello all,
> >
> > How do I get Postgresql to use independantly seperate db
> > locations.  Currently I have them under /home/user/database  and as long
as
> > i get postmaster to run with that same location I am fine but I want to
have
> > /home/user/database
> > /home/user1/database
> > /home/userr2/database
> > ect...
> >
> > But I can only get  one instance of the postmaster running at a time .
How
> > do i change that if i can!
> >
> >
> >