15 Dec '12, 12pm

Postgres gives an error of ‘Password authentication failed for user.

Make sure the password is in /var/lib/pgsql/.pgpassThe format is as follows…*:*:*:postgres:PASSWORDModify /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. – Like this post ? Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring disco...

Full article: http://blog.eukhost.com/webhosting/postgres-gives-an-erro...

Tweets

Reliable Web Hosting I recommend

doteasy.com 15 Dec '12, 8pm

Doteasy has been one of the leading web hosting service providers since 2000. We use the latest server and data center tec...

ASCIIcast 393 - Guest User Record

ASCIIcast 393 - Guest User Record

railscasts.com 16 Dec '12, 7pm

The first question that comes to mind is should we store the guest user account in the database if it’s just temporary? Ou...

Blog: GloFo Pushes For Failed Strategy: Globalf...

electronicsweekly.com 17 Dec '12, 1am

Globalfoundries' boss Ajit Manocha has called for a revival of the failed 1990s strategy of funding inward investment of f...

"Tweets Belong To The User….And Words Are Complicated" an interesting read via @johnbattelle

"Tweets Belong To The User….And Words Are Compl...

battellemedia.com 16 Dec '12, 12pm

(image GigaOm ) Like many of you, I’ve been fascinated by the ongoing drama around Twitter over the past few months (and I...