Saturday, February 21, 2009

PostgreSQL Authentication

PostgreSQL default authentication control really sucks. I modified it like this,
  1. su - postgres
  2. psql
  3. show hba_file;
  4. vi the hba_file and comment out all default settings
  5. add a line "local all all md5"
  6. now it works from command line and phpPgAdmin web screen
But I want the authentication for user postgres works as default, so I add first line as "local all postgres indent sameuser"

No comments: