From: | "Adam Lang" <aalang(at)rutgersinsurance(dot)com> |
---|---|
To: | |
Cc: | "general-help postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Alternate locations of DB's |
Date: | 2000-10-26 18:41:27 |
Message-ID: | 007f01c03f7c$71771ca0$330a0a0a@6014cwpza006 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
> >
> >
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Robert D. Nelson | 2000-10-26 18:51:00 | RE: Postgres 7.0.2-2 on Red Hat 7.0? |
Previous Message | J B Bell | 2000-10-26 17:24:42 | Re: Vexing DBD::Pg problem |