On Thu, Jan 1, 2015 at 6:25 PM, Neil Van Dyke <n...@neilvandyke.org> wrote:
> Thomas Lynch wrote on 01/01/2015 03:30 AM: > >> I am having difficulty connecting to the postgres server from Racket. It >> asks for a password, but role and authentication is set up so that the >> logged in local user does not need one. >> >> > Is `psql` is using a Unix domain socket to talk to PG, > `postgresql-connect` is using a `localhost` TCP port to PG, and your > `/etc/postgresql/*/main/pg_hba.conf` is configured to have different > authentication for the two different methods? > By gosh you are correct, this is the default for pg_hba.conf with the debian package install: > > If so, try either adding `#:socket 'guess` to your `postgresql-connect` > call, or modifying your `pg_hba.conf` (and restarting PG). > > If that's not quite it, try also adding `#:ssl 'yes` to > `postgresql-connect`, or modifying `pg_hba.conf` again. > > If that's not it, check for PG environment variables that `psql` could be > using. Also, you can test the different methods by supplying different > `conninfo` strings on the `psql` command line. > > Neil V. > >
____________________ Racket Users list: http://lists.racket-lang.org/users
