Question about databases in alternate locations...
От | Richard J Kuhns |
---|---|
Тема | Question about databases in alternate locations... |
Дата | |
Msg-id | 14625.26748.356187.68826@localhost.grauel.com обсуждение исходный текст |
Список | pgsql-general |
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'tpermitted 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 /
В списке pgsql-general по дате отправления: