Re: postmaster.pid does not exist. cannot start postgres server on ubuntu

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 <http://uk.linkedin.com/in/matthewdwalden>

On Tue, Nov 23, 2010 at 4:12 PM, Jennifer Trey <jennifer(dot)trey(at)gmail(dot)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 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
>
>
>