Skip site navigation (1) Skip section navigation (2)

Re: Zope and ZPsycopgDA almost working...

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Tamir Halperin <tamir(at)brobus(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org,Zope Database Mailing List <zope-db(at)zope(dot)org>
Subject: Re: Zope and ZPsycopgDA almost working...
Date: 2003-03-25 18:39:36
Message-ID: 1048617576.13798.524.camel@camel (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 2003-03-25 at 12:21, Tamir Halperin wrote:
> Hi Robert. Thanks for the feedback. My comments and questions below...
> 
> > -----Original Message-----
> > From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
> > Sent: Tuesday, March 25, 2003 10:20 AM
> > To: Tamir Halperin
> > Cc: pgsql-admin(at)postgresql(dot)org; Zope Database Mailing List
> > Subject: Re: [ADMIN] Zope and ZPsycopgDA almost working...
> > 
> > Sounds like your database might not be accepting outside connections.
> 
> I agree. Psycopg seems to be saying exactly that from what appears to be a healthy Zope environment.
> 
> > Check your postgresql.conf file and make sure tcpip_socket = true
> 
> I have a /usr/local/share/postgresql/postgresql.conf.sample file but I don't see a postgresql.conf file anywhere in the system.
> 
> I've confirmed that the sample file is reflecting the default setting of false.
> 
> How do I go about overriding the tcpip_socket = false setting for this specific pgsql service?
> 
> > You might also need to configure your pg_hba.conf to allow connections
> > from your windows box.
> 
> Likewise, I don't see a pg_hba.conf file in my system.
> 
> My pg_hba.conf.sample file seems to show a tabular view of permissions of some kind at the bottom:
> 
> Type	database	user	ip-address	ip-mask		method
> -------------------------------------------------------------
> local	all		all						trust
> host	all		all	127.0.0.1	255.255.255.255	trust
> 
> Which modifications, if any, are needed to this table.
> 
> How do I put them into effect seeing as how this is the sample file we're talking about.
> 

According to the guys on IRC, *bsd puts the files in
/usr/local/pgsql/data; if not do a "find" for the files to figure out
where they are. Once you find them, you'll need to set tcpip_sockets =
true and you'll need to add a line like:
host	all		all	<zope box ip>	255.255.255.255	trust
to your pg_hba.conf

you'll need to do a pg_ctl reload once you make the changes.

Robert Treat


In response to

pgsql-admin by date

Next:From: ashwini sridharDate: 2003-03-25 21:11:38
Subject: unsubscribe
Previous:From: Brickley Jeff-RA9607Date: 2003-03-25 17:48:59
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group