pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josef J. Micka <postgres@maylo.cz>
To: pgsql-admin@postgresql.org
Subject: problem with initlocation
Date: Thu, 31 Aug 2006 17:05:01 +0200
Message-ID: <44F6FA9D.7070509@maylo.cz> (raw)

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



view thread (9+ messages)  latest in thread

Message-ID: <44F6FA9D.7070509@maylo.cz>
Permalink:  ../44F6FA9D.7070509@maylo.cz/
Also on:    postgresql.org/message-id/44F6FA9D.7070509@maylo.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: postgres@maylo.cz
  Subject: Re: problem with initlocation
  In-Reply-To: <44F6FA9D.7070509@maylo.cz>
  References: <44F6FA9D.7070509@maylo.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox