Restarting postgres server
| От | George Heller |
|---|---|
| Тема | Restarting postgres server |
| Дата | |
| Msg-id | 479545.34816.qm@web56512.mail.re3.yahoo.com обсуждение |
| Ответы |
Re: Restarting postgres server
Re: Restarting postgres server |
| Список | 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
bettertravel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
В списке pgsql-general по дате отправления: