Changes between Version 4 and Version 5 of TracOnRhel4WithoutYum

Timestamp:

Sep 28, 2006, 3:09:03 PM (18 years ago)

Author:

JonTheNiceGuy

Comment:

Postgres actually doesn't like it if you don't have the local template1 all line before you ask for md5 authentication!

TracOnRhel4WithoutYum

@@ -87 +87 @@
 {{{
 host all all 127.0.0.1 255.255.255.255 md5
+local template1 all trust sameuser
 local all all md5
-local template1 all trust sameuser
 }}}
 
 These lines seem to mean
 1) `host all all` = TCP/IP connections from localhost need to authenticate with an MD5 hashed password
-2) `local all all` = Socket connections from the localhost need to authenticate with an MD5 hashed password
-3) `local template1 all` = Socket connections to the database master table is trusted provided it's talking to (is it about?) a database with the same name as your user account.
+2) `local template1 all` = Socket connections to the database master table is trusted provided it's talking to (is it about?) a database with the same name as your user account.
+3) `local all all` = Socket connections from the localhost need to authenticate with an MD5 hashed password
 
  * /etc/init.d/postgres