KB - Backup and restore for PostgreSQL

If using PostgreSQL, the SMDS database can be backed up using the following command line:

CODE

C:\postgres\9.5\bin\pg_dump -d smds -U smds -W -f <file location>\<filename>.tar -F t

A backup copy of the SMDS can be restored with the pg_restore command::

CODE

C:\postgres\9.5\bin\pg_restore -U smds -c --dbname=smds <full path to backup file>