Обсуждение: Installing Postgresql
Ok, help me here. Whenever I try to run Postmaster or I start the deamon it gives me the error message that he PGDATA directory cannot be found. I've set it in my .bash_profile file in /etc/skel : /home/user : /root directories. What am I doing wrong? Thanx Sti
"Stiaan" <foresters@pixie.co.za> writes: > > Ok, help me here. > > Whenever I try to run Postmaster or I start the deamon it gives me the error > message that he PGDATA directory cannot be found. I've set it in my > .bash_profile file in /etc/skel : /home/user : /root directories. > > What am I doing wrong? > > Thanx Sti > > As a sanity test, try setting the PGDATA and PGLIB manually and starting the postmaster manually. Logged in as the postgres user and looking at a bash prompt do: export PGLIB=/wherever/you/keep/the/postgres/lib/files export PGDATA=/wherever/you/keep/the/database postmaster Collin
In article <h4hhfj2zyfd.fsf@vcmr-19.rcs.rpi.edu>, Collin W. Hitchcock <hitchc@vcmr-19.rcs.rpi.edu> wrote: > >"Stiaan" <foresters@pixie.co.za> writes: > >> >> Ok, help me here. >> >> Whenever I try to run Postmaster or I start the deamon it gives me the error >> message that he PGDATA directory cannot be found. I've set it in my >> .bash_profile file in /etc/skel : /home/user : /root directories. >> >> What am I doing wrong? > > >As a sanity test, try setting the PGDATA and PGLIB manually and >starting the postmaster manually. Logged in as the postgres user and >looking at a bash prompt do: > >export PGLIB=/wherever/you/keep/the/postgres/lib/files >export PGDATA=/wherever/you/keep/the/database >postmaster Also, don't forget to do the initial 'initdb' with these values set. Les Mikesell les@mcs.com
you're on the right track, try exporting the PGDATA variable manually from the shell. it's in the manual somewhere. Gavin ---------- >From: "Stiaan" <foresters@pixie.co.za> In article <381ffbc6.0@news1.mweb.co.za>, "Stiaan" <foresters@pixie.co.za> wrote: > Ok, help me here. > > Whenever I try to run Postmaster or I start the deamon it gives me the error > message that he PGDATA directory cannot be found. I've set it in my > .bash_profile file in /etc/skel : /home/user : /root directories. > > What am I doing wrong? > > Thanx Sti > >