problem with initlocation
От | Josef J. Micka |
---|---|
Тема | problem with initlocation |
Дата | |
Msg-id | 44F6FA9D.7070509@maylo.cz обсуждение исходный текст |
Ответы |
Re: problem with initlocation
Re: problem with initlocation |
Список | pgsql-admin |
i want to make database in another place and i'm unable to use initlocation, and i don't know, what i'm doing wrong. this is what i do, and i think it's correct. www:/home/db/postgres$ su postgres postgres@www:/home/db/postgres$ ls -l total 12 drwx------ 6 postgres postgres 4096 Aug 31 14:59 data drwxr-xr-x 2 postgres postgres 4096 Aug 31 14:19 data-web drwx------ 3 postgres postgres 4096 Oct 15 2004 dumpall postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation /home/db/postgres/data-web/ initlocation: cannot be run as root Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. postgres@www:/home/db/postgres$ postgres server runs under user postgres postgres@www:/home/web/holandsko# ps uxaw |grep post postgres 11006 0.0 0.0 17088 1292 ? S Jun29 7:16 /usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data postgres 11012 0.0 0.1 7888 2668 ? S Jun29 11:22 postgres: stats buffer process postgres 11013 0.0 0.1 7944 2500 ? S Jun29 10:09 postgres: stats collector process postgres 11029 0.0 0.1 12780 3116 ? Ss Jun29 17:58 /usr/lib/postgresql/bin/pg_autovacuum -D -p 5432 -L /var/log/postgresql/autovacuum_log and info about system Debian Sarge, kernel 2.4.32, postgresql version 7.4.7 thanks Josef Micka
В списке pgsql-admin по дате отправления: