Re: PostgreSQL-Problem and Problem on Alioth

2005-01-26 Thread Andreas Tille
On Wed, 26 Jan 2005, Martin Pitt wrote: Well, this is not _exactly_ right since you can map system users to database users in pg_ident.conf, but that would mean yet another conffile to touch. ... which should probably be avoided. Moreover I had bad experiences while trying that some years ago. I t

Re: PostgreSQL-Problem and Problem on Alioth

2005-01-26 Thread Martin Pitt
Hi! sean finney [2005-01-25 18:38 -0500]: > On Tue, Jan 25, 2005 at 10:38:37AM +0100, Martin Pitt wrote: > > There are two common ways to achieve that: > > > > - Connect as "www-data". For this you need an appropriate PostgreSQL > > user ("createuser www-data" as user postgres). Then you either

Re: PostgreSQL-Problem and Problem on Alioth

2005-01-25 Thread Andreas Tille
On Tue, 25 Jan 2005, sean finney wrote: if i'm understanding correctly, a security drawback of both these methods is that any web application would effectively have r/w privileges to every web app's database, right? Yes. There are some web applications (like zope) which do not run as this user and

Re: PostgreSQL-Problem and Problem on Alioth

2005-01-25 Thread sean finney
On Tue, Jan 25, 2005 at 10:38:37AM +0100, Martin Pitt wrote: > There are two common ways to achieve that: > > - Connect as "www-data". For this you need an appropriate PostgreSQL > user ("createuser www-data" as user postgres). Then you either make > www-data the owner of the database ("create

Re: PostgreSQL-Problem and Problem on Alioth

2005-01-25 Thread Martin Pitt
Hi Andreas! Andreas Tille [2005-01-25 9:43 +0100]: > On Mon, Jan 24, 2005 at 10:27:10PM +0100, Andreas Tille wrote: > >some applications do need a changed pg_hba.conf to work as expected. > > this raises something i'm wondering... what is the best generalized > method for setting up an applicati

Re: PostgreSQL-Problem and Problem on Alioth

2005-01-25 Thread Goswin von Brederlow
Andreas Tille <[EMAIL PROTECTED]> writes: > Hi, > > I tried to post a question to > > [EMAIL PROTECTED] > > which seemed to have failed because of > File "/usr/lib/mailman/Mailman/Message.py", line 178, in Enqueue > dbfp.close() >IOError: [Errno 28] No space left on dev

PostgreSQL-Problem and Problem on Alioth

2005-01-25 Thread Andreas Tille
Hi, I tried to post a question to [EMAIL PROTECTED] which seemed to have failed because of File "/usr/lib/mailman/Mailman/Message.py", line 178, in Enqueue dbfp.close() IOError: [Errno 28] No space left on device Any Alioth admins around? Concerning to the concrete question w