Re: Alternate locations of DB's (fwd) - Mailing list pgsql-general

From root Thu Oct 26 14:44:32 2000
Received: from storage.network.com (storage.network.com [129.191.1.4])
    by anubis.network.com (8.9.3/8.9.3) with ESMTP id OAA05733
    for <oberpwd@anubis.network.com>; Thu, 26 Oct 2000 14:44:29 -0500 (CDT)
Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194])
    by storage.network.com (8.9.3+Sun/8.9.3) with ESMTP id OAA21676
    for <oberpwd@anubis.network.com>; Thu, 26 Oct 2000 14:44:21 -0500 (CDT)
Received: from 6014cwpza006 ([10.10.10.51])
    by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id PAA25623
    for <oberpwd@anubis.network.com>; Thu, 26 Oct 2000 15:49:38 -0400
Message-ID: <001901c03f85$79a17ac0$330a0a0a@6014cwpza006>
From: "Adam Lang" <aalang@rutgersinsurance.com>
To: "Wade D. Oberpriller" <oberpwd@anubis.network.com>
References: <200010261941.OAA12497@truck.network.com>
Subject: Re: [GENERAL] Alternate locations of DB's
Date: Thu, 26 Oct 2000 15:46:45 -0400
MIME-Version: 1.0
Content-Type: text/plain;
    charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Archive-Number: 200010/1119

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@anubis.network.com>
To: "Adam Lang" <aalang@rutgersinsurance.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@network.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@anubis.network.com>
> > To: "Brian C. Doyle" <brian@jbbent.com>
> > Cc: "general-help postgresql" <pgsql-general@postgresql.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@network.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!
> > > >
> > > >
> > > >
> >
> >