Re: [ADMIN] Setup and LIBPQ (Newbie) - Mailing list pgsql-admin

From Bruce Tong
Subject Re: [ADMIN] Setup and LIBPQ (Newbie)
Date
Msg-id Pine.LNX.3.95.980512144229.12846A-100000@laxmi.ev.net
Whole thread Raw
In response to Re: [ADMIN] Setup and LIBPQ (Newbie)  (Peter Mount <pgsqladmin@retep.org.uk>)
Responses Re: [ADMIN] Setup and LIBPQ (Newbie)
List pgsql-admin
> Check that you have pg_hba.conf setup correctly.

Ahh, there's the config file. Cool. I learned a couple of things about
PostgreSQL finding it. Okay, the default should have let anything on the
same host connect, and that was true with the "psql" application.

This gives me some things to try. Thanks. I can't figure out why I didn't
see this file before since I've been to that directory. I don't remember
it being mentioned in the Administrator's Docs. Oh well. ;)

> > Q: I saw somebody recommend a "-i" option for what seemed like a similar
> > situation, but I don't see that option on the man pages. Is it related to
> > my problem?
>
> running postmaster with -i enables communication via tcp-ip sockets. The
> JDBC & ODBC drivers need this to operate.

> > Q: Attempts to use MS-Access with the PostODBC driver failed. Could this
> > be related?
>
> Yes (see above)

The "-i" option doesn't seem to be known by the /usr/bin/postmaster
application. It doesn't recognise the option and it is not in the man
pages. The PG_VERSION file says 6.1, but the software package manager
(RPM) tells me I've got version 6.2.1. Is the "-i" option part of a later
version?


Bruce Tong
Systems Programmer
Electronic Vision / FITNE

mailto: zztong@laxmi.ev.net
http://www.ev.net/fitne


pgsql-admin by date:

Previous
From: Peter Mount
Date:
Subject: Re: [ADMIN] Setup and LIBPQ (Newbie)
Next
From: Doug Hunt
Date:
Subject: Trouble connecting between postgresql machines