Re: initdb

On 6/17/07, Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com> wrote:
>
> On 6/18/07, John K Masters <johnmasters(at)oxtedonline(dot)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.