| 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: | Whole Thread | Raw Message | 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 |