Geek Corner IP Rally Time Trials
Subscribe to our Newsletter for all the latest news and offers!



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! (Friday, 12 February 2010)
    Thanks James, it seems to be up and running, sending and receiving like a dream. G
  • automate it! (Friday, 12 February 2010)
    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 (Friday, 12 February 2010)
    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! (Friday, 12 February 2010)
    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...