Re: Proper Permissions for /usr/local/pgsql/data

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: Proper Permissions for /usr/local/pgsql/data
Дата
Msg-id AANLkTinpv9GQBGe-gqq2FE8vbqM=PYRvUyRMkWfZeRPj@mail.gmail.com
обсуждение исходный текст
Ответ на Proper Permissions for /usr/local/pgsql/data  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Proper Permissions for /usr/local/pgsql/data  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
Hey Rich,

You should chown your data dir (/usr/local/pgsql/data) to "postgres"
before you run initdb.

2010/12/2 Rich Shepard <rshepard@appl-ecosys.com>
 I'm manually replacing -8.3.3 with -9.0.1 I have the old data/ directory
and pg_dumpall files safely stored. Following the directions at:
<http://www.postgresql.org/docs/current/static/install-upgrading.html>, step
#5 I see this:

postgres@salmo:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locales
 COLLATE:  C
 CTYPE:    en_US
 MESSAGES: en_US
 MONETARY: en_US
 NUMERIC:  en_US
 TIME:     en_US
The default database encoding has accordingly been set to LATIN1.
The default text search configuration will be set to "english".

fixing permissions on existing directory /usr/local/pgsql/data ... initdb:
could not change permissions of directory "/usr/local/pgsql/data": Operation
not permitted

 The directory /usr/local/pgsql/data is owned by me; what should the
permissions be so I don't get that error message above?

TIA,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PG_ERROR 42501 permissions error
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: How to find correct locale name for CREATE DATABASE