[Pkg-postgresql-public] Bug#710093: postgresql: not started automatically after installation in chroot

Christoph Berg myon at debian.org
Sat Jun 1 03:18:07 UTC 2013


Re: Andreas Beckmann 2013-05-31 <51A8FEAC.5090902 at 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, all defaults. No clue if the services
> are working, but their package installation passes (and usually fails if
> the db server is not available). :-)

Heh.

> > Can you check /var/log/postgresql/ if there's any error messages for
> > the first startup?
> 
> there is only an empty /var/log/postgresql/postgresql-9.1-main.log
> 
> I can reproduce this manually with pbuilder in the minimal chroot
> created by piuparts. But not in my regular pbuilder chroot. (postgresql
> is running there if permitted by policy-rc.d).

Btw, can you share this policy-rc.d?

> I can "fix" this in the piuparts chroot if I install devscripts first
> and postgresql afterwards - now the daemon is running.

I'd bet this is a bug in the chroot, like no localhost interface, or
failure to resolve "localhost". Or the 5432 is not available, but that
should be a different error message.

(Fwiw, I disagree with this bug being serious, as it apparently
doesn't affect anyone but piuparts.)

> PS: I noticed that pg uses ports 5433, 5434, ... if 5432 is not
> available during installation - is there a way (preferrably via
> preseeding) that forces it to use 5432 (as that is expected by many
> other packages) and just fail if that is not available?

For postgresql-common >= 142, you could try "port = 5432" in
/etc/postgresql-common/createcluster.conf, that should work. Or just
don't create a default cluster and use "pg_createcluster -p 5432".

Why is that port unavailable there anyway? Shouldn't that be a clean
testbed for the upgrade tests? (On the same ticket I don't really see
the need for preseeding here, 5432 should not be used by anyone else
at installation time.)

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/



More information about the Pkg-postgresql-public mailing list