Re: [GENERAL] Alternate locations of DB's

You can do that with createdb? If so, I guess that is the answer he would
be looking for. Make sure to post it to the list.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Wade D. Oberpriller" <oberpwd(at)anubis(dot)network(dot)com>
To: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
Sent: Thursday, October 26, 2000 3:41 PM
Subject: Re: [GENERAL] Alternate locations of DB's

> I don't know why you couldn't:
>
>
> > setenv PGDATA1 /home/user1/data
> > setenv PGDATA2 /home/user2/data
> > setenv PGDATA3 /home/user3/data
> > initlocation 'PGDATA1'
> > initlocation 'PGDATA2'
> > initlocation 'PGDATA3'
> > pg_ctl -D /home/pgsql/data start
> > createdb db1 -D 'PGDATA1'
> > createdb db2 -D 'PGDATA2'
> > createdb db3 -D 'PGDATA3'
>
> You can have as many as you like, I believe.
>
> Wade Oberpriller
> StorageTek
> oberpwd(at)network(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!
> > > >
> > > >
> > > >
> >
> >