Re: problem with initlocation

From: "Josef J(dot) Micka" <postgres(at)maylo(dot)cz>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem with initlocation
Date: 2006-09-01 15:14:25
Message-ID: 44F84E51.7090201@maylo.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>>
>>
>>
>> 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-01 15:43:04 Re: Problem using pg_restore with -a option
Previous Message Paul B. Anderson 2006-09-01 15:04:36 Re: Vacuum error on database postgres