PostgreSQL-Problem and Problem on Alioth

[Andreas Tille <tillea@rki.de>]

Hi,

I tried to post a question to

         Pkg-postgresql-public@lists.alioth.debian.org

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 which is perhaps also interesting for
people reading this list, please read below


---------- Forwarded message ----------
Date: Mon, 24 Jan 2005 22:58:10 -0700
From: Mail Delivery System <Mailer-Daemon@haydn.debian.org>
To: TilleA@rki.de
Subject: Mail delivery failed: returning message to sender

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:

  pipe to |/var/lib/mailman/mail/wrapper post pkg-postgresql-public
    generated by Pkg-postgresql-public@lists.alioth.debian.org
    local delivery failed

The following text was generated during the delivery attempt:

------ pipe to |/var/lib/mailman/mail/wrapper post pkg-postgresql-public
       generated by Pkg-postgresql-public@lists.alioth.debian.org ------

Traceback (most recent call last):
  File "/var/lib/mailman/scripts/post", line 94, in ?
    main()
  File "/var/lib/mailman/scripts/post", line 89, in main
    msg.Enqueue(mlist, tolist=1)
  File "/usr/lib/mailman/Mailman/Message.py", line 178, in Enqueue
    dbfp.close()
IOError: [Errno 28] No space left on device

------ This is a copy of the message, including all the headers. ------

From: Andreas Tille <tillea@rki.de>
To: Debian PostgreSQL Liste <Pkg-postgresql-public@lists.alioth.debian.org>
cc: sean finney <seanius@seanius.net>

Hi,

perhaps some people in this list could give some reasonable advise here.
I'm uncertain myself how to do it the right way.

Thanks

         Andreas.

---------- Forwarded message ----------
Date: Mon, 24 Jan 2005 23:11:53 -0500
From: sean finney <seanius@debian.org>
To: Andreas Tille <tillea@rki.de>
Cc: Dbconfig-common-devel <dbconfig-common-devel@lists.alioth.debian.org>
Subject: Re: [Dbconfig-common-devel] Changing PostgreSQL configuration

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 application with a username/database in
postgresql?

in the latest code, i'm doing the following:

(as postgres)
createuser $dbc_dbuser
createdb $dbc_dbname -O $dbc_dbuser

what's not clear is how the application then gets into the
database as $dbc_dbuser.  assuming it runs as www-data (or some
system user if not a web app), should www-data be added to a map in
pg_ident.conf to connect as $dbc_dbuser?  or something in pg_hba.conf?
also, what about authorization methods other than ident?

i'm finding myself pushing up against the limits of what i know
about postgres (of which most has already come from the making of
this package).  so, any insight that you have would be helpful.

based on the suggestions that i get, i'll most certainly use
the debconf templates you provided with whatever alterations
are necessary.

thanks,
 	sean


--