PostgreSQL-Problem and Problem on Alioth

[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 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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
    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 [EMAIL PROTECTED] ------
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 <[EMAIL PROTECTED]>
To: Debian PostgreSQL Liste <[EMAIL PROTECTED]>
cc: sean finney <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
To: Andreas Tille <[EMAIL PROTECTED]>
Cc: Dbconfig-common-devel <[EMAIL PROTECTED]>
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
--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]