postgresql-7.4: unable to install

[Debian Bug Importer]

Automatically imported from Debian bug report #340459 http://bugs.debian.org/340459

[Anand Kumria (wildfire)]

On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
> Package: postgresql-7.4
> Version: 1:7.4.9-2
> Severity: grave
> Justification: renders package unusable
>
> I could not install postgresql-7.4 :
>
> ===
> jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
> Setting up postgresql-7.4 (7.4.9-2) ...
> Error: clusters must not be owned by root
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Could you explain how that happened?

Thanks,
Anand

--
 `When any government, or any church for that matter, undertakes to say to
  its subjects, "This you may not read, this you must not see, this you are
  forbidden to know," the end result is tyranny and oppression no matter how
  holy the motives' -- Robert A Heinlein, "If this goes on --"

[Jonathan Ballet (multani)]

Anand Kumria a écrit :
> On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
>
>>Package: postgresql-7.4
>>Version: 1:7.4.9-2
>>Severity: grave
>>Justification: renders package unusable
>>
>>I could not install postgresql-7.4 :
>>
>>===
>>jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
>>Setting up postgresql-7.4 (7.4.9-2) ...
>>Error: clusters must not be owned by root
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Could you explain how that happened?
>
> Thanks,
> Anand
>

Unfortunely, I don't know ...
What are these clusters is it talking about ?

Jonathan

[Debian Bug Importer (debzilla)]

Automatically imported from Debian bug report #340459 http://bugs.debian.org/340459

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Wed, 23 Nov 2005 16:32:26 +0100
From: Jonathan Ballet <email address hidden>
To: Debian Bug Tracking System <email address hidden>
Subject: postgresql-7.4: unable to install

Package: postgresql-7.4
Version: 1:7.4.9-2
Severity: grave
Justification: renders package unusable

I could not install postgresql-7.4 :

===
jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Building tag database... Done
The following NEW packages will be installed:
  postgresql-7.4
0 packages upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 3193kB of archives. After unpacking 8049kB will be used.
Writing extended state information... Done
Get:1 http://ftp.fr.debian.org unstable/main postgresql-7.4 1:7.4.9-2
[3193kB]
Fetched 3193kB in 4s (699kB/s)
Reading package fields... Done
Reading package status... Done
Retrieving bug reports... Done
Selecting previously deselected package postgresql-7.4.
(Reading database ... 189203 files and directories currently installed.)
Unpacking postgresql-7.4 (from .../postgresql-7.4_1%3a7.4.9-2_i386.deb)
...
Setting up postgresql-7.4 (7.4.9-2) ...
Error: clusters must not be owned by root
dpkg: error processing postgresql-7.4 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-7.4
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up postgresql-7.4 (7.4.9-2) ...
Error: clusters must not be owned by root
dpkg: error processing postgresql-7.4 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-7.4
jon-debian:/home/jon#
===

Others postgresql packages are ok to install (-common and -client-7.4)

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-k7
Locale: LANG=fr_FR@euro, LC_CTYPE=fr_FR@euro (charmap=ISO-8859-15)

Versions of packages postgresql-7.4 depends on:
ii libc6 2.3.5-8 GNU C Library: Shared libraries an
ii libcomerr2 1.38-2 common error description library
ii libkrb53 1.3.6-5 MIT Kerberos runtime libraries
ii libpam0g 0.79-3 Pluggable Authentication Modules l
ii libpq3 1:7.4.9-2 PostgreSQL C client library
ii libreadline5 5.0-11 GNU readline and history libraries
ii libssl0.9.8 0.9.8a-4 SSL shared libraries
ii postgresql-client-7.4 1:7.4.9-2 front-end programs for PostgreSQL
ii postgresql-common 34 manager for PostgreSQL database cl
ii zlib1g 1:1.2.3-8 compression library - runtime

postgresql-7.4 recommends no packages.

-- no debconf information

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Thu, 24 Nov 2005 02:43:09 +1100
From: Anand Kumria <email address hidden>
To: Jonathan Ballet <email address hidden>, <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

--yHmUJ2Jgby4Rx//r
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
> Package: postgresql-7.4
> Version: 1:7.4.9-2
> Severity: grave
> Justification: renders package unusable
>=20
> I could not install postgresql-7.4 :
>=20
> =3D=3D=3D
> jon-debian:/home/jon# LANGUAGE=3Den aptitude install postgresql-7.4
> Setting up postgresql-7.4 (7.4.9-2) ...
> Error: clusters must not be owned by root
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Could you explain how that happened?=20

Thanks,
Anand

--=20
 `When any government, or any church for that matter, undertakes to say to
  its subjects, "This you may not read, this you must not see, this you are
  forbidden to know," the end result is tyranny and oppression no matter how
  holy the motives' -- Robert A Heinlein, "If this goes on --"

--yHmUJ2Jgby4Rx//r
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iQCVAwUBQ4SODGRmcAD8BdppAQItxwQAgpLz3TSYJRt9ftkD5KUmjafz/ENrybT6
YmSfFPQN+ff8MzQ8CpThEak96N5wc9SQEgZ4LB0rXgTMTdOFDnd9Qatsoan8nMfq
0Ja4iRGmBURxOFk0m0jZswQNJi7Gfakelcjdua9EVMqnntM+AgIZPNZjDHvwlATK
/W1WMiP1LSU=
=kUsu
-----END PGP SIGNATURE-----

--yHmUJ2Jgby4Rx//r--

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Wed, 23 Nov 2005 17:00:20 +0100
From: Jonathan Ballet <email address hidden>
To: Anand Kumria <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

Anand Kumria a =E9crit :
> On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
>=20
>>Package: postgresql-7.4
>>Version: 1:7.4.9-2
>>Severity: grave
>>Justification: renders package unusable
>>
>>I could not install postgresql-7.4 :
>>
>>=3D=3D=3D
>>jon-debian:/home/jon# LANGUAGE=3Den aptitude install postgresql-7.4
>>Setting up postgresql-7.4 (7.4.9-2) ...
>>Error: clusters must not be owned by root
>=20
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>=20
> Could you explain how that happened?=20
>=20
> Thanks,
> Anand
>=20

Unfortunely, I don't know ...
What are these clusters is it talking about ?

Jonathan

[Martin Pitt (pitti)]

# Automatically generated email from bts, devscripts version 2.8.14
reassign 340459 postgresql-common

[Martin Pitt (pitti)]

Hi Jonathan!

Jonathan Ballet [2005-11-23 17:00 +0100]:
> >>Error: clusters must not be owned by root
> >
> > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >
> > Could you explain how that happened?
> >
> > Thanks,
> > Anand
> >
>
> Unfortunely, I don't know ...
> What are these clusters is it talking about ?

A cluster is a set of databases that are managed by one server
(postmater). You can have several of them installed.

--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

[Martin Pitt (pitti)]

Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
> Error: clusters must not be owned by root
> dpkg: error processing postgresql-7.4 (--configure):
> subprocess post-installation script returned error exit status 1
> Errors were encountered while processing:
> postgresql-7.4

There seems to be something wrong with your 'postgres' user. What is
the output of

  id postgres

?

Martin
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Thu, 24 Nov 2005 19:28:59 +0100
From: Martin Pitt <email address hidden>
To: Jonathan Ballet <email address hidden>, <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

Hi Jonathan!

Jonathan Ballet [2005-11-23 17:00 +0100]:
> >>Error: clusters must not be owned by root
> >
> > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >
> > Could you explain how that happened?
> >
> > Thanks,
> > Anand
> >
>
> Unfortunely, I don't know ...
> What are these clusters is it talking about ?

A cluster is a set of databases that are managed by one server
(postmater). You can have several of them installed.

--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

[Debian Bug Importer (debzilla)]

Message-Id: <email address hidden>
Date: Thu, 24 Nov 2005 19:27:02 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: reassign 340459 to postgresql-common

# Automatically generated email from bts, devscripts version 2.8.14
reassign 340459 postgresql-common

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Thu, 24 Nov 2005 19:32:53 +0100
From: Martin Pitt <email address hidden>
To: Jonathan Ballet <email address hidden>, <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

--D6z0c4W1rkZNF4Vu
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
> Error: clusters must not be owned by root
> dpkg: error processing postgresql-7.4 (--configure):
> subprocess post-installation script returned error exit status 1
> Errors were encountered while processing:
> postgresql-7.4

There seems to be something wrong with your 'postgres' user. What is
the output of

  id postgres
 =20
?

Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

--D6z0c4W1rkZNF4Vu
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDhgdVDecnbV4Fd/IRAmV4AJkBGVxTSwUREyqwmImS+lR6ybCnygCglz0M
nvmx2XQN/VA/elnLNUFd6kw=
=gKYj
-----END PGP SIGNATURE-----

--D6z0c4W1rkZNF4Vu--

[Martin Pitt (pitti)]

# Automatically generated email from bts, devscripts version 2.9.8
tags 340459 unreproducible moreinfo

[Debian Bug Importer (debzilla)]

Message-Id: <email address hidden>
Date: Fri, 2 Dec 2005 18:18:00 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: tagging 340459

# Automatically generated email from bts, devscripts version 2.9.8
tags 340459 unreproducible moreinfo

[Martin Pitt (pitti)]

severity 340459 normal
retitle 340459 postgresql-common: unspecified problem with postgres user
thanks

Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
> Error: clusters must not be owned by root
> dpkg: error processing postgresql-7.4 (--configure):
> subprocess post-installation script returned error exit status 1

I still need the output of 'id postgresql', as I asked in my previous
reply.

Thanks,

Martin
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Sun, 4 Dec 2005 14:17:59 +0100
From: Martin Pitt <email address hidden>
To: Jonathan Ballet <email address hidden>, <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

--ew6BAiZeqk4r7MaW
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

severity 340459 normal
retitle 340459 postgresql-common: unspecified problem with postgres user
thanks

Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
> Error: clusters must not be owned by root
> dpkg: error processing postgresql-7.4 (--configure):
> subprocess post-installation script returned error exit status 1

I still need the output of 'id postgresql', as I asked in my previous
reply.

Thanks,

Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

--ew6BAiZeqk4r7MaW
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDkuyHDecnbV4Fd/IRAk5lAKD4T8kdKK/ICb2kIxrtlnaS7P1BmACeKPln
tJy4yO8hux2pu8/uuJEaaIE=
=1sdh
-----END PGP SIGNATURE-----

--ew6BAiZeqk4r7MaW--

[Jonathan Ballet (multani)]

Martin Pitt a écrit :
> severity 340459 normal
> retitle 340459 postgresql-common: unspecified problem with postgres user
> thanks
>
> Hi Jonathan!
>
> Jonathan Ballet [2005-11-23 16:32 +0100]:
>
>>Error: clusters must not be owned by root
>>dpkg: error processing postgresql-7.4 (--configure):
>> subprocess post-installation script returned error exit status 1
>
>
> I still need the output of 'id postgresql', as I asked in my previous
> reply.
>
> Thanks,
>
> Martin

Hi Martin,
Sorry for late reply. Here is the output of 'id postgresql' :

jon@jon-debian:~$ id postgres
uid=12966(postgres) gid=0(root) groupes=0(root)
jon@jon-debian:~$

I hope it can help ...

Thanks,
Jonathan

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Mon, 05 Dec 2005 09:46:18 +0100
From: Jonathan Ballet <email address hidden>
To: Martin Pitt <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

Martin Pitt a =E9crit :
> severity 340459 normal
> retitle 340459 postgresql-common: unspecified problem with postgres use=
r
> thanks
>=20
> Hi Jonathan!
>=20
> Jonathan Ballet [2005-11-23 16:32 +0100]:
>=20
>>Error: clusters must not be owned by root
>>dpkg: error processing postgresql-7.4 (--configure):
>> subprocess post-installation script returned error exit status 1
>=20
>=20
> I still need the output of 'id postgresql', as I asked in my previous
> reply.
>=20
> Thanks,
>=20
> Martin

Hi Martin,
Sorry for late reply. Here is the output of 'id postgresql' :

jon@jon-debian:~$ id postgres
uid=3D12966(postgres) gid=3D0(root) groupes=3D0(root)
jon@jon-debian:~$

I hope it can help ...

Thanks,
Jonathan

[Martin Pitt (pitti)]

Hi Jonathan!

Jonathan Ballet [2005-12-05 9:46 +0100]:
> Sorry for late reply. Here is the output of 'id postgresql' :
>
> jon@jon-debian:~$ id postgres
> uid=12966(postgres) gid=0(root) groupes=0(root)
> jon@jon-debian:~$
>
> I hope it can help ...

It indeed does. It should actually look like

  uid=116(postgres) gid=116(postgres) Gruppen=116(postgres)

i. e. there are several things wrong about your user:

  * The user ID should be smaller than 1000 to make postgres a system
    user.
  * postgres should have its own system group instead of being in
    group 'root'. This is the cause for your failure.

Since I do not believe that adduser --system created this user, I
strongly suspect that it existed before installing postgresql-common
already. It does not look like a regular user either, though - they
must not be in group 'root'.

Thus, a quickfix for you would be to do

  deluser postgres

and reinstall postgresql-common and postgresql-7.4. However, please
make double sure that you don't need that user for anything else.

I can add a check to the postgresql-common package that will make the
installation fail with a meaningful message if an invalid postgres
user already exists. However, there is not much more I could do about
that.

Thanks,

Martin

--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Mon, 5 Dec 2005 14:21:25 +0100
From: Martin Pitt <email address hidden>
To: Jonathan Ballet <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

--eqp4TxRxnD4KrmFZ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Jonathan!

Jonathan Ballet [2005-12-05 9:46 +0100]:
> Sorry for late reply. Here is the output of 'id postgresql' :
>=20
> jon@jon-debian:~$ id postgres
> uid=3D12966(postgres) gid=3D0(root) groupes=3D0(root)
> jon@jon-debian:~$
>=20
> I hope it can help ...

It indeed does. It should actually look like

  uid=3D116(postgres) gid=3D116(postgres) Gruppen=3D116(postgres)

i. e. there are several things wrong about your user:

  * The user ID should be smaller than 1000 to make postgres a system
    user.
  * postgres should have its own system group instead of being in
    group 'root'. This is the cause for your failure.

Since I do not believe that adduser --system created this user, I
strongly suspect that it existed before installing postgresql-common
already. It does not look like a regular user either, though - they
must not be in group 'root'.=20

Thus, a quickfix for you would be to do

  deluser postgres

and reinstall postgresql-common and postgresql-7.4. However, please
make double sure that you don't need that user for anything else.

I can add a check to the postgresql-common package that will make the
installation fail with a meaningful message if an invalid postgres
user already exists. However, there is not much more I could do about
that.

Thanks,

Martin

--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

--eqp4TxRxnD4KrmFZ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDlD7VDecnbV4Fd/IRAguLAKD42y609V2JMaNCnGlkIptyKALFOQCdEIIs
pcLzjtUvdREUYmKHL7lWBcE=
=ZWNm
-----END PGP SIGNATURE-----

--eqp4TxRxnD4KrmFZ--

[Jonathan Ballet (multani)]

Hi Martin,

So I have deleted the postgres user : (sorry, french output ;) )

jon-debian:/# deluser postgres
Suppression de l'utilisateur « postgres »...
userdel : erreur lors de la suppression de l'entrée dans /etc/shadow
Fait.
jon-debian:/#

It says that there is an error while deleting the user entry from /etc/shadow ...
I don't know where this user came from, but it seems there's something special about it ...

Now :
jon-debian:/# id postgres
uid=116(postgres) gid=116(postgres) groupes=116(postgres)
jon-debian:/#

So everythings looks Ok. I try to purge postgresql-7.4 packages and reinstall them, and it seems OK.
Anyway, I think you can close this bug report now, since it was a problem on my side ...

Thanks a lot,
Jonathan

Martin Pitt a écrit :
> Hi Jonathan!
>
> Jonathan Ballet [2005-12-05 9:46 +0100]:
>
>>Sorry for late reply. Here is the output of 'id postgresql' :
>>
>>jon@jon-debian:~$ id postgres
>>uid=12966(postgres) gid=0(root) groupes=0(root)
>>jon@jon-debian:~$
>>
>>I hope it can help ...
>
>
> It indeed does. It should actually look like
>
> uid=116(postgres) gid=116(postgres) Gruppen=116(postgres)
>
> i. e. there are several things wrong about your user:
>
> * The user ID should be smaller than 1000 to make postgres a system
> user.
> * postgres should have its own system group instead of being in
> group 'root'. This is the cause for your failure.
>
> Since I do not believe that adduser --system created this user, I
> strongly suspect that it existed before installing postgresql-common
> already. It does not look like a regular user either, though - they
> must not be in group 'root'.
>
> Thus, a quickfix for you would be to do
>
> deluser postgres
>
> and reinstall postgresql-common and postgresql-7.4. However, please
> make double sure that you don't need that user for anything else.
>
> I can add a check to the postgresql-common package that will make the
> installation fail with a meaningful message if an invalid postgres
> user already exists. However, there is not much more I could do about
> that.
>
> Thanks,
>
> Martin
>

[Debian Bug Importer (debzilla)]

Message-ID: <email address hidden>
Date: Tue, 06 Dec 2005 09:53:28 +0100
From: Jonathan Ballet <email address hidden>
To: Martin Pitt <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#340459: postgresql-7.4: unable to install

Hi Martin,

So I have deleted the postgres user : (sorry, french output ;) )

jon-debian:/# deluser postgres
Suppression de l'utilisateur =AB postgres =BB...
userdel : erreur lors de la suppression de l'entr=E9e dans /etc/shadow
Fait.
jon-debian:/#

It says that there is an error while deleting the user entry from /etc/sh=
adow ...
I don't know where this user came from, but it seems there's something sp=
ecial about it ...

Now :
jon-debian:/# id postgres
uid=3D116(postgres) gid=3D116(postgres) groupes=3D116(postgres)
jon-debian:/#

So everythings looks Ok. I try to purge postgresql-7.4 packages and reins=
tall them, and it seems OK.
Anyway, I think you can close this bug report now, since it was a problem=
 on my side ...

Thanks a lot,
Jonathan

Martin Pitt a =E9crit :
> Hi Jonathan!
>=20
> Jonathan Ballet [2005-12-05 9:46 +0100]:
>=20
>>Sorry for late reply. Here is the output of 'id postgresql' :
>>
>>jon@jon-debian:~$ id postgres
>>uid=3D12966(postgres) gid=3D0(root) groupes=3D0(root)
>>jon@jon-debian:~$
>>
>>I hope it can help ...
>=20
>=20
> It indeed does. It should actually look like
>=20
> uid=3D116(postgres) gid=3D116(postgres) Gruppen=3D116(postgres)
>=20
> i. e. there are several things wrong about your user:
>=20
> * The user ID should be smaller than 1000 to make postgres a system
> user.
> * postgres should have its own system group instead of being in
> group 'root'. This is the cause for your failure.
>=20
> Since I do not believe that adduser --system created this user, I
> strongly suspect that it existed before installing postgresql-common
> already. It does not look like a regular user either, though - they
> must not be in group 'root'.=20
>=20
> Thus, a quickfix for you would be to do
>=20
> deluser postgres
>=20
> and reinstall postgresql-common and postgresql-7.4. However, please
> make double sure that you don't need that user for anything else.
>=20
> I can add a check to the postgresql-common package that will make the
> installation fail with a meaningful message if an invalid postgres
> user already exists. However, there is not much more I could do about
> that.
>=20
> Thanks,
>=20
> Martin
>=20

[Martin Pitt (pitti)]

(In reply to comment #11)

> Anyway, I think you can close this bug report now, since it was a problem=
> on my side ...

Closing in Ubuntu; I'll keep this open in Debian and add a better check for this
case to postgresql-common.

[Martin Pitt (pitti)]

# Automatically generated email from bts, devscripts version 2.9.9
tags 340459 pending

[Debian Bug Importer (debzilla)]

Message-Id: <email address hidden>
Date: Tue, 6 Dec 2005 20:35:16 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: tagging 340459

# Automatically generated email from bts, devscripts version 2.9.9
tags 340459 pending

[Martin Pitt (pitti)]

Source: postgresql-common
Source-Version: 37

We believe that the bug you reported is fixed in the latest version of
postgresql-common, which is due to be installed in the Debian FTP archive:

postgresql-common_37.dsc
  to pool/main/p/postgresql-common/postgresql-common_37.dsc
postgresql-common_37.tar.gz
  to pool/main/p/postgresql-common/postgresql-common_37.tar.gz
postgresql-common_37_all.deb
  to pool/main/p/postgresql-common/postgresql-common_37_all.deb

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to <email address hidden>,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <email address hidden> (supplier of updated postgresql-common package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing <email address hidden>)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sat, 10 Dec 2005 23:36:41 +0100
Source: postgresql-common
Binary: postgresql-common
Architecture: source all
Version: 37
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <email address hidden>
Changed-By: Martin Pitt <email address hidden>
Description:
 postgresql-common - manager for PostgreSQL database clusters
Closes: 338031 340200 340459 341141 341267 341951
Changes:
 postgresql-common (37) unstable; urgency=low
 .
   * debian/postgresql-common.config: Only show the obsolete version warning
     once.
   * Add French debconf translations, thanks to Guilhelm Panaget.
     Closes: #340200, #341267
   * debian/postgresql-common.postinst: Change default permissions of the
     private SSL key to root:postgres 0640 to prevent potential modification of
     the certificate by the postmaster. Closes: #341141
   * Add Czech debconf translations, thanks to Miroslav Kure. Closes: #341951
   * debian/postgresql-common.postinst: Check that the postgres user/group is
     not root; fail installation with a meaningful error message if it is.
     Closes: #340459
   * t/040_upgrade.t: Check upgrading of sequence and stored PL/PgSQL
     procedure.
   * pg_upgradecluster: Change hardcoded and obsolete library paths to
     '$libdir' in the new cluster. This fixes upgrades of 7.4 clusters that
     were upgraded from woody. Closes: #338031
Files:
 e1ae7a3f0be711b6081a5c1ea304ffa1 578 misc optional postgresql-common_37.dsc
 8502f94fdabaad0677d108aae3d2247e 61578 misc optional postgresql-common_37.tar.gz
 9b74feff37de81b46362d2e2d9d32b55 82454 misc optional postgresql-common_37_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDnAGaDecnbV4Fd/IRAhBoAKDcRt8PyVUkaRgpmIrumCkS64QbvQCg00oV
36XO7LjEGt6qI9xkgCe0930=
=EWFI
-----END PGP SIGNATURE-----

[Debian Bug Importer (debzilla)]

Message-Id: <email address hidden>
Date: Sun, 11 Dec 2005 02:47:06 -0800
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: Bug#340459: fixed in postgresql-common 37

Source: postgresql-common
Source-Version: 37

We believe that the bug you reported is fixed in the latest version of
postgresql-common, which is due to be installed in the Debian FTP archive:

postgresql-common_37.dsc
  to pool/main/p/postgresql-common/postgresql-common_37.dsc
postgresql-common_37.tar.gz
  to pool/main/p/postgresql-common/postgresql-common_37.tar.gz
postgresql-common_37_all.deb
  to pool/main/p/postgresql-common/postgresql-common_37_all.deb

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to <email address hidden>,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <email address hidden> (supplier of updated postgresql-common package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing <email address hidden>)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sat, 10 Dec 2005 23:36:41 +0100
Source: postgresql-common
Binary: postgresql-common
Architecture: source all
Version: 37
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <email address hidden>
Changed-By: Martin Pitt <email address hidden>
Description:
 postgresql-common - manager for PostgreSQL database clusters
Closes: 338031 340200 340459 341141 341267 341951
Changes:
 postgresql-common (37) unstable; urgency=low
 .
   * debian/postgresql-common.config: Only show the obsolete version warning
     once.
   * Add French debconf translations, thanks to Guilhelm Panaget.
     Closes: #340200, #341267
   * debian/postgresql-common.postinst: Change default permissions of the
     private SSL key to root:postgres 0640 to prevent potential modification of
     the certificate by the postmaster. Closes: #341141
   * Add Czech debconf translations, thanks to Miroslav Kure. Closes: #341951
   * debian/postgresql-common.postinst: Check that the postgres user/group is
     not root; fail installation with a meaningful error message if it is.
     Closes: #340459
   * t/040_upgrade.t: Check upgrading of sequence and stored PL/PgSQL
     procedure.
   * pg_upgradecluster: Change hardcoded and obsolete library paths to
     '$libdir' in the new cluster. This fixes upgrades of 7.4 clusters that
     were upgraded from woody. Closes: #338031
Files:
 e1ae7a3f0be711b6081a5c1ea304ffa1 578 misc optional postgresql-common_37.dsc
 8502f94fdabaad0677d108aae3d2247e 61578 misc optional postgresql-common_37.tar.gz
 9b74feff37de81b46362d2e2d9d32b55 82454 misc optional postgresql-common_37_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDnAGaDecnbV4Fd/IRAhBoAKDcRt8PyVUkaRgpmIrumCkS64QbvQCg00oV
36XO7LjEGt6qI9xkgCe0930=
=EWFI
-----END PGP SIGNATURE-----