Question about databases in alternate locations...
Richard J. Kuhns <rjk@grauel.com>
From: Richard J Kuhns <rjk@grauel.com>
To: pgsql-general@postgresql.org
Date: 2000-05-16T15:25:48Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql
Could anyone please tell me what I'm doing wrong? I'm sure I'm just overlooking something, but what? ====================== moran:/acct$ id uid=1007(postgres) gid=1003(postgres) groups=1003(postgres) moran:/acct$ export P=/acct/pindybook moran:/acct$ initlocation P 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 /acct/pindybook Creating directory /acct/pindybook/base initlocation is complete. You can now create a database using CREATE DATABASE <name> WITH LOCATION = 'P' in SQL, or createdb <name> -D 'P' from the shell. moran:/acct$ createdb indybook -D 'P' ERROR: The database path 'P' is invalid. This may be due to a character that is not allowed or because the chosen path isn't permitted for databases createdb: database creation failed moran:/acct$ ls -ld pindybook drwx------ 3 postgres postgres 512 May 16 09:40 pindybook moran:/acct$ ls -l pindybook total 1 drwx------ 2 postgres postgres 512 May 16 09:40 base moran:/acct$ ====================== Thanks... -- Richard Kuhns rjk@grauel.com PO Box 6249 Tel: (765)477-6000 \ 100 Sawmill Road x319 Lafayette, IN 47903 (800)489-4891 /