Anybody knows, how to set-up secure postgres server in multi-user environment correctly? In my case postgres should start automatically, but any user has to supply password in order to connect. I've tried to use:
local all pgsql ident sameuser local all all md5 as pg_hba.conf configuration - it worked in 7.3.x releases, but doesn't work now - server could not start - it writes a lot of: FATAL: 08P01: invalid frontend message type 0 LOCATION: SocketBackend, postgres.c:366 error messages. Does anybody know what kind of error it is? Thanks in advance, Alex. P.S.: I'm using FreeBSD 4.9-STABLE, postgres 7.4 has been installed from the ports collection. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
