Timeline for Postgres server not starting anymore
Current License: CC BY-SA 3.0
Post Revisions
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Mar 20, 2017 at 10:18 | history | edited | CommunityBot |
replaced http://superuser.com/ with https://superuser.com/
|
|
| Mar 10, 2017 at 14:06 | comment | added | will | PS. thanks for all those questions -- they are a great help when you want to troubleshoot this kind of thing! | |
| Mar 10, 2017 at 14:05 | comment | added | will |
Hi - this comment is for the next person with this problem. I was getting this error on a reinstall. I had previously remove-d postgres. In my case the configuration files did not all have owner: "postgres". So start was giving me: "Loaded: not-found (Reason: No such file or directory)" errors. Why? File owner. Evidently I'd edited a file and not reset the ownership. tsk, tsk tsk
|
|
| Nov 2, 2016 at 8:21 | comment | added | Nikhil | I just wanted to know if there is any process on 5432 port. Glad, that my comment could help. Can you uplvote my comment. Thanks | |
| Nov 1, 2016 at 17:55 | vote | accept | RyanQuey | ||
| Oct 30, 2016 at 5:47 | history | tweeted | twitter.com/StackDBAs/status/792603797206003713 | ||
| Oct 28, 2016 at 20:22 | answer | added | RyanQuey | timeline score: 0 | |
| Oct 28, 2016 at 20:16 | comment | added | RyanQuey |
Would you mind explaining how you knew to do netstat -tulpn | grep :5432, so I know for future reference?
|
|
| Oct 28, 2016 at 19:38 | comment | added | RyanQuey | I did, but what ultimately resolve the issue is that I had changed /etc/hosts back to the default setting (from 127.0.0.1 For the local host and 127.0.1.1 for my machine). Will post a complete explanation below. Thanks! | |
| Oct 28, 2016 at 19:31 | comment | added | Nikhil | Did you reboot? askubuntu.com/questions/59458/… | |
| Oct 28, 2016 at 19:28 | comment | added | RyanQuey |
I changed the number for my_machine to the new inet address (I'm assuming it shouldn't just be 127.0.0.1?). Now it outputs tcp 0 0 <my_inet_addr>:5432 0.0.0.0:* LISTEN 3535/postgres . Server still doesn't seem to work. Or do I need to change the address for the localhost?
|
|
| Oct 28, 2016 at 18:36 | comment | added | Nikhil | yeah, it might be. | |
| Oct 28, 2016 at 18:32 | comment | added | RyanQuey | my /etc/hosts has the old inet address. This might be the problem | |
| Oct 28, 2016 at 18:29 | comment | added | RyanQuey |
When I run that, I get (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.). when I run it using sudo, I get sudo: unable to resolve host <my_machine>
|
|
| Oct 28, 2016 at 18:22 | comment | added | Nikhil |
also paste for netstat -tulpn | grep :5432
|
|
| Oct 28, 2016 at 18:17 | comment | added | RyanQuey | 9.5 main 5432 down postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log | |
| Oct 28, 2016 at 18:16 | history | edited | RyanQuey | CC BY-SA 3.0 |
added 297 characters in body
|
| Oct 28, 2016 at 18:16 | comment | added | Nikhil |
can you paste the result of pg_lsclusters
|
|
| Oct 28, 2016 at 18:10 | history | migrated | from stackoverflow.com (revisions) | ||
| Oct 28, 2016 at 18:05 | history | asked | RyanQuey | CC BY-SA 3.0 |