[Zope] Database connections

[Paul Everitt]

Oleg wrote:
>    There are connections to different databases. So you said "one
> connection to one database"?

If you can use one connection string in Postgres to access multiple
databases, then you just need one Database Connection.  Otherwise,
you'll need one connection per database.  Note that I don't mean per
table -- I don't know much about Postgres and don't know if it organizes
tables into separate databases that are selected with a "use database"
command.
 
> > >    It is bad, as I have many databases, so Zope eats up 
> > > memory. Another
> > > problem - what would do Zope if I restart Postgres (so all current
> > > connections break)? Would Zope reestablish connections or 
> just report
> > > error?
> > 
> > It should re-establish the connection.  If it doesn't then there's a
> > bug.  This works fine with all the Database Adapters I've used.
> 
>    I'll retest, but currently, when I ask ZPygresDA to close 
> connection,
> Zope reports "the site has technical difficulties" when I'm trying to
> access the application.

Right, which is the correct behavior, as you had disconnected from the
database.  I thought your question was about restarting _Zope_, so I had
a misunderstanding.

I don't know anything about the Postgres client library and whether it
can reconnect to a server when the server is shutdown.  This definately
isn't a Zope issue though -- the client should handle it.
 
--Paul