Rawhide: postgresql 7.3.1-4 and psql locally

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Howdy,

Anybody else get authentication failure on
Rawhide compiled postgresql-7.3.1-4 (applied
to 7.3-6 too) when trying access a db locally?

Doesn't really matter what user you try, but
let's make sure we should be allowed ...

# service postgresql status
postmaster (pid 24011 24009 24007) is running...
# su - postgres
[postgres@tacit pgsql]$ psql template1
psql: FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log
for details

[postgres@tacit pgsql]$

This is because obvious ~postgres/data/pg_hba.conf
minor syntax change. Following patch will fix the
sample configuration file copied on iditdb will need
to be thus patched something like this

--- postgresql-7.3/src/backend/libpq/pg_hba.conf.sample.dist    Sat Jan  4 19:23:49 2003
+++ postgresql-7.3/src/backend/libpq/pg_hba.conf.sample Sat Jan  4 19:24:55 2003
@@ -50,4 +50,4 @@
 # Using sockets credentials for improved security. Not available
everywhere,
 # but works on Linux, *BSD (and probably some others)

-local  all     ident   sameuser
+local  all     all     ident   sameuser
#

This will also prevent random local user connecting to
any db unless he is valid postgresql user which I assume
was intended or was it?

HTH,

:-) riku

-- 
    [ This .signature intentionally left blank ]



_______________________________________________
Redhat-devel-list mailing list
Redhat-devel-list@redhat.com
https://listman.redhat.com/mailman/listinfo/redhat-devel-list

[Index of Archives]     [Kernel Newbies]     [Red Hat General]     [Fedora]     [Red Hat Install]     [Linux Kernel Development]     [Yosemite News]

  Powered by Linux