alternative DB locations
От | Bob Parkinson |
---|---|
Тема | alternative DB locations |
Дата | |
Msg-id | Pine.OSF.4.21.0010031443250.23595-100000@omni.ac.uk обсуждение исходный текст |
Ответы |
Re: alternative DB locations
|
Список | pgsql-general |
Hi, I'm just trying the three lines from the initlocation online man page (version 7.0.2) as postgres. postgres owns the locations, and initlocation runs OK, but it don't like to create the DB. omni.ac.uk> whoami postgres omni.ac.uk> export PGDATA2=/public_searchable_0 omni.ac.uk> 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 /public_searchable_0 Fixing permissions on pre-existing directory /public_searchable_0/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. omni.ac.uk> createdb 'testdb' -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 The shell is bash. What am I missing please? Cheers, Bob Bob Parkinson rwp@biome.ac.uk ------------------------------------------------------------------ Technical Manager: Biome http://biome.ac.uk/ Greenfield Medical Library, Queens Medical Centre, Nottingham. 0115 9249924 x 42059 ------------------------------------------------------------------ We are stardust
В списке pgsql-general по дате отправления: