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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote:
> 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

What does the command whoami say right before you would run the
initlocation?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Scott Marlowe wrote:
> On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote:
>> 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
>
> What does the command whoami say right before you would run the
> initlocation?

I think a more appropriate question would be why is he running a version
of PostgreSQL that still has initlocation?

Sincerely,

Joshua D. Drake


>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Tom Lane wrote:

>"Josef J. Micka" <postgres@maylo.cz> writes:
>
>
>>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
>>
>>
>
>Try "su - postgres" ... plain su retains root's environment.
>
> regards, tom lane
>
>
thanks, that works
i'm using su only sometimes, and don't know about this apearance. (never
had problems with "su" becausy mostly i'm running it from non-privileged
user, but because user postgres has no password and no shell, i must do
that from root this time)

so thanks again.

regards,
Josef

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq