On 6/18/07, John K Masters <johnmasters@xxxxxxxxxxxxxxx> 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.
