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. 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 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. 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 Thanks
Gareth
Kirwan
Programming & Development, Thermeon Europe Ltd, [EMAIL PROTECTED] Tel: +44 (0) 1293 864 303 Thermeon Europe e-Card: gbjk |
Title: Gareth Stationery