Bug#703806: postgresql: failed to start: couldn't create TCP/IP Sockets

2013-04-18 Thread Christoph Berg
Control: tags -1 moreinfo Re: Christian Meyer 2013-03-23 <20130323215007.30074.7076.reportbug@Imperator> > The logfile says that IPv4 Socket couldn't be bound and asks wheather an other > postmaster is running on port 5432: > 2013-03-23 22:26:32 CET LOG: konnte IPv4-Socket nicht binden: Die > an

Bug#705219: pg_checksystem does not respect start.conf

2013-04-18 Thread Christoph Berg
Re: Stephen Frost 2013-04-11 <20130411130202.ge4...@tamriel.snowman.net> > In our environment, we have shared storage which allows us to fail over > between two systems, however, we intentionally keep on the filesystems > mounted for those clusters which are running on the current system, to > redu

Bug#705767: RFA: pycocuma -- Pythonic Contact and Customer Management

2013-04-19 Thread Christoph Berg
Package: wnpp Severity: normal I request an adopter for the pycocuma package. I'm not using it anymore, so it should go to a new maintainer. The package description is: PyCoCuMa (Pythonic Contact and Customer Management) provides a personal information system for addresses, telephone numbers an

Bug#706088: Missing backup of global objects (users, tablespaces)

2013-04-24 Thread Christoph Berg
Package: autopostgresqlbackup Version: 1.0-1 Severity: important The script doesn't use pg_dumpall --globals to make a backup of global objects in the database. The resulting dumps will only restore with errors because the users and tablespaces do no exist. Christoph -- c...@df7cb.de | http://ww

Bug#703806: postgresql: failed to start: couldn't create TCP/IP Sockets

2013-04-26 Thread Christoph Berg
Re: Christian Meyer 2013-04-19 <1366407520.13657.15.camel@Imperator> > Yes, it is. Hi Christian, thanks for the feedback. > # host localhost > ;; Warning: Message parser reports malformed message packet. > localhost has address 127.0.0.1 > Host localhost not found: 3(NXDOMAIN) > Host localhost n

Bug#671915: postgresql breaks logs

2013-04-29 Thread Christoph Berg
Control: tags -1 confirmed Re: Dmitry E. Oboukhov 2012-05-08 <20120508055141.ga25...@apache.rbscorp.ru> > Package: postgresql-9.1 > Version: 9.1.3-2 > Tags: l10n > > Since (I think) I've upgraded postgresql server upto 9.1 version I see > broken logs. The previous versions of Pg wrote logs in Eng

Bug#653772: pg_upgrade needs pg_config

2013-05-02 Thread Christoph Berg
Control: tags -1 moreinfo Re: Peter Eisentraut 2011-12-30 <20111230215124.3568.73647.report...@vanquo.pezone.net> > Source: postgresql-contrib-9.1 > Version: 9.1.2-1 > Severity: normal > > pg_upgrade (which, btw., is not mentioned in the package description) > needs pg_config to run, so in order

Bug#684429: closed by Christoph Berg (Re: Bug#684429: postgresql 9.1 cant allow conection: port 5432 are not visible in any case)

2013-05-02 Thread Christoph Berg
Re: PICCORO McKAY Lenz 2013-05-02 > Chris.. in every install of backported postgres 9.X i have to nstall first > postgres 8.X and then removed before install postgres 9.X, if not, the > instalation of postgres 9.X from backported could not work in networks.. > port are ghosted and hidden.. always

Bug#684429: closed by Christoph Berg (Re: Bug#684429: postgresql 9.1 cant allow conection: port 5432 are not visible in any case)

2013-05-02 Thread Christoph Berg
Re: PICCORO McKAY Lenz 2013-05-02 > ok, chris.. > > i have a presence system for the company.. that need postgres 9.X in both > client and server... > > so then : > > 1) install debian squeeze netinstall > 2) then after install added a repository of backport an debian > 3) then install postgre

Bug#706849: libpq5: enable multi-arch

2013-05-05 Thread Christoph Berg
Re: Helmut Grohne 2013-05-05 <20130505131722.ga23...@alf.mars> > I tried to come up with a patch for this, but apparently this is not > totally trivial. One step required for gaining multi-arch is to change > --libdir to /usr/lib/. This also changes > /usr/lib/postgresl/$(MAJORVER)/lib to > /usr/li

Bug#706849: [Pkg-postgresql-public] Bug#706849: libpq5: enable multi-arch

2013-05-06 Thread Christoph Berg
Re: Martin Pitt 2013-05-06 <20130507050407.ge2...@piware.de> > Christoph Berg [2013-05-05 22:51 -0700]: > > (And if we do this, I need to find a way how to auto-revert this for > > the squeeze suite on apt.postgresql.org...) > > That was the main reason why I didn&#

Bug#710093: postgresql: not started automatically after installation in chroot

2013-05-29 Thread Christoph Berg
Control: tags -1 moreinfo Re: Andreas Beckmann 2013-05-28 <20130528082018.7493.49330.report...@cake.ae.cs.uni-frankfurt.de> > I'm experimenting with db support for piuparts tests and therefore > postgresql needs to be installed and started in the test chroots. Fwiw, which services/packages come

Bug#710093: postgresql: not started automatically after installation in chroot

2013-05-31 Thread Christoph Berg
Re: Andreas Beckmann 2013-05-31 <51a8feac.5090...@debian.org> > > Fwiw, which services/packages come with out-of-the-box usable > > PostgreSQL support? For me, dbconfig-common sort of never works... > > For piuparts, dbconfig-common seems to work for most packages. > DEBIAN_FRONTEND=noninteractive

Bug#710589: pu: packages libiodbc2/3.52.7-3 and psqlodbc/1:09.01.0200-1

2013-05-31 Thread Christoph Berg
dbc2 (3.52.7-2wheezy1) stable; urgency=low + + * QA upload + * Find odbc drivers in a system dir (e.g. /usr/lib/x86_64-linux-gnu/odbc/). + + -- Christoph Berg Fri, 31 May 2013 23:12:13 -0700 + libiodbc2 (3.52.7-2) unstable; urgency=low * QA upload diff -Nru libiodbc2-3.52.7/debian/patches/0

Bug#710093: postgresql: not started automatically after installation in chroot

2013-06-01 Thread Christoph Berg
Re: Andreas Beckmann 2013-06-01 <51aa008c.1070...@debian.org> > > Btw, can you share this policy-rc.d? > > #!/bin/sh > test "$1" = "mysql" && exit 0 > test "$1" = "postgresql" && exit 0 > exit 101 Thanks. > Narrowing this down to installing perl ... which reminded me of your > first reply: Oh,

Bug#710589: pu: packages libiodbc2/3.52.7-3 and psqlodbc/1:09.01.0200-1

2013-06-01 Thread Christoph Berg
Re: Adam D. Barratt 2013-06-01 <4bb564124a9eca52168a1e06a...@mail.adsl.funky-badger.org> > Being slightly picky, this: > > >-Breaks: unixodbc (<< 2.2.14p2-3), odbcinst1debian2 (<< 2.2.14p2-3), > >libiodbc2 > >+Breaks: unixodbc (<< 2.2.14p2-3), odbcinst1debian2 (<< 2.2.14p2-3), > >+ libiodbc2

Bug#703355: signing-party: include gpg-import-imap script

2013-03-19 Thread Christoph Berg
Re: Dominik George 2013-03-18 <20130318183211.15764.81281.report...@keks.naturalnet.de> > I have created a script that can: > > - Connect to an IMAP server > - Search for messages in a mailbox > - Recognize caff-generated mail > - Decrypt these messages if necessary > - Import contained publ

Bug#703437: Support data.tar.bz2 and data.tar.xz

2013-03-19 Thread Christoph Berg
+nmu1/debian/changelog 2013-03-19 16:14:53.0 +0100 @@ -1,3 +1,10 @@ +dpkg-sig (0.13.1+nmu1) unstable; urgency=low + + * Non-maintainer upload. + * Allow data.tar.bz2 and data.tar.xz in .deb files. + + -- Christoph Berg Tue, 19 Mar 2013 16:14:03 +0100 + dpkg-sig (0.13.1) unstable; urgency

Bug#703754: release-notes: postgresql-8.4 notes

2013-03-23 Thread Christoph Berg
Package: release-notes Severity: normal Tags: patch wheezy Here's two updates from the PostgreSQL camp. Index: en/whats-new.dbk === --- en/whats-new.dbk(Revision 9642) +++ en/whats-new.dbk(Arbeitskopie) @@ -310,8 +310,8 @@

Bug#698942: Remove (or clarify) the "sleep 5" call in restart

2013-03-23 Thread Christoph Berg
Re: Chris Lamb 2013-01-25 <20130125140817.16c72aa3@seriouscat.config> > The -R support was added in #657204 but Cody's patch didn't include the > sleep 5 - is it necessary? > > If it is necessary, please could you comment in the initscript why it > is - I can remove it and it appears to work but I

Bug#703850: postgresql-contrib not upgraded

2013-03-25 Thread Christoph Berg
Control: retitle -1 pg_upgradecluster should warn if packages are missing Re: Daniel Pocock 2013-03-24 <514f583c.9070...@pocock.com.au> > This is an upgrade problem > > Old system has postgresql-8.4 and postgresql-contrib-8.4 on squeeze > > It is upgraded to wheezy > > postgressql-9.1 was insta

Bug#699735: Include snmptthandler-embedded

2013-02-04 Thread Christoph Berg
Package: snmptt - Forwarded message from Harald Jenny - Date: Sun, 3 Feb 2013 21:15:18 +0100 From: Harald Jenny To: Christoph Berg Subject: Feature request for snmptt package in experimental Dear Christoph Berg, I had a look at the snmptt package in experimental and wanted to thank

Bug#699738: Suggests non-existing package postgresql-server

2013-02-04 Thread Christoph Berg
Package: postfix-cluebringer-pgsql Version: 2.0.10-1 Severity: normal ... it should suggest "postgresql" instead. Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas..

Bug#699911: [Pkg-postgresql-public] Bug#699911: postgresql-common: init.d start script quits if a pg cluster cannot be started so clusters after this pg cluster will also not start

2013-02-07 Thread Christoph Berg
Re: Frank Baalbergen 2013-02-06 <51128026.7080...@mendix.com> > To test this, i changed the unix_socket_directory of the postgresql > 9.0 cluster (second cluster). > > -unix_socket_directory = '/var/run/postgresql' # (change > requires restart) > +unix_socket_directory = '/var/run/postgre

Bug#700462: apgdiff outdated, please update package to 2.4

2013-02-13 Thread Christoph Berg
Re: Michael Neuffer 2013-02-13 <511b5caf.5080...@neuffer.com> > What is keeping you from migrating it to unstable? While testing is frozen, we'll only upload stuff to unstable that we want to have released with wheezy. Newer upstream versions will be staged in experimental until the wheezy release

Bug#694454: [Pkg-postgresql-public] Bug#694454: pg_ctlcluster should probably have support for numactl and similar wrappers

2013-02-18 Thread Christoph Berg
Re: Martin Pitt 2013-02-16 <20130216184148.gb2...@piware.de> > I don't know what numactl does, so I cannot comment on whether it's a > good idea to do this, and whether it's always safe to do. Just to clarify: I want this to be optional, and configurable. (And in the usecase I had intended it for

Bug#701101: ITP: postgresql-hll -- HyperLogLog extension for PostgreSQL

2013-02-22 Thread Christoph Berg
Re: Cyril Bouthors 2013-02-21 <87sj4pg0rx@lenovo.isvtec.com> > This Postgres module introduces a new data type `hll` which is a HyperLogLog Nice. Extra kudos if you are using pg_buildext so it works with any supported server version :) Let me know if you want any assistance with that, or need

Bug#703047: odbc-postgresql cannot be installed alongside kde

2013-05-11 Thread Christoph Berg
Control: tags -1 confirmed Re: George Kiagiadakis 2013-03-14 > Package: odbc-postgresql > Version: 1:09.01.0100-1 > Severity: important > > I need to install odbc-postgresql on a system that is running a kde desktop. > However, odbc-postgresql declares Breaks on libiodbc2, which is a > direct d

Bug#702457: [Pkg-postgresql-public] Bug#702457: [postgresql-9.2] Can't install postgresql-9.2

2013-03-07 Thread Christoph Berg
> How can I install postgresql-9.2 package? https://wiki.postgresql.org/wiki/Apt Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Bug#488560: postgresql-doc-8.3: please document support for numeric IPs in PQconnectdb()'s "host" parameter

2013-05-20 Thread Christoph Berg
Re: Sebastian Harl 2008-06-29 <20080629190552.ga13...@albany.tokkee.org> > Package: postgresql-doc-8.3 > Version: 8.3.3-1 > Severity: wishlist > > Hi, > > The current implementation of PQconnectdb() used getaddrinfo() to > resolve the host specified by the "host" parameter. This makes it > possib

Bug#704802: plperl crashes immediately on kfreebsd

2013-05-21 Thread Christoph Berg
lease excuse if I didn't include something in this report. I have the coredumps here so I can provide more information. Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org) To make changes to your subscription: http://www.po

Bug#704802: [Pkg-postgresql-public] Bug#704802: plperl crashes immediately on kfreebsd

2013-05-21 Thread Christoph Berg
tual problem might be somewhere > > down the stack (libperl etc.). > > I've forwarded this to the pgsql-hackers list. > > Christoph > -- > c...@df7cb.de | http://www.df7cb.de/ > Date: Tue, 14 May 2013 23:42:02 -0700 > From: Christoph Berg > To: PostgreS

Bug#704802: [HACKERS] plperl segfault in plperl_trusted_init() on kfreebsd

2013-05-21 Thread Christoph Berg
Re: Andrew Dunstan 2013-05-17 <51964770.6070...@dunslane.net> > I have reproduced this. It happens with both the distro perl and a > home-built perl 5.14. AFAICT this is a Perl bug. Any reference at > all to ERRSV at the point this occurs causes a core dump, even just > assigning it to a local SV *

Bug#663077: odbcinst: should use package section utils (not libs)

2013-05-26 Thread Christoph Berg
Re: Jonas Smedegaard 2012-03-08 <20120308110746.25952.9794.reportbug@localhost.localdomain> > Package: odbcinst > Version: 2.2.14p2-5 > Severity: normal > > odbcinst is not a library, so should use package section utils instead. Probably even Section: database? Christoph -- c...@df7cb.de | htt

Bug#709968: odbcinst -j undocumented in manpage

2013-05-26 Thread Christoph Berg
Package: odbcinst Version: 2.2.14p2-5 Severity: minor $ odbcinst -j unixODBC 2.2.14 DRIVERS: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /home/cbe/.odbc.ini SQLULEN Size...: 8 SQLLEN Size: 8 SQLSETPOSIR

Bug#571139: torrus-apache2 must not depend on apache2-mpm-worker --- causing crashes

2010-03-05 Thread Christoph Berg
Re: Stanislav Sinyagin 2010-02-23 > here's the upstream software maintainer. Torrus is incompatible with > apache2-mpm-worker: Multithreading in Apache causes Torrus database > corruption. > > The package must depend on apache2-mpm-prefork > > The fix has been tested, and the system runs stable

Bug#572534: charset MS950

2010-03-05 Thread Christoph Berg
Re: jida...@jidanni.org 2010-03-04 <87iq9cszff@jidanni.org> > Mutt needs: > $ sed s/MS950/big5/ /tmp/er>/tmp/er3 > $ mutt -f /tmp/er3 > > to deal with > Subject: =?MS950?B?plinQKr3rne7yKbmsWK4ubjqsFQ=?= Consider using a charset-hook. Not sure if that should make it into the Debian package. C

Bug#541004: ITA: snes9x -- X binaries for snes9x - Super NES Emulator

2010-03-05 Thread Christoph Berg
retitle 541004 O: snes9x -- X binaries for snes9x - Super NES Emulator thanks Re: Nick Andrik 2010-01-24 <4b5b8ff3.5020...@gmail.com> > Is there still need for help in this package? > I see that the packaged version is 1.5 while the upstream one is 1.51 > (they have change their page to http://sne

Bug#543608: ITA: libdbix-recordset-perl -- Perl extension for DBI recordsets

2010-03-05 Thread Christoph Berg
Re: Ryan Niebur 2009-08-26 <20090826045925.ga1...@jade.home> > Package: wnpp > Severity: wishlist > Tags: pending > Owner: pkg-perl-maintain...@lists.alioth.debian.org > > This package is now in our repo, see > http://lists.debian.org/debian-perl/2009/08/msg00085.html Hi, please consider upload

Bug#573224: debian-maintainers: Please add Ahmed El-Mahmoudy as Debian Maintainer

2010-03-28 Thread Christoph Berg
ne project was making a linux distribution called > > "Pharonix", also his GPG key is signed by Mohammed Sameer (key ID: > > A3FD0DF7) who is a DD. > > Fantastic. One of the DAMs (Joerg Jaspert (Ganneff on IRC) or Christoph > Berg (Myon on IRC)) should soon get in

Bug#511133: phpmyadmin: Syntax error in Apache while configuring and phppgadmin is not yet postinst

2011-06-14 Thread Christoph Berg
tags 511133 + moreinfo thanks > Unpacking phpmyadmin[...] > Unpacking phppgadmin[...] > ... > Setting up phpmyadmin (4:2.11.8.1-5) ... > apache2: Syntax error on line 278 of /etc/apache2/apache2.conf: Could > not open configuration file /etc/apache2/conf.d/phppgadmin: No such file > or directory >

Bug#515776: Allow php5-cgi only install of phppgadmin

2011-06-14 Thread Christoph Berg
tags 515776 + moreinfo thanks Re: Chris Dukes 2009-02-17 <20090217161306.ga32...@raleigh.neotoma.org> > Unlike phpmyadmin, phppgadmin currently requires an httpd to be installed. > As my intent is to keep httpd far away from web app and db servers, > allowing phppgadmin to be installed with just p

Bug#639470: ip4r: Please move from postgresql-8.4 to postgresql-9.1

2011-10-08 Thread Christoph Berg
SED; urgency=low + + * Non-maintainer upload. + * New upstream version compatible with PG 9.0. + * Convert to use pg_buildext to build against PG 9.1; +closes: #605711, #639470. + + -- Christoph Berg Sat, 08 Oct 2011 00:10:01 +0200 + ip4r (1.04-1) unstable; urgency=low * New upstream re

Bug#644290: phppgadmin multiple XSS (CVE-2011-3598)

2011-10-10 Thread Christoph Berg
> Multiple XSS vulnerabilities have been reported in phpPgAdmin: > https://secunia.com/advisories/46248/ > > Please ensure that unstable is fixed on short notice and give the upload > an elevated urgency tag. Hi, unstable was fixed a few days ago, unfortunately without a bumped urgency. > Can y

Bug#630569: [php-maint] Bug#630569: Bug#630569: php5-pgsql and postgresql-9.0 seem to collude never to close idle persistent connections

2011-10-15 Thread Christoph Berg
tags 630569 moreinfo severity 630569 important thanks Re: Josip Rodin 2011-06-18 <20110618112228.ga15...@entuzijast.net> > > > I still don't see how this could be a php5-pgsql bug since it's caused > > > by pgsql version. > > > > I filed it preemptively on all so as to solicit help... if there is

Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2011-10-15 Thread Christoph Berg
severity 571135 normal thanks Re: Bastian Blank 2010-02-23 <20100223185637.ga7...@wavehammer.waldi.eu.org> > By default, public have USAGE rights to template1, so can always connect > there if allowed by pg_hba.conf. Now the default permissions of the > public schema are CREATE and USAGE for publi

Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2011-10-15 Thread Christoph Berg
Re: Bastian Blank 2011-10-15 <20111015184537.ga10...@wavehammer.waldi.eu.org> > On Sat, Oct 15, 2011 at 08:04:35PM +0200, Christoph Berg wrote: > > I don't think this is going to be changed. The initial permissions are > > there to make the database usable for &quo

Bug#640198: dpkg-source(1): Please include extended-diff-ignore example

2011-09-03 Thread Christoph Berg
Package: dpkg-dev Version: 1.16.0.3 Severity: wishlist dpkg-source(1); --extend-diff-ignore=regexp The perl regular expression specified will extend the default regular expression associated to -i by concatenating "|regexp" to the default re

Bug#506196: [postgresql] Proposed patches to avoid useless wakeups

2011-09-03 Thread Christoph Berg
Re: Adrien Clerc 2011-09-03 <4e620a3b.6010...@antipoul.fr> > These are clearly not final patches. They work for me, that's it. > Especially, the second patch should be tested in case when the > postmaster crashes unexpectedly. > The first patch removes sleep cuts for any platform other than > WIN32

Bug#640493: postgresql-common: logrotate 3.8.0 breaks postgresql log rotation.

2011-09-06 Thread Christoph Berg
Re: Paul Martin 2011-09-06 <20110906110426.ga2...@nowster.org.uk> > It doesn't break, but root gets the following error emailed from cron. > > /etc/cron.daily/logrotate: > error: postgresql-common:10 unknown option 'su' -- ignoring line > error: postgresql-common:10 unexpected text Hmm. Would it

Bug#639140: upgrade of postgresql-common restarts all postgresql servers

2011-08-25 Thread Christoph Berg
Re: Peter Eisentraut 2011-08-24 <20110824134556.7010.97110.report...@fsopti579.f-secure.com> > I don't think it used to do that. It might have been introduced when > the unified init script was added and debhelper automatically added > its bits to prerm and postinst. Check please. I was also su

Bug#622019: sslscan: FTBFS: sslscan.c:566: undefined reference to `SSLv2_client_method'

2011-08-26 Thread Christoph Berg
Re: Ilya Barygin 2011-08-23 <4e53e126.6040...@gmail.com> > tags 622019 patch > thanks > > Hello, > > Attached patch was used to fix this in Ubuntu. > https://launchpad.net/ubuntu/+source/sslscan/1.8.2-1ubuntu1 > Description: Fix build in case of disabled SSLv2. This is needed for build > with >

Bug#639612: ifupdown postinst doesn't like run.dpkg-old

2011-08-28 Thread Christoph Berg
Package: ifupdown Version: 0.7~alpha5+really0.6.14 Severity: grave $ LC_ALL=C apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. After th

Bug#639612: ifupdown postinst doesn't like run.dpkg-old

2011-08-28 Thread Christoph Berg
Re: To Debian Bug Tracking System 2011-08-28 <20110828164121.ga5...@msgid.df7cb.de> > mv: accessing `/etc/network/run.dpkg-old': Too many levels of symbolic links > > $ l /etc/network > lrwxrwxrwx 1 root root 16 23. Jun 15:07 run -> /dev/shm/network > lrwxrwxrwx 1 root root 16 10. Apr 201

Bug#639473: plr: Please move from postgresql-8.4 to postgresql-9.1

2011-08-29 Thread Christoph Berg
Re: Andreas Tille 2011-08-29 <20110829120537.gb21...@an3as.eu> > Hi, > > Christoph Berg has recently added himself as co-maintainer. Christoph, > I'd be quite happy if you would take over completely. I do not use this > package any more and would be in favour of handin

Bug#618532: postgresql-9.0 won't install, complaining of permissions on server.key

2011-08-31 Thread Christoph Berg
Re: David Starner 2011-03-16 > >> FATAL: private key file "server.key" has group or world access > >> 2011-03-15 18:21:36 PDT DETAIL: File must be owned by the database > >> user or root, must have no write permission for "group", and must have > >> no permissions for "other". ... failed! > > > >

Bug#628786: pgcrypto.so not usable by default, nor after jumping through hoops

2011-08-31 Thread Christoph Berg
tags 628786 unreproducible moreinfo thanks Re: Josip Rodin 2011-06-01 <20110601105638.ga2...@entuzijast.net> > Package: postgresql-contrib-9.0 > Version: 9.0.4-1~bpo60+1 > > Hi, > > I needed to get SHA-1 support in PostgreSQL. Googling says pgcrypto is the > contrib module to use. So I installed

Bug#618532: postgresql-9.0 won't install, complaining of permissions on server.key

2011-08-31 Thread Christoph Berg
Re: David Starner 2011-08-31 > It's a symlink to /etc/ssl/private/ssl-cert-snakeoil.key What user/group own this file? Can you still reproduce the problem? The default is root:ssl-cert which should not be changed. For this to work, postgres should be member of the ssl-cert group. (adduser postg

Bug#640493: postgresql-common: logrotate 3.8.0 breaks postgresql log rotation.

2011-09-18 Thread Christoph Berg
Re: Martin Pitt 2011-09-18 <20110918111056.gf3...@piware.de> > http://bazaar.launchpad.net/~pitti/postgresql/common/revision/1099 > > Of course it's a bit of a hack, but works with all logrotate versions > and keeps backportability. Cool idea. > > to logrotate, and hope that you will add a "D

Bug#642133: [postgresql-9.1] After upgrading from 9.0 to 9.1 postgres fails to start: FATAL: could not create shared memory segment: Invalid argument

2011-09-19 Thread Christoph Berg
tags 642133 + moreinfo thanks Re: Paolo Scarabelli 2011-09-19 <4e778189.4020...@msw.it> > $ pg_upgradecluster 9.0 main > > At which point it converted all the databases, unfortunately I lost the > output but I remember the conversion was successful. > > After the conversion however postgres 9.1

Bug#642133: [postgresql-9.1] After upgrading from 9.0 to 9.1 postgres fails to start: FATAL: could not create shared memory segment: Invalid argument

2011-09-20 Thread Christoph Berg
Re: Paolo Scarabelli 2011-09-20 <4e7821b3.4070...@msw.it> > To fix the problem I had to purge and reinstall 9.1 (erasing all the > data) and restored the database from a backup (Note that at this point I > restored only the smaller of the databases). Did you also restore the postgresql.conf? Plea

Bug#643645: FTBFS twice with newer dpkg

2011-09-28 Thread Christoph Berg
Re: Peter Eisentraut 2011-09-28 <20110928103128.11033.39279.report...@fsopti579.f-secure.com> > The fix is to clean that file explicitly; see attached patch. Here's an alternative patch that I was throwing into my 8.2/8.3 packages for the upcoming apt.postgresql.org archive (atm at pgapt.debian.n

Bug#714725: Consider setting APT::NeverAutoRemove::"postgresql-*" in apt.conf

2013-07-02 Thread Christoph Berg
Package: postgresql Version: 9.1+134wheezy3 Severity: wishlist I've twice seen people on #postgresql who were upgrading from squeeze to wheezy and ended up with postgresql-8.4 removed and postgresql-9.1 installed, the existing 8.4 cluster being inaccessible. What happened there is that they have "

Bug#714725: [Pkg-postgresql-public] Bug#714725: Consider setting APT::NeverAutoRemove::"postgresql-*" in apt.conf

2013-07-02 Thread Christoph Berg
Re: Peter Eisentraut 2013-07-02 <51d2bd16.6020...@debian.org> > > 3) would be needed if we decide that we also need to care about > > extension modules that should not be removed on dist-upgrade. > > (Though I tend to think these would usually be manually installed. > > But we might have the same

Bug#714725: [Pkg-postgresql-public] Bug#714725: Consider setting APT::NeverAutoRemove::"postgresql-*" in apt.conf

2013-07-09 Thread Christoph Berg
Re: Peter Eisentraut 2013-07-03 <1372818582.22689.6.ca...@vanquo.pezone.net> > Marking only the stable version doesn't sound very reliable. If you > want to guard the data, you have to do it independent of what the > preferred version is. Users of apt.postgresql.org will have even more > complex

Bug#714982: postgresql-common: logrotate should not be required by the package

2013-07-09 Thread Christoph Berg
Re: Bill MacAllister 2013-07-05 <20130705063000.15787.33162.report...@trainmaster.stanford.edu> > Since logrotate is not required for the effective use of postgresql is > should not be required by the package, rather is should be recommended. Nod. I think we should just Recommends: logrotate, a

Bug#554843: bullding pure binary deb packages: patch

2013-07-10 Thread Christoph Berg
Re: Thijs Kinkhorst 2012-10-19 <201210191444.39967.th...@uvt.nl> > Here's a patch to extend dkms to also build 'pure binary' deb packages which > can be installed on hosts without requiring gcc and friends to be present. > The > use cases can be found in this bug log. It can be dropped in the >

Bug#716854: [Pkg-postgresql-public] Bug#716854: postgresql-common: Upgrade Wheezy -> Testing fails: insserv rejected the script header

2013-07-15 Thread Christoph Berg
Control: tag -1 moreinfo Re: Helge Kreutzmann 2013-07-13 <20130713163701.GA17133@Debian-50-lenny-64-minimal> > postgresql-common (145) wird eingerichtet ... > insserv: script postgresql: service postgresql already provided! > insserv: exiting now! > update-rc.d: error: insserv rejected the scrip

Bug#711869: "limit source postgresql-common" is broken

2013-06-10 Thread Christoph Berg
Package: debbugs This seems wrong: - Forwarded message from Debian Bug Tracking System - Date: Sun, 09 Jun 2013 20:21:05 + From: Debian Bug Tracking System To: Christoph Berg Subject: Processed (with 1 errors): limit source to postgresql-common, tagging 710093 X-Debian-PR

Bug#711954: iusql+odbc-postgresql is broken on mips

2013-06-11 Thread Christoph Berg
Package: psqlodbc, unixodbc Severity: important Unixodbc's iusql (unicode) binary with the odbc-postgresql driver seems to be broken on mips (it works on mipsel), while isql (ansi) just works fine: [130] 15:10 myon@sid_mips-dchroot.gabrielli:~/psql/psqlodbc-09.01.0200 quilt: 2s $ isql ANSI +

Bug#688087: Too many open files in system

2013-06-19 Thread Christoph Berg
Control: tags -1 moreinfo Re: Giuseppe Sacco 2012-09-19 <1348041431.9028.11.camel@scarafaggio> > Every two weeks, this database server stop working because of maximum > open files reached by postgres user. This is an excerpt of > postgresql.log > > 2012-09-18 17:16:31 CEST LOG: out of file descr

Bug#596278: postgresql-8.4: Please support subselects in "using" clause of "alter column" changing type

2013-06-19 Thread Christoph Berg
Testcase: create table links (targeturi text, uri text); create table pages (pageid integer, uri text); alter table links alter column targeturi type integer using (select pageid from pages where uri = targeturi); Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to

Bug#717191: adt-run: "ImportError: No module named debian" with old python-debian version

2013-07-17 Thread Christoph Berg
Package: autopkgtest Version: 2.2.4 Severity: normal Tags: patch Hi, for apt.postgresql.org, we are running autopkgtest on lots of distributions, including Ubuntu's lucid release. There, adt-run fails: # adt-run Traceback (most recent call last): File "/usr/bin/adt-run", line 39, in from

Bug#669837: RFS: phppgadmin_5.1-1.1 [NMU]

2013-07-22 Thread Christoph Berg
Control: tags -1 + moreinfo Re: Jean-Michel Vourgère 2013-07-22 <201307221427.51037.jmv_...@nirgal.com> > +. Upgrade phppgadmin.conf restriction to localhost to 2.4 format. Hi Jean-Michel, thanks for the patch. We need a source package that is also compatible with squeeze and lucid so it is

Bug#717982: postgresql-9.3-dbg: fails to upgrade from 'sid' - trying to overwrite /usr/lib/debug/usr/bin/pg_config

2013-07-27 Thread Christoph Berg
> Unpacking postgresql-9.3-dbg (from > .../postgresql-9.3-dbg_9.3~beta2-2_amd64.deb) ... > dpkg: error processing > /var/cache/apt/archives/postgresql-9.3-dbg_9.3~beta2-2_amd64.deb (--unpack): >trying to overwrite '/usr/lib/debug/usr/bin/pg_config', which is also in > package postgresql-

Bug#721018: pu: package postgresql-common/134wheezy4

2013-08-27 Thread Christoph Berg
* debian/supported-versions: Use "7|7.*" to recognize wheezy; point releases +now increment the second version number component. (Closes: #712586) + + -- Christoph Berg Tue, 27 Aug 2013 10:15:33 +0200 + postgresql-common (134wheezy3) unstable; urgency=low [ Christoph Ber

Bug#721216: Debian pgpool not compiled with memcached suppport

2013-08-29 Thread Christoph Berg
Package: pgpool2 Version: 3.3.0-1 Severity: wishlist Date: Thu, 29 Aug 2013 09:21:18 +0200 From: David Schmitz To: m...@debian.org Subject: Debian pgpool also not compiled with memcached suppport Hi, I have tried at home with my Debian Linux as well and also this pacakage is missing memcached s

Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied

2013-10-08 Thread Christoph Berg
Re: John Proios 2013-10-08 <5253a539.2050...@snigel.gr> > Tnks Christoph for reply > > Selinux is not active. > > The configuration is the default one. It is a typical installation of > postgres. I think the problem lies in the after deb rules Hi John, could you try the following, while postgre

Bug#725795: debversion should use pg_buildext to build for multiple PostgreSQL versions

2013-10-08 Thread Christoph Berg
Source: postgresql-debversion Version: 1.0.7-3 Severity: wishlist Tags: patch Hi, the attached patch makes postgresql-debversion use pg_buildext to dynamically build for the list of supported PostgreSQL versions. I would like to properly have debversion on apt.postgresql supported for all Postgr

Bug#722350: RM: postgresql-9.2/experimental -- ROM; superseded by postgresql-9.3

2013-09-10 Thread Christoph Berg
Package: ftp.debian.org Severity: normal Hi, please remove postgresql-9.2 from experimental, we have postgresql-9.3 now. There shouldn't be any rdeps. Christoph -- c...@df7cb.de | http://www.df7cb.de/ signature.asc Description: Digital signature

Bug#722457: Make (stderr) output more readable

2013-09-11 Thread Christoph Berg
Package: autopkgtest Version: 2.3.2 Severity: wishlist Hi, it would be nice if autopkgtest would make the test output more readable. There's two things I'd want: * Do not split stderr and stdout - errors are often meaningless if they are not shown with their normal stdout context This could

Bug#722458: Make TMPDIR usable for non-root

2013-09-11 Thread Christoph Berg
Package: autopkgtest Version: 2.3.2 Severity: wishlist If the tests switch user, and the program run happens to honor TMPDIR, it will fail because autopkgtest's TMPDIR is 0700 for root. Invoking chmod 1777 $TMPDIR before switching users doesn't help because the directory is somewhere deeply in /tm

Bug#722583: delgroup --only-if-empty is undocumented in manpage

2013-09-12 Thread Christoph Berg
Package: adduser Version: 3.113+nmu3 Severity: normal delgroup --help mentions --only-if-empty, but it is missing in the manpage. Please add it there, too. Christoph -- c...@df7cb.de | http://www.df7cb.de/ signature.asc Description: Digital signature

Bug#722612: upower --status hangs on upgrade

2013-09-12 Thread Christoph Berg
Package: upower Version: 0.9.21-3 Severity: grave It happened twice to me today that an "apt-get upgrade" from wheezy to jessie hangs: uniutils (2.27-2) wird eingerichtet ... unrar (1:5.0.10-1) wird eingerichtet ... upower (0.9.21-3) wird eingerichtet ... Neue Version der Konfigurationsdatei /et

Bug#718697: ptop is incompatible with PostgreSQL >= 9.2

2013-08-04 Thread Christoph Berg
Package: ptop Version: 3.6.2-5 Severity: normal Hi, please consider packaging the new upstream release of ptop - the current version in stable/unstable is incompatible with PostgreSQL >= 9.2 because pg_stat_activity changed some column names (procpid -> pid, ...). Christoph -- c...@df7cb.de | h

Bug#485610: Bug#718961: RM: oftc-hybrid -- RoQA; GPL software linking with OpenSSL

2013-08-08 Thread Christoph Berg
Re: Ansgar Burchardt 2013-08-07 <5202018d.2030...@debian.org> > Package: ftp.debian.org > X-Debbugs-Cc: Christoph Berg > > Please remove oftc-hybrid from the archive. It is licensed under the > GPL, but links OpenSSL (#485610). The package as already been removed >

Bug#719282: installing dictionary package restarts postgresql servers

2013-08-12 Thread Christoph Berg
Control: retitle -1 installing dictionary package appears to restart postgresql Re: Peter Eisentraut 2013-08-10 <20130810015034.11992.95565.report...@vanquo.pezone.net> > Installing a dictionary package, for example apt-get install > hunspell-de-de, ends up restarting all PostgreSQL servers on th

Bug#710558: closed by Christoph Berg (Bug#710558: fixed in pgpool2 3.3.0-1)

2013-08-15 Thread Christoph Berg
Re: Ernesto Hernández-Novich 2013-08-14 <1376489094.7.3.ca...@trillian.itverx.com.ve> > > >We've filed the bug upstream > > > > > >http://www.pgpool.net/mantisbt/view.php?id=60 > > > > > >We haven't tried newer versions of pgpool-II, as we must keep on > > >using pgpool-II 3.

Bug#723470: libzdb link with -L/usr/lib

2013-09-18 Thread Christoph Berg
Control: unmerge -1 Re: Jack Bates 2013-09-17 <5238b9b0.1080...@nottheoilrig.com> > Where is libpq.so (PostgreSQL client library) installed on your > system? I suspect the offending line is libzdb-2.11.3/configure.ac > line 268: > > LDFLAGS="-L`$PGCONFIG --libdir` $LDFLAGS" > > I think b

Bug#703645: packaging Postgres binary dump files

2013-09-20 Thread Christoph Berg
Re: Paul Wise 2013-09-20 > The format doesn't appear to be very efficient, the plain SQL commands > are much smaller: > > pabs@wagner:~$ pg_restore -l postbooks_empty-4.1.0.backup > foo.sql > pabs@wagner:~$ ls -Ssh > total 5.6M > 5.3M postbooks_empty-4.1.0.backup 344K foo.sql pg_restore -l wil

Bug#724573: postgresql: postgresql init could not create IPv4 socket. permission denied

2013-09-25 Thread Christoph Berg
Control: tags -1 moreinfo Re: John Proios 2013-09-25 <20130925054914.4143.77423.report...@hit-nxdomain.opendns.com> > 2013-09-25 08:46:13 EEST LOG: could not create IPv4 socket: permission denied > 2013-09-25 08:46:13 EEST WARNING: could not create listen socket for > "127.0.0.1" > 2013-09-25

Bug#724305: [Pkg-postgresql-public] PostgreSQL 9.1 support in jessie?

2013-09-25 Thread Christoph Berg
Re: Daniel Pocock 2013-09-25 <5242a851.1080...@pocock.com.au> > Apart from the procpid issue, are there likely to be many other painful > issues with migrating apps? standard_conforming_strings defaults to 'on' in 9.2+, just like the pg_stat_activity was already changed in 9.2. Given that 9.2 has

Bug#635163: Binaries in different location

2011-07-23 Thread Christoph Berg
Package: check-postgres Version: 2.16.0-1 Severity: serious The testing and unstable have their binaries in different locations. Prevent migration until this is resolved.

Bug#635701: smsd home should not be in /home

2011-07-28 Thread Christoph Berg
Package: smstools Version: 3.1.11-1 Please don't create system user homes in /home. Mit freundlichen Grüßen, Christoph Berg -- Dembach Goo Informatik GmbH & Co. KG Unter Sachsenhausen 33, D-50667 Köln Tel.: +49 2161 4643 187, Fax: +49 221 801483 20 E-Mail: c...@dg-i.net, Support-Hotl

Bug#635717: smsd should respect TMPDIR

2011-07-28 Thread Christoph Berg
ndlichen Grüßen, Christoph Berg -- Dembach Goo Informatik GmbH & Co. KG Unter Sachsenhausen 33, D-50667 Köln Tel.: +49 2161 4643 187, Fax: +49 221 801483 20 E-Mail: c...@dg-i.net, Support-Hotline: 0800 / 100 4323 Amtsgericht Köln HRA 22794, USt-IdNr.: DE242 159 527 Haftende Gesellscha

Bug#714423: "patch: **** /bin/ed FAILED" path changed to /usr/bin/ed, see #710865

2013-06-30 Thread Christoph Berg
clone 714423 -1 reassign -1 ed retitle -1 ed needs to Breaks: patch (<< 2.7.1-3~) Re: Joey Hess 2013-06-29 <20130629155017.ga13...@gnu.kitenet.net> > reassign 714423 patch > thanks > > Michael Schmitt wrote: > > running debmirror does fail recently, as /bin/ed got moved to /usr/bin/ed. > > Creati

Bug#714423: "patch: **** /bin/ed FAILED" path changed to /usr/bin/ed, see #710865

2013-06-30 Thread Christoph Berg
Re: Martin Zobel-Helas 2013-06-30 <20130630153600.go25...@ftbfs.de> > Please don't. According to FHS 'ed' must be in /bin, i will revert my recent > change. I'll tell patch to call "ed" instead of /some/path/ed anyway, it seems like a reasonable thing to do. Of course then there's no need to "bre

Bug#662006: postgresql-9.1: query "DELETE FROM table; " doesn't end and take 100% CPU, table contains 17 rows

2012-03-03 Thread Christoph Berg
Re: Pierre-Louis Bonicoli 2012-03-03 <20120303141004.12195.87516.reportbug@vala> > Table "public.taxinomie_taxref_rang" > Referenced by: > TABLE "taxinomie_taxref" CONSTRAINT "taxinomie_taxref_trf_rang_fkey" > FOREIGN KEY (trf_rang) REFERENCES t

Bug#663223: Connection is broken

2012-03-09 Thread Christoph Berg
Package: ike Version: 2.1.7+dfsg-1 Severity: grave As reported in https://bugs.launchpad.net/ubuntu/+source/ike/+bug/860208, the shrewsoft client cannot connect anymore. Downgrading to 2.1.5 fixed it here. Comment #13 on the LP bug suggests the culprit is 0004_select.diff. -- System Information

Bug#596377: gpg-key2ps failure with latin1 chars (fwd)

2011-11-01 Thread Christoph Berg
- Forwarded message from Alvaro Herrera - Date: Sat, 29 Oct 2011 16:55:42 -0300 From: Alvaro Herrera To: Christoph Berg Cc: Thijs Kinkhorst Subject: gpg-key2ps failure with latin1 chars Hi Christoph, Thijs, Thanks for maintaining gpg-key2ps. I'm using it now to generate

<    1   2   3   4   5   6   7   8   9   10   >