How can I set up and maintain the database? Parent topic

The following commands can help you maintain the database:
Note
Note
Before you use SQL commands such as ex, psql, pgdump, and pgrestore, run the source /IMSS_install_path/imss/script/pg.rc command first. For example, run source /opt/trend/imss/script/pg.rc.
In addition, to connect to a database server running Red Hat Enterprise Linux 7, add -h 127.0.0.1 to the command line. For example, run /opt/trend/imss/PostgreSQL/bin/psql -h 127.0.0.1 -U sa -d imss.
  • pg_dump –d imss –U sa > YYMMDD.HHMMSS.backup: Back up the database.
  • psql -U sa -d imss < ./YYMMDD.HHMMSS.backup: Retrieve the latest data if errors occur.
  • vacuum: Clean up the database on tables that are frequently accessed or on tables that have large amounts of data. Use this command when email traffic is low or when the device is not connected to your network.
  • vacuumfull: Clean up the entire database when the database is not being heavily utilized or when the device is not connected to your network.
  • redirect_stderr= and log_rotate_***=: Turn on these options in postgresql.conf to redirect old database log entries to the system log, which is rotatable. You can name the log file to start with a dash “-”.