> I just can't understand the use of this PGDATA variable!!!!! > > -I am on FC3. (pgl 7.4) > -I am installing rpms and then running /etc/init.d/postgresql start > (which is done by default) > -The resulting "data" directory is in /var/lib/pgsql/data > > I now want the "data" directory to be on > /home3/myreallylargepartition/pgsql/data > so: > > -I login as postgres > -I change .bash_profile so that PGDATA points at the new directory > -I restart the server by doing a "/etc/init.d/postgresql restart" > > Shouldn't any new tables I create be in the new area?!!!!! > Well not really, I bet /etc/init.d/postgresql is getting its variables from /etc/conf.d/postgresql. you will have to find it there and change it. Regards, Richard Broersma Jr.
