initlocation and createdb
От | Barnes |
---|---|
Тема | initlocation and createdb |
Дата | |
Msg-id | 003601bfd579$f51f46d0$0a64a8c0@fries обсуждение исходный текст |
Ответ на | triggers and functions in pgsql 7.0.2 (Marc Britten <mbritten@cybernet-usa.com>) |
Ответы |
initlocation and createdb
Re: initlocation and createdb |
Список | pgsql-general |
I'm having trouble setting up databases in a new location. In particular, I do the following: [postgres@whopper pgdata]$ export PGDATA2=/home/pgdata [postgres@whopper pgdata]$ 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/pgdata Creating directory /home/pgdata/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. [postgres@whopper pgdata]$ createdb optodb -D 'PGDATA2' ERROR: The database path 'PGDATA2' 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 [postgres@whopper pgdata]$ The permissions for /home/pgdata are drwx------ 3 postgres postgres 4096 Jun 13 16:41 pgdata What am I doing wrong? Is /home not permitted for databases? If so, why not, and what is permitted? Thank you for any help. David Barnes
В списке pgsql-general по дате отправления: