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

The format is as follows:

Modify /var/lib/pgsql/data/pg_hba.conf
It should contain the following...
local   all         all                                              md5
host    all         all   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...