HOME Web FAQs
Make sure the password is in /var/lib/pgsql/.pgpass

The format is as follows:

*:*:*:postgres:PASSWORD
 
Modify /var/lib/pgsql/data/pg_hba.conf
 
It should contain the following...
 
local   all         all                                              md5
host    all         all         127.0.0.1          255.255.255.255   md5
 
Change 'md5' to 'trust' to disable authentication then restart postgres.
 
`/etc/init.d/postgresql restart`
 
Now you should be able to connect to postgresql as user 'postgres' without a password to modify the password.
 
`psql -u template1`
 
Run the following sql command.
 
"alter user postgres with password 'NEW PASSWORD HERE';"

Finally change /var/lib/pgsql/data/pg_hba.conf back to its original format and restart postgresql one more time. Now you should be able to authenticate using user postgres and the password you specified.

 

Latest Posts

  • it worked! (DATE_FORMAT_LC1)
    Thanks James, it seems to be up and running, sending and receiving like a dream. G
  • automate it! (DATE_FORMAT_LC1)
    Hi George thanks for your question, the most likely problem is that you haven't entered the right details for your email to be able to send and retrie...
  • My email won't send and recieve (DATE_FORMAT_LC1)
    I followed the instructions to set up my email account on outlook express, but my email won't send or receive! Please help, George
  • Welcome! (DATE_FORMAT_LC1)
    Welcome to the forum, if you can't find the information you need in the FAQs then please post a question about our web services here, We have curren...