Thread: Quickie Part3 - same as part1
I've tried creating the db again - with -D, on another server... and it's not working.
To clarify things I'm not going to post exactly what happened... spot the mistake - PLEASE.
[root@carsplus structure]$ su - postgres
bash-2.05$ initlocation 'PGDATA2'
The location will be initialized with username "postgres".
This user will own all the files and must also own the server process.
bash-2.05$ 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 /u/virtual/www*.com/database/data/
Fixing permissions on pre-existing directory /u/virtual/www*.com/database/data//base
Fixing permissions on pre-existing directory /u/virtual/www*.com/database/data//base
initlocation is complete.
You can now create a database using
CREATE DATABASE <name> WITH LOCATION = 'PGDATA2'
in SQL, or
createdb <name> -D 'PGDATA2'
from the shell.
You can now create a database using
CREATE DATABASE <name> WITH LOCATION = 'PGDATA2'
in SQL, or
createdb <name> -D 'PGDATA2'
from the shell.
bash-2.05$ exit
logout
[root@carsplus structure]$ service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: /bin/bash: /root/.bashrc: Permission denied
[ OK ]
[root@carsplus structure]$ su - postgres
bash-2.05$ createdb -D 'PGDATA2'
ERROR: Postmaster environment variable 'PGDATA2' not set
createdb: database creation failed
bash-2.05$ echo $PGDATA2
/u/virtual/www*.com/database/data/
bash-2.05$ cat .bash_profile
PGDATA=/var/lib/pgsql/data
PGDATA2=/u/virtual/www*.com/database/data/
[ -f $PGDATA/../initdb.i18n ] && source $PGDATA/../initdb.i18n
export PGDATA
export PGDATA2
logout
[root@carsplus structure]$ service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: /bin/bash: /root/.bashrc: Permission denied
[ OK ]
[root@carsplus structure]$ su - postgres
bash-2.05$ createdb -D 'PGDATA2'
ERROR: Postmaster environment variable 'PGDATA2' not set
createdb: database creation failed
bash-2.05$ echo $PGDATA2
/u/virtual/www*.com/database/data/
bash-2.05$ cat .bash_profile
PGDATA=/var/lib/pgsql/data
PGDATA2=/u/virtual/www*.com/database/data/
[ -f $PGDATA/../initdb.i18n ] && source $PGDATA/../initdb.i18n
export PGDATA
export PGDATA2
Thanks
Gareth Kirwan
Programming & Development,
Thermeon Europe Ltd,
gbjk@thermeoneurope.com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk
Programming & Development,
Thermeon Europe Ltd,
gbjk@thermeoneurope.com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk