Public bug reported:
Binary package hint: postgresql-8.3
versions: 8.3.6-0ubuntu8.10, 8.3.7-0ubuntu8.10
How to reproduce: set unix_socket_directory in postgresql.conf to /tmp
Result: applications using libpq-dev will fail when connecting to socket.
libpq-dev fails if you have the unix_socket_directory set to a path that
is not built in.
Users starting with rails are discouraged from using postgresql for this reason.
How on earth, without digging through the postgresql code base, will they know
they can pass the socket directory as the host parameter? In 99% of the cases,
overriding the default doesn't make any sense and libpq-dev could just as well
read the config file (not that I'm suggesting that).
Some people setup TCP/IP authentication when the great thing about
postgresql in socket mode - it uses ident matching.
The really luck people discover the unix_socket_directory option and change it
to match the system location.
The best way is to remove the entry completely, since postgresql and libpq use
the same define as default.
It took me a while to guest that at some point the underlying socket
directory changed but the postgresql.conf file was left with the '/tmp'
value. At first, common sense may suggest it isn't a server problem,
because the psql client works.
I know this is a db-setup / config issue, but showing a debconf dialog
recommending removing the unix_socket_directory line completely isn't
that complicated. Showing it once during the next server upgrade may
save people from moving to a featureless database just because the setup
is easier.
I'll even do it myself if the patch has a chance of being accepted - the
sun-java license dialog is identical in the functionality.
ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 8.10
NonfreeKernelModules: ath_hal
Package: libpq-dev 8.3.7-0ubuntu8.10
ProcEnviron:
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/home/username/bin
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: postgresql-8.3
Uname: Linux 2.6.27-14-generic i686
** Affects: postgresql-8.3 (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug libpq-dev
--
server upgrade should warn about non standard socket dir
https://bugs.launchpad.net/bugs/351497
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
