Re: odbc with debian woody/postgres

Thanks Christoph, I'm going to try this.  But I'm having a little
trouble figuring out how to get postmaster to start up at boot time
with the -i option.  This is a debian-specific problem -- I don't
really understand the script in /etc/init.d and I can't figure out
which line therein I need to modify in order to get it to start up
with TCP/IP listening.  I don't see an obvious call to postmaster...
anyone familiar with this script know what I should do?  thanks
m


On Wed, Oct 09, 2002 at 10:28:47AM +0200, Christoph Dalitz wrote:
> On Wed, 09 Oct 2002 02:27:10 -0400
> pgsql-general-owner@postgresql.org wrote:
>
> > Date: Wed, 9 Oct 2002 02:22:38 -0400
> > From: Matt Price <matt.price@utoronto.ca>
> > To: debian users <debian-user@lists.debian.org>,
> >     pgsql-general@postgresql.org
> > Subject: odbc with debian woody/postgres
> > Message-ID: <20021009062238.GA1733@utoronto.ca>
> >
> >
> > My odbc.ini currently looks like this (slightly modified from the
> > original):
> >
> >
> > [PostgreSQL]
> > Description         = PostgreSQL template1
> > Driver              = PostgreSQL
> > Trace               = No
> > TraceFile           = /tmp/odbc.log
> > Database            = template1
> > Servername          = localhost
> >
> If you only want a local connection via Unix Domain Sockets to your database, you
> should leave "Servername" empty. Otherwise you will need to run postmaster with the
> "-i" option so that it listens on TCP/IP connections.
>
> Without "Servername", the following pg_hba.conf entry should be sufficient:
>
> > local        all                                           trust
> >
> Becuse of "trust", you can omit the Password in odbc.ini.
>
> BTW you should consider creating a second database and a database user for
> your application; working always as superuser might not be what you want.
>
> Hope this helps,
>
> Christoph Dalitz