January 17th, 2013, 12:56 PM
I got in a situation that is strange and i hope some of you could help me out on this.
What I did is kinda simple, I added a post to pg_hba.conf which is
to give access to another user.
host all all xx.xx.xx.xx(local IP) trust
After that i run command:
It says [OK]
sudo /etc/init.d/postgresql-8.3 restart
But when i try to access the website i get this error:
could not connect to database
Please, I need some help to get the website back again, did I do something wrong? Or do I need to restart the server itself as well? This is an bigger database running lvs cluster
January 17th, 2013, 01:32 PM
Some additional information, it says that it is online:
8.3 main 5432 online postgres /var/lib/postgresql/8.3/main /var/log/postgresql/postgresql-8.3-main.log
# sudo /etc/init.d/postgresql-8.3 status
But still can't access db or see the site