From: | George Heller <george(dot)heller(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Restarting postgres server |
Date: | 2007-05-14 22:21:58 |
Message-ID: | 479545.34816.qm@web56512.mail.re3.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all.
I just modified my pg_hba.conf file in order to allow
access from another machine. I needed to restart the
postgres server in order for the changes to take
effect, and so I issued the command,
pg_ctl restart -D /usr/local/pgsql/data
But the server failed to shutdown. The database was
not accessible either. So I restarted the server
machine, and now when I try to access the database
using,
psql mydatabase postgres
it gives me the error,
psql: could not connect to server: No such file or
directory
Is the server running locally and accepting
connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?
I have a lot of data in there, so I dont want to get
it erased. Any ideas of how I can get this working, if
I need to restart the postmaster, what would be the
command? I am just a beginner with this thing, so
please bear with me.
Thanks in advance.
George
____________________________________________________________________________________Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2007-05-14 22:41:36 | Re: Restarting postgres server |
Previous Message | Alvaro Herrera | 2007-05-14 22:12:55 | Re: Postgres Printed Manuals |