Wednesday, April 25, 2012

Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster

Recently i had restarted my server and i was getting a weird issue while starting up my postgresql 8.4 in ubuntu server

Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 63.


Googled at many places, tried many things but the same error was repeating all the time. At the end i got a very simple solution which actually fixed my issue. Sharing it thinking it may help others as it helped me


sudo rm /var/lib/postgresql/8.4/main/postmaster.pid
sudo chown postgres:postgres /etc/postgresql/8.4/main/environment
sudo chmod u+rw,g+rw /etc/postgresql/8.4/main/environment