problem with initlocation

From: "Josef J(dot) Micka" <postgres(at)maylo(dot)cz>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem with initlocation
Date: 2006-08-31 15:05:01
Message-ID: 44F6FA9D.7070509@maylo.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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(at)www:/home/db/postgres$

postgres server runs under user postgres
postgres(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-08-31 15:53:43 Re: problem with initlocation
Previous Message Tom Lane 2006-08-31 14:26:58 Re: Embedded App and User Authentication