Re: initdb - Mailing list pgsql-general

From Jeffrey Webster
Subject Re: initdb
Date
Msg-id 8c0cc2820706191006h57860b48hd105c487f48d2323@mail.gmail.com
Whole thread Raw
In response to Re: initdb  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Responses Re: initdb
List pgsql-general
On 6/17/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
On 6/18/07, John K Masters <johnmasters@oxtedonline.net> wrote:
> I feel somewhat embarrassed to post this but I can't get past the first
> post with Postgresql. I have installed onto a Debian testing system,
> created a space for the database cluster on /usr/local/pgsql/data,
> changed owner to postgres and changed permissions to 0700.
>
> However, when I try `initdb -D /usr/local/pgsql/data' I get "Command not
> found"
>
> I've googled for this but found nothing useful.
You'll need to find a debian way to add the path to your
binary to the users (systems?) PATH ... or use the fully
qualified path to the executable.
/usr/loca/pgsql/bin/initdb -D /usr/local/pgsql/data


Hm.  Why not just edit your .bash_profile, or .bashrc?  (I won't go into the details of which to use)

Add:
export PGDATA=/usr/local/pgsql/data

Add the following the line that sets your path:
:/usr/local/pgsql/bin

It should now look something like:

export PGDATA=/usr/local/pgsql/data
export PATH=$PATH:$HOME/bin:/usr/local/pgsql/bin

If you put it in .bashrc just use the following to set the variables:
. ~/.bashrc



Any new terminal you open will have those settings immediately.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: problems selecting from altered table
Next
From: John K Masters
Date:
Subject: Re: initdb