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