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