Nagios Support Forum

Code: Select all

[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_auditlog TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_commands TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_events TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_eventqueue TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_incidents TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_meta TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_options TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_sysstat TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_usermeta TO nagiosxi;'
GRANT
[root@nagios ~]# psql -d nagiosxi -U postgres -c 'GRANT ALL PRIVILEGES ON TABLE xi_users TO nagiosxi;'
GRANT

Code: Select all

Backing up PostgresQL databases...
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  permission denied for relation xi_eventqueue_eventqueue_id_seq
pg_dump: The command was: SELECT sequence_name, start_value, last_value, increment_by, CASE WHEN increment_by > 0 AND max_value = 9223372036854775807 THEN NULL      WHEN increment_by < 0 AND max_value = -1 THEN NULL      ELSE max_value END AS max_value, CASE WHEN increment_by > 0 AND min_value = 1 THEN NULL      WHEN increment_by < 0 AND min_value = -9223372036854775807 THEN NULL      ELSE min_value END AS min_value, cache_value, is_cycled, is_called from xi_eventqueue_eventqueue_id_seq
Error backing up PostgresQL database 'nagiosxi' !

Code: Select all

psql -d nagiosxi -U postgres -c '\d'

Code: Select all

# psql -d nagiosxi -U postgres -c '\d'
                       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_eventqueue                   | table    | postgres
 public | xi_eventqueue_eventqueue_id_seq | sequence | postgres
 public | xi_events                       | table    | nagiosxi
 public | xi_events_event_id_seq          | sequence | nagiosxi
 public | xi_incidents                    | table    | nagiosxi
 public | xi_incidents_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
(26 rows)

Code: Select all

psql -d nagiosxi -U postgres -qAt -c "SELECT 'GRANT SELECT, USAGE, UPDATE ON ' || relname || ' TO nagiosxi;' FROM pg_statio_all_sequences WHERE schemaname = 'public'" | psql -d nagiosxi -U postgres