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