PostgreSQL setup

[Andrew Gould]

On Wed, Dec 31, 2008 at 9:06 AM, stan <stanb at panix.com> wrote:

> I have installed PostgreSQL via the ports on a new 7.1 machine. I am trying
> to set it up.
>
> I found:
>
> http://www.freebsddiary.org/postgresql.php
>
> Whic says to run:
>
>  su -l pgsql -c initdb
>
> But that gives me the following error message:
>
> initdb: no data directory specified
> You must identify the directory where the data for this database system
> will reside.  Do this with either the invocation option -D or the
> environment variable PGDATA.
>
> But when I try:
>
> #  su -l pgsql -c initdb -D /usr/local/postgres
>
> I get:
>
> Illegal option -D
>
> What am I doing wrong?
>
>
I think the command has to be enclosed in quotation marks since it consists
of multiple words.  su thinks the '-D' is an argument for su rather than
initdb.

su -l pgsql -c 'initdb -D /usr/local/postgres'

Best of luck,

Andrew