debian-postgresql list closed and postgresql problem

[Andreas Tille <tillea@rki.de>]

Hi,

there was a debian-postgresql list but it seems to have died ... :-(

>From MAILER-DAEMON@mailman.atnet.at Wed Oct 15 15:39:10 2003
Date: Wed, 15 Oct 2003 14:40:05 +0200 (CEST)
From: Mail Delivery System <MAILER-DAEMON@mailman.atnet.at>
To: TilleA@rki.de
Subject: Undelivered Mail Returned to Sender

This is the Postfix program at host mailman.atnet.at.

I'm sorry to have to inform you that the message returned
below could not be delivered to one or more destinations.

For further assistance, please contact <postmaster@mailman.atnet.at>

If you do so, please include this problem report. You can
delete your own text from the message returned below.

			The Postfix program

<debian-postgresql@cochrane.atnet.at>: Command died with status 1:
    "/var/lib/mailman/mail/wrapper post debian-postgresql". Command output:
    Mailman error: post got bad listname: debian-postgresql

-----------------------------------------------------------------------

And this is the problem I wanted to discuss.  I hope this is the nect
apropriate place for this kind of problems ...


Date: Wed, 15 Oct 2003 14:39:23 +0200 (CEST)
From: Andreas Tille <tillea@rki.de>
To: Debian PostgreSQL Liste <debian-postgresql@cochrane.atnet.at>
Subject: Problems connection via TCP/IP on SParc

Hi,

I compiled the Woody backport 7.3.4-2.woody.2 from Oliver on a Sparc machine.
When I used the normal stable 7.2.1-2woody package I was able to connect via
TCP/IP.  When I installed the backport mentioned above I did not changed any
configuration file but TCP/IP connections even from localhost failed.

First I had

   # grep tcpip /etc/postgresql/postgresql.conf
   tcpip_socket = on

I detected a change in the syntax of this file for more recent postgresql versions
and changed to

   # grep tcpip /etc/postgresql/postgresql.conf
   tcpip_socket = true

But on both systems a

   > psql -h localhost template1

fails. (I did not changed the port and also

   > psql -p 5432 -h localhost template1

fails as well.

Any hint whether there is a general problem on Sparc?

I tested this in an unstable chroot on i386 with 7.3.4 and had no problems at
all.  Even a connection from different host works perfectly.

Kind regards

          Andreas.