# 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)
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) ... /8.1/main, data: /var/lib/ postgresql/ 8.1/main) ... postgresql/ 8.1/main/ pg_hba. conf to /etc/postgresql /8.1/main. .. postgresql/ 8.1/main/ pg_ident. conf to /etc/postgresql /8.1/main. .. postgresql/ 8.1/main/ postgresql. conf to /etc/postgresql /8.1/main. ..
Creating new cluster (configuration: /etc/postgresql
Moving configuration file /var/lib/
Moving configuration file /var/lib/
Moving configuration file /var/lib/
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)