Re: problem with initlocation - Mailing list pgsql-admin

From Josef J. Micka
Subject Re: problem with initlocation
Date
Msg-id 44F84E51.7090201@maylo.cz
Whole thread Raw
In response to problem with initlocation  ("Josef J. Micka" <postgres@maylo.cz>)
Responses Re: problem with initlocation  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: problem with initlocation  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: problem with initlocation  (Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>)
List pgsql-admin
Joshua D. Drake wrote:

> 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
>>
>
because it's latest stable version for debian sarge.
and i rather use possibly "older but stable" software, then "unstable"
or "development" software on production server.
also i don't need features of new version, in fact, i may stay on 6.5,
but from my point of view is 7.4 faster, and as i said, it's "stable"
for debian.

regards
Josef J. Micka

pgsql-admin by date:

Previous
From: "Paul B. Anderson"
Date:
Subject: Re: Vacuum error on database postgres
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem using pg_restore with -a option