postgresql

[ko-antoha]

Немогу инициализировать служебную базу данных

root@Router:~# /opt/postgresql/bin/initdb

initdb: no data directory specified

You must identify the directory where the data for this database system

will reside. Do this with either the invocation option -D or the

environment variable PGDATA.

root@Router:~# /opt/postgresql/bin/initdb PGDATA

initdb: cannot be run as root

Please log in (using, e.g., "su") as the (unprivileged) user that will

own the server process.

postgres@Router:~$ /opt/postgresql/bin/initdb

initdb: no data directory specified

You must identify the directory where the data for this database system

will reside. Do this with either the invocation option -D or the

environment variable PGDATA.

postgres@Router:~$ /opt/postgresql/bin/initdb PGDATA

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 locale ru_RU.UTF-8.

The default database encoding has accordingly been set to UTF8.

creating directory PGDATA ... initdb: could not create directory "PGDATA": Permission denied

[vpk_vpk]

Создайте эту папку и дайте пользователю права на доступ и изменение.

[ko-antoha]

на какую папку? у меня

на /opt/postgresql 0777 стоит

и на /tmp тоже

[Byte]

а как насчет

antoha писал(а) Thu, 22 March 2007 07:17

root@Router:~# /opt/postgresql/bin/initdb PGDATA initdb: cannot be run as root Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. postgres@Router:~$ /opt/postgresql/bin/initdb PGDATA The files belonging to this database system will be owned by user "postgres". This user must also own the server process.

?