Re: Alternate locations of DB's (fwd)
От | oberpwd@anubis.network.com (Wade D. Oberpriller) |
---|---|
Тема | Re: Alternate locations of DB's (fwd) |
Дата | |
Msg-id | 200010262023.PAA12650@truck.network.com обсуждение исходный текст |
Список | 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! > > > > > > > > > > > > > > > >
В списке pgsql-general по дате отправления: