useradd error while installing postgresql-common

[mf]

fresh install of RC3, almost no packages installed (i just remember installing xterm)

apt-get install apache2-mpm-prefork libapache2-mod-php5 php5-pgsql postgresql-8.1 libpq-dev

just the important parts of the output:

Setting up ssl-cert (1.0.13) ...
UX: groupadd: ssl-cert name should be all lower case or numeric.

Setting up postgresql-common (53nexenta5) ...
UX: /usr/sbin/useradd: ERROR: Inconsistent password files. See pwconv(1M).
adduser: `/usr/sbin/useradd -d /var/lib/postgresql -g postgres -s /bin/bash -u 103 postgres' returned error code 5. Aborting.

Note: the original reporter indicated the bug was in package 'postgresql-common'; however, that package was not published in Nexenta Operating System.

[mf (mf-rola)]

i ran the following two commands:

# pwconv
# /usr/sbin/useradd -d /var/lib/postgresql -g postgres -s /bin/bash -u 103 postgres

now i got a step further with postgresql:

# apt install postgresql-8.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
postgresql-8.1 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Need to get 0B of archives.
After unpacking 0B of additional disk space will be used.
Setting up postgresql-common (53nexenta5) ...
Adding user `postgres' to group `ssl-cert'...
Done.

Setting up postgresql-8.1 (8.1.4-0nexenta2) ...
Creating new cluster (configuration: /etc/postgresql/8.1/main, data: /var/lib/postgresql/8.1/main)...
Moving configuration file /var/lib/postgresql/8.1/main/pg_hba.conf to /etc/postgresql/8.1/main...
Moving configuration file /var/lib/postgresql/8.1/main/pg_ident.conf to /etc/postgresql/8.1/main...
Moving configuration file /var/lib/postgresql/8.1/main/postgresql.conf to /etc/postgresql/8.1/main...
Configuring postgresql.conf to use port 5432...
Starting PostgreSQL 8.1 database server: main* The PostgreSQL server failed to start. Please check the log output:
LOG: could not load root certificate file "root.crt": No SSL error reported
DETAIL: Will not verify client certificates.
LOG: database system was shut down at 2008-01-28 23:40:55 CET
LOG: checkpoint record is at 0/33F248
LOG: redo record is at 0/33F248; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 565; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
LOG: incomplete startup packet
LOG: Ident authentication is not supported on local connections on this platform
FATAL: Ident authentication failed for user "postgres"
... 9 more of the previous two lines ...
LOG: Ident authentication is not supported on local connections on this platform
FATAL: Ident authentication failed for user "postgres"
 failed!
invoke-rc.d: initscript postgresql-8.1, action "start" failed.
dpkg: error processing postgresql-8.1 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-8.1
E: Sub-process /usr/bin/dpkg returned an error code (1)

[djinn (supreet-sethi+launchpad)]

Finding same error with postgresql-common. Could installer run pwconv during installation.

[Erast (erast)]

This been fixed, however, default auth method needs to be changed from 'ident' (not supported) to something else.

[anilg (anil-verve)]

Erast, this same error also occurs with the recent packages (when installing into the devzone). Is the fix to add pwconv to the postinst script?

[anilg (anil-verve)]

For the ident issue after installation you can change the method of authentication.. for ex:

in /etc/postgresql/8.3/main/pg_hba.conf .. the last section can be changed to:
------------------------------------------------------
local all postgres trust

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5