xi restore fail

[benhank]

Restoring PostgresQL databases...
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

do you guys know what this is?

[slansing]

Can you run the following:

Code: Select all

service postgresql restart

And post what the command line outputes.

And post the output from:

Code: Select all

umask

[benhank]

[root@Lkennagiosp02 ~]# service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
[root@Lkennagiosp02 ~]# umask
0022
[root@Lkennagiosp02 ~]#

[scottwilkerson]

Was this a new install of XI you are restoring to?

can you run the following and show the output

Code: Select all

echo "\d"|psql nagiosxi nagiosxi

[benhank]

sure... but the system seems to have "kicked off".

[root@Lkennagiosp02 nagiosxi]# echo "\d"|psql nagiosxi nagiosxi
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+----------+----------
public | if_command_id_seq | sequence | nagiosxi
public | if_meta_id_seq | sequence | nagiosxi
public | if_option_id_seq | sequence | nagiosxi
public | if_sysstat_id_seq | sequence | nagiosxi
public | if_user_id_seq | sequence | nagiosxi
public | if_usermeta_id_seq | sequence | nagiosxi
public | xi_auditlog | table | nagiosxi
public | xi_auditlog_auditlog_id_seq | sequence | nagiosxi
public | xi_commands | table | nagiosxi
public | xi_commands_command_id_seq | sequence | nagiosxi
public | xi_events | table | nagiosxi
public | xi_events_event_id_seq | sequence | nagiosxi
public | xi_meta | table | nagiosxi
public | xi_meta_meta_id_seq | sequence | nagiosxi
public | xi_options | table | nagiosxi
public | xi_options_option_id_seq | sequence | nagiosxi
public | xi_sysstat | table | nagiosxi
public | xi_sysstat_sysstat_id_seq | sequence | nagiosxi
public | xi_usermeta | table | nagiosxi
public | xi_usermeta_usermeta_id_seq | sequence | nagiosxi
public | xi_users | table | nagiosxi
public | xi_users_user_id_seq | sequence | nagiosxi
(22 rows)

[scottwilkerson]

sure... but the system seems to have "kicked off".

Do you mean the import was successful?

[benhank]

yes i think so I think the service hung. It's ok now.

[slansing]

Good thanks for lettings us know, postgres must have hung for some reason. Marking as resolved.