Morning headache with Postgresql

While I'm doing python exercise. Suddenly, my database connection was down for no reason. It takes me 2 hours to fix the issue and I almost gave up. Damn it! actually, I didn't say that until now. haha

But I learn new stuff today especially postgres commands, like:

To check the database server status

/etc/init.d/postgresql status

As usual, my friend google help me find out the solution and took me a while to find it. Here's the link https://askubuntu.com/questions/50621/cannot-connect-to-postgresql-on-port-5432




First purge the old postgres install.

sudo apt-get remove --purge postgresql-9.3

Now simply reinstall

sudo apt-get install postgresql-9.3




Now, when I run my odoo. My username "devlynard" was not found it is because I reinstall the postgres. So, I just add it back. 

Eureka!