Re: problem with initlocation

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: "Josef J(dot) Micka" <postgres(at)maylo(dot)cz>, pgsql-admin(at)postgresql(dot)org
Subject: Re: problem with initlocation
Date: 2006-08-31 17:14:49
Message-ID: 44F71909.6020608@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

--

=== 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John DeSoi 2006-08-31 17:33:51 Re: Embedded App and User Authentication
Previous Message Tom Lane 2006-08-31 16:56:37 Re: pg_dump: schema with OID 16396 does not exist