#3497 Ubuntu: pgsqlsetup -i -V couldn't connect with database

[ting ting li]

root@dx360m3n01:/install/ubuntu12.04.1# pgsqlsetup -i -V
Running command on dx360m3n01: dpkg -l | grep libdbd-pg-perl 2>&1

Running command on dx360m3n01: dpkg -l | grep postgresql | awk '{print $2}' 2>&1

Running command on dx360m3n01: ps -ef | grep postgres 2>&1

Running command on dx360m3n01: fgrep Pg /etc/xcat/cfgloc 2>&1

Input the password for xcatadm id:
Backing up xCAT Database to /root/xcat-dbback.
This could take several minutes.
Running command on dx360m3n01: rm -f /root/xcat-dbback/* 2>&1

Running command on dx360m3n01: XCATBYPASS=1 dumpxCATdb -p /root/xcat-dbback 2>&1

Shutting down the xcatd daemon during database migration.
Stopping xCATd *
Running command on dx360m3n01: grep master /root/xcat-dbback/site.csv 2>&1

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.
The default database encoding has accordingly been set to LATIN1.
The default text search configuration will be set to "english".

initdb: directory "/var/lib/postgresql/9.1/main" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/lib/postgresql/9.1/main" or run initdb
with an argument other than "/var/lib/postgresql/9.1/main".
Running command on dx360m3n01: fgrep 9.114.34.231 /etc/postgresql/9.1/main/pg_hba.conf 2>&1

Running command on dx360m3n01: cp /etc/postgresql/9.1/main/pg_hba.conf /etc/postgresql/9.1/main/pg_hba.conf.org 2>&1

Running command on dx360m3n01: awk '{gsub("IPv4 local connections:","IPv4 local connections:\nhost all all 9.114.34.231/32 md5 "); print}' /etc/postgresql/9.1/main/pg_hba.conf > /etc/postgresql/9.1/main/pg_hba.conf.xcat 2>&1

Running command on dx360m3n01: cp -p /etc/postgresql/9.1/main/pg_hba.conf.xcat /etc/postgresql/9.1/main/pg_hba.conf 2>&1

Running command on dx360m3n01: rm /etc/postgresql/9.1/main/pg_hba.conf.xcat 2>&1

Running command on dx360m3n01: fgrep "setup by xCAT" /etc/postgresql/9.1/main/postgresql.conf 2>&1

Running command on dx360m3n01: chown postgres /var/lib/postgresql/9.1/main/* 2>&1

Running command on dx360m3n01: chgrp postgres /var/lib/postgresql/9.1/main/* 2>&1

Running command on dx360m3n01: update-rc.d postgresql defaults 2>&1

Running command on dx360m3n01: mv /etc/xcat/cfgloc /etc/xcat/cfgloc.xcat.backup 2>&1

Restoring the xCat Database with /root/xcat-dbback to PostgreSQL database.
This could take several minutes.
Command failed: XCATBYPASS=1 XCATCFG="Pg:dbname=xcatdb;host=9.114.34.231|xcatadm|cluster" restorexCATdb -p /root/xcat-dbback 2>&1. Error message: DBI connect('dbname=xcatdb;host=9.114.34.231','xcatadm',...) failed: could not connect to server: Connection refused
Is the server running on host "9.114.34.231" and accepting
TCP/IP connections on port 5432? at /opt/xcat/lib/perl/xCAT/Table.pm line 790
Could not read the site table

Can't call method "close" on an undefined value at /opt/xcat/lib/perl/xCAT/TableUtils.pm line 1018.
Could not connect to the database. Database handle not defined..

[xu qing]

The postgres service running status is wrong, change the if statement.

[Lissa Valletta]

Ting ting is this really fixed. Please reopen and assign to 2.9 if not please close