Your message dated Thu, 16 Aug 2012 12:40:09 +0200 with message-id <[email protected]> and subject line Re: Bug#569088: pg_upgradecluster problem with 7.4 postgresql.conf has caused the Debian Bug report #569088, regarding pg_upgradecluster problem with 7.4 postgresql.conf 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 this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 569088: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=569088 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: postgresql-8.3 Version: 8.3.9-0lenny1 Severity: minor Hi, Recently I decided to finally upgrade my etch postgresql 7.4 database to lenny's 8.3. pg_upgradecluster almost did the job, I only got one minor problem: In 7.4's postgresql.conf I had: virtual_host = 'localhost dmz-internal-host-name' This line was updated to 8.3's: listen_addresses = 'localhost dmz-internal-host-name' and postgresql 8.3 failed to start. It turned out that listen_addresses option takes comma separated list of host names. Changing space to comma fixed my problem and database started succesfully. Btw, thanks for great administration infrastructure - I was afraid that upgrade will be painfull, but all those pg_{create,drop,upgrade}cluster are very useful and upgrade hints (postgresql-common) made it a breeze. Regards, Michal Pokrywka
--- End Message ---
--- Begin Message ---Hello Michal, Michal Pokrywka [2010-02-10 0:49 +0100]: > Recently I decided to finally upgrade my etch postgresql 7.4 database > to lenny's 8.3. pg_upgradecluster almost did the job, I only got one > minor problem: > > In 7.4's postgresql.conf I had: > virtual_host = 'localhost dmz-internal-host-name' > > This line was updated to 8.3's: > listen_addresses = 'localhost dmz-internal-host-name' > and postgresql 8.3 failed to start. It turned out that listen_addresses > option takes comma separated list of host names. Changing space to > comma fixed my problem and database started succesfully. Sorry that I didn't get to this earlier. This is rather moot now, as the oldest supported Debian release (Squeeze) has 8.4, which already uses listen_addresses. So there is little point changing pg_upgradecluster for this now. Thus I'm closing this report now, but thanks for sending it! Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
--- End Message ---

