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 по дате отправления: