Your message dated Mon, 23 May 2005 09:59:09 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Bug#309948: Unix socket in /tmp , should be /var/run/postgresql
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 20 May 2005 17:11:31 +0000
>From [EMAIL PROTECTED] Fri May 20 10:11:31 2005
Return-path: <[EMAIL PROTECTED]>
Received: from 67.107.77.98.ptr.us.xo.net (mail.dialmex.net) [67.107.77.98]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DZB23-0006c9-00; Fri, 20 May 2005 10:11:31 -0700
Received: from david.dialmex.net (dmxnocws13.dialmex.net [67.107.77.78])
by mail.dialmex.net (Postfix) with ESMTP id 41A8FEE997
for <[EMAIL PROTECTED]>; Fri, 20 May 2005 12:11:00 -0500 (CDT)
Subject: Unix socket in /tmp , should be /var/run/postgresql
From: David Stanaway <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Content-Type: text/plain
Date: Fri, 20 May 2005 12:11:00 -0500
Message-Id: <[EMAIL PROTECTED]>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.2
Content-Transfer-Encoding: 7bit
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Subject: Unix socket in /tmp , should be /var/run/postgresql
Package: postgresql-8.0
Version: 8.0.2-1
Distribution: experimental
Severity: important
*** Please type your report below this line ***
The unix socket that postgresql-8.0 sets up is in /tmp and this is not
where the perl DBD::Pg module expects it.
$ sudo lsof | grep postmast | grep unix
postmaste 1018 postgres 6u unix 0xd8b5e380
66453 /tmp/.s.PGSQL.5433
postmaste 4196 postgres 4u unix 0xdf01f380
6820 /tmp/.s.PGSQL.5433
$ ./testunixsocket.pl
DBI connect('dbname=scratch;port=5433','',...) failed: could not connect
to server: \uffffx\uffff\uffff\uffff
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5433"?
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (600, 'testing'), (500, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.11.9
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages postgresql-8.0 depends on:
ii libc6 2.3.2.ds1-21 GNU C Library: Shared
libraries an
ii libcomerr2 1.37-2 common error description
library
ii libkrb53 1.3.6-2 MIT Kerberos runtime
libraries
ii libpam0g 0.76-22 Pluggable Authentication
Modules l
ii libpq4 8.0.2-1 PostgreSQL C client library
ii libreadline4 4.3-11 GNU readline and history
libraries
ii libssl0.9.7 0.9.7e-3 SSL shared libraries
ii postgresql-client-8.0 8.0.3-1 front-end programs for
PostgreSQL
ii postgresql-common 7 manager for PostgreSQL
database cl
ii zlib1g 1:1.2.2-4 compression library -
runtime
-- no debconf information
--
David Stanaway <[EMAIL PROTECTED]>
---------------------------------------
Received: (at 309948-done) by bugs.debian.org; 23 May 2005 07:59:41 +0000
>From [EMAIL PROTECTED] Mon May 23 00:59:41 2005
Return-path: <[EMAIL PROTECTED]>
Received: from mail01.pironet-ndh.com (mail02.pironet-ndh.com) [194.64.31.10]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Da7qe-00077X-00; Mon, 23 May 2005 00:59:41 -0700
Received: from mail.fbn-dd.de (mail.fbn-dd.de [195.227.105.178])
by mail02.pironet-ndh.com (Postfix) with ESMTP id D4FA834541
for <[EMAIL PROTECTED]>; Mon, 23 May 2005 09:59:09 +0200 (CEST)
Received: from sonne.intranet.fbn-dd.de
(192-168-0-1.transfer-000.intranet.fbn-dd.de [192.168.0.1])
by mail.fbn-dd.de (Postfix) with ESMTP id D324B1F92F
for <[EMAIL PROTECTED]>; Mon, 23 May 2005 09:59:09 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
by sonne.intranet.fbn-dd.de (Postfix) with ESMTP id C334E1F4B8
for <[EMAIL PROTECTED]>; Mon, 23 May 2005 09:59:09 +0200 (CEST)
Received: from sonne.intranet.fbn-dd.de (localhost [127.0.0.1])
by localhost (AvMailGate-2.0.1.16) id 13849-556C429E;
Mon, 23 May 2005 09:59:09 +0200
Received: from localhost.localdomain (10-28-130-200.intranet-28-130.fbn-dd.de
[10.28.130.200])
by sonne.intranet.fbn-dd.de (Postfix) with ESMTP id 8F3951F4B8
for <[EMAIL PROTECTED]>; Mon, 23 May 2005 09:59:09 +0200 (CEST)
Received: by localhost.localdomain (Postfix, from userid 1000)
id EDBAF30F2E; Mon, 23 May 2005 09:59:09 +0200 (CEST)
Date: Mon, 23 May 2005 09:59:09 +0200
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#309948: Unix socket in /tmp , should be /var/run/postgresql
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL
PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="RYJh/3oyKhIjGcML"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
User-Agent: Mutt/1.5.9i
X-AntiVirus: checked by AntiVir MailGate (version: 2.0.1.16; AVE: 6.30.0.12;
VDF: 6.30.0.192; host: sonne)
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
--RYJh/3oyKhIjGcML
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi David!
David Stanaway [2005-05-20 12:11 -0500]:
> The unix socket that postgresql-8.0 sets up is in /tmp and this is not
> where the perl DBD::Pg module expects it.
This has been fixed for the common case that the cluster is owned by
the user 'postgres':
postgresql-common (9) experimental; urgency=3Dlow
* Add README.Debian with some general introduction, "first steps for the
impatient", and pointers to further documentation.
* pg_ctlcluster: Check validity of postmaster locale before setting it.
* pg_createcluster: Check validity of locale before calling initdb under =
it.
* pg_wrapper: Support PGCLUSTER environment variable. Closes: #305912
* pg_upgradecluster:
- Copy original configuration files.
- Configure the target cluster to use the original port, move the old
cluster to a previously unused port.
- Start the new cluster after upgrade.
* debian/init.d-functions: Create /var/run/postgresql if it does not exis=
t.
* pg_createcluster: Set the socket directory to /var/run/postgresql for
postgres-owned clusters. Print a warning to change the directory for ot=
her
owners. Closes: #308597
* pg_wrapper: If PGHOST is not defined, set it to the cluster's socket
directory to make client programs work with non-default socket
directories.
> On a related note, have you thought about having a debconf question
> about using different ports for v8? It might be very confusing for users
> to have 2 different installations on different ports, and I suspect it
> will create more problems than it solves.
What do you mean? Every cluster that is created (regardless of its
version) needs and gets its own port. You cannot run two clusters on
the same one.
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developer http://www.debian.org
--RYJh/3oyKhIjGcML
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
iD8DBQFCkY1NDecnbV4Fd/IRArc1AJ9serrp//EAWbn1P4pZh/UNPE26FwCeIdJA
SGz76Iu4SbjVDMMNQgYN65M=
=GACa
-----END PGP SIGNATURE-----
--RYJh/3oyKhIjGcML--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
