Re: Alternate locations of DB's

What's wrong with:

pg_ctl -D /some/place/number1 -o "-p 5432 -i"
pg_ctl -D /some/place/number2 -o "-p 5433 -i"
pg_ctl -D /some/other/place -o "-p 6432 -i"

Larry
* Adam Lang <aalang(at)rutgersinsurance(dot)com> [001026 14:33]:
> 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!
> > >
> > >
> > >

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749