Re: Postmaster environment variables - Mailing list pgsql-admin

From Fouad Fezzi
Subject Re: Postmaster environment variables
Date
Msg-id 072101c21eb6$2f86a6b0$a3d839c2@PCFOUAD
Whole thread Raw
In response to Postmaster environment variables  (daniel m <dmeil@acer-access.com>)
List pgsql-admin
Hi daniel

how do you  start postmaster  is it with -D ?
If you don't fix problem i can send you script in debian that work with
PGDATA variable.

Fouad

----- Original Message -----
From: "daniel m" <dmeil@acer-access.com>
To: <pgsql-admin@postgresql.org>
Sent: Friday, June 28, 2002 4:23 AM
Subject: [ADMIN] Postmaster environment variables


> I am trying to relocate my database,  as per instructions in the manual:
>
> Under user postgres :
>
> sh-2.04$ PGDATA2=/home/postgres/data
> sh-2.04$ export PGDATA2
> sh-2.04$ echo $PGDATA2
> /home/postgres/data
>
> I stop the postmaster and :
> sh-2.04$ /usr/lib/postgresql/bin/initlocation PGDATA2
> The location will be initialized with username "postgres".
> This user will own all the files and must also own the server process.
>
> Fixing permissions on pre-existing directory /home/postgres/data
> Fixing permissions on pre-existing directory /home/postgres/data/base
>
> initlocation is complete. (...)
>
> I restart the postmaster and :
>
> sh-2.04$ createdb planifgr -D 'PGDATA2'
> ERROR:  Postmaster environment variable 'PGDATA2' not set
> createdb: database creation failed
>
> although :
>
> sh-2.04$ echo $PGDATA2
> /home/postgres/data
>
> I even tried to set the variable from within the scripts (debian distr.)
> that start the backend (etc/init.d/postgresql). Same response.
>
> Where is the variable?
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Are statistics gathered on function indexes?
Next
From: Ray Ontko
Date:
Subject: Re: Are statistics gathered on function indexes?