Thread: postmaster.pid does not exist. cannot start postgres server on ubuntu
I am getting the following error when I go to Application -> PostgreSQL -> Reload Configuration
"
Please enter your password if requested.
pg_ctl: PID file "/home/Jen/Installed/PostgreSQL/data/postmaster.pid" does not exist
Is server running?
Press <return> to continue...
"
I have installed Postgresql from the Enterprise DB installer for Ubuntu.
It has worked before. I just restarted my computer and now face this issue.
Off topic:
I have also had a different kind of issue, where a script added to /etc/profile.d called Startup.sh
causes postgre to fail to startup. This script is used on login to set global environment variables, but I get the error that Postgre cannot execute the script.
I tried chmod 777 on the script but still no luck. If I remove it, postgre will start up so its not a biggy..
but is not a bug ?
Cheers, Jen
Jen,
Regarding the first point, is postgres actually running? You can check this by typing the following at a terminal -
ps -ef|grep postgres
Reload configuration is used to tell PostgreSQL to read in the configuration file for any chances since the database started. If you want to start the database you can use pg_ctl. More info on its use would be best gained from the documentation. It looks like the feedback is correct and you don't have postgres working. Either that or you you need to set the $PGDATA environment variable or specify the data directory when using pg_ctl reload.
I can't really comment on the login script because I don't know its contents but if you're trying to automatically start the database I would look at init.d and the associated run level folders (again more info in Linux documentation - its far too lengthy to explain here).
--
View my Linkedin profile
Regarding the first point, is postgres actually running? You can check this by typing the following at a terminal -
ps -ef|grep postgres
Reload configuration is used to tell PostgreSQL to read in the configuration file for any chances since the database started. If you want to start the database you can use pg_ctl. More info on its use would be best gained from the documentation. It looks like the feedback is correct and you don't have postgres working. Either that or you you need to set the $PGDATA environment variable or specify the data directory when using pg_ctl reload.
I can't really comment on the login script because I don't know its contents but if you're trying to automatically start the database I would look at init.d and the associated run level folders (again more info in Linux documentation - its far too lengthy to explain here).
--
View my Linkedin profile
On Tue, Nov 23, 2010 at 4:12 PM, Jennifer Trey <jennifer.trey@gmail.com> wrote:
I am getting the following error when I go to Application -> PostgreSQL -> Reload Configuration"Please enter your password if requested.pg_ctl: PID file "/home/Jen/Installed/PostgreSQL/data/postmaster.pid" does not existIs server running?Press <return> to continue..."I have installed Postgresql from the Enterprise DB installer for Ubuntu.It has worked before. I just restarted my computer and now face this issue.Off topic:I have also had a different kind of issue, where a script added to /etc/profile.d called Startup.shcauses postgre to fail to startup. This script is used on login to set global environment variables, but I get the error that Postgre cannot execute the script.I tried chmod 777 on the script but still no luck. If I remove it, postgre will start up so its not a biggy..but is not a bug ?Cheers, Jen