* Thom Brown (thombrown@xxxxxxxxx) wrote: > Okay, I've just ended up commenting out the host lines and it's > effective enough as far as logging in is concerned. However, the > websites which use the database are no longer able to connect. I > should point out that they are connecting to pgbouncer through a > specific port number. I haven't been successful in getting the sites > to connect through a unix socket. If you want access controls on network-based connections, you'll have to switch to using one of the other auth methods I mentioned. Probably the simplest is to use 'md5' and then set passwords for the users who log into the database. Unix sockets are only possible if the application (pgbouncer, in your case) and the database are on the same system. If this is the case, you may need to set the unix_socket parameter in pgbouncer, and make sure that you do not have 'host' set in pgbouncer. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
