Re: Postmaster environment variables
От | Fouad Fezzi |
---|---|
Тема | Re: Postmaster environment variables |
Дата | |
Msg-id | 072101c21eb6$2f86a6b0$a3d839c2@PCFOUAD обсуждение исходный текст |
Ответ на | Postmaster environment variables (daniel m <dmeil@acer-access.com>) |
Список | 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 по дате отправления: