Skip to main content

KB - Backup and restore for PostgreSQL

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

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::

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

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.