pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
What's wrong with this identification configuration? 2+ messages / 2 participants [nested] [flat]
* What's wrong with this identification configuration? @ 2003-02-11 21:26 Wei Weng <wweng@cs.columbia.edu> 2003-02-13 05:22 ` Re: What's wrong with this identification configuration? Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Wei Weng @ 2003-02-11 21:26 UTC (permalink / raw) To: pgsql-sql This is the idenfication setup in my /var/lib/pgsql/data/pg_hba.conf local all trust host all 127.0.0.1 255.255.255.255 trust This is supposed to authenticate any user to be able to access my postgresql system any time, no? But this is what happened: [root@Monet wweng]# su postgres bash-2.05a$ psql template1 psql: FATAL 1: No pg_hba.conf entry for host localhost, user postgres, database template1 bash-2.05a$ exit [root@Monet wweng]# psql template1 psql: FATAL 1: No pg_hba.conf entry for host localhost, user root, database template1 [root@Monet wweng]# exit [wweng@Monet wweng]$ psql template1 psql: FATAL 1: No pg_hba.conf entry for host localhost, user wweng, database template1 Why is this happening? And how can I log in the template1 database? I am using postgresql 7.2.3 on Redhat 7.3. bash-2.05a$ rpm -qa | grep postgresql postgresql-7.2.3-5.73 postgresql-libs-7.2.3-5.73 postgresql-server-7.2.3-5.73 postgresql-devel-7.2.3-5.73 Thanks a lot! Wei ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: What's wrong with this identification configuration? 2003-02-11 21:26 What's wrong with this identification configuration? Wei Weng <wweng@cs.columbia.edu> @ 2003-02-13 05:22 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2003-02-13 05:22 UTC (permalink / raw) To: Wei Weng <wweng@cs.columbia.edu>; +Cc: pgsql-sql Wei Weng <wweng@cs.columbia.edu> writes: > This is the idenfication setup in my /var/lib/pgsql/data/pg_hba.conf > local all trust > host all 127.0.0.1 255.255.255.255 trust > This is supposed to authenticate any user to be able to access my postgresql > system any time, no? Any local user, yes. > But this is what happened: > [root@Monet wweng]# su postgres > bash-2.05a$ psql template1 > psql: FATAL 1: No pg_hba.conf entry for host localhost, user postgres, > database template1 Did you recently change the pg_hba.conf file? If so, maybe you forgot to SIGHUP the postmaster to get it to re-read the file. Otherwise, my only thought is that you aren't talking to the same postmaster you thought you were ... that pg_hba.conf should definitely let in any local connection ... regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-13 05:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-02-11 21:26 What's wrong with this identification configuration? Wei Weng <wweng@cs.columbia.edu> 2003-02-13 05:22 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox