Page 1 of 1
xi restore fail
Posted: Thu Feb 21, 2013 12:57 pm
by 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?
Re: xi restore fail
Posted: Thu Feb 21, 2013 1:50 pm
by slansing
Can you run the following:
And post what the command line outputes.
And post the output from:
Re: xi restore fail
Posted: Thu Feb 21, 2013 1:56 pm
by benhank
[root@Lkennagiosp02 ~]# service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
[root@Lkennagiosp02 ~]# umask
0022
[root@Lkennagiosp02 ~]#
Re: xi restore fail
Posted: Thu Feb 21, 2013 2:09 pm
by scottwilkerson
Was this a new install of XI you are restoring to?
can you run the following and show the output
Re: xi restore fail
Posted: Thu Feb 21, 2013 2:15 pm
by 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)
Re: xi restore fail
Posted: Thu Feb 21, 2013 4:08 pm
by scottwilkerson
benhank wrote:sure... but the system seems to have "kicked off".
Do you mean the import was successful?
Re: xi restore fail
Posted: Thu Feb 21, 2013 4:19 pm
by benhank
yes i think so I think the service hung. It's ok now.
Re: xi restore fail
Posted: Thu Feb 21, 2013 4:22 pm
by slansing
Good thanks for lettings us know, postgres must have hung for some reason. Marking as resolved.