Create a dump of existing DWH dwh:
- \path\to\postgres\bin> .\pg_dump.exe -U postgres -f "\path\to\backup\dwh_backup.sql" dwh
Restore a dump in new dwh dwh_new:
- \path\to\postgres\bin> .\psql.exe -U postgres -f "\path\to\backup\dwh_backup.sql" dwh_new
The path to the two commands is usually as follows (replace 9.x with your installed version number):
- Windows: C:\Program Files\PostgreSQL\9.x\bin
- Linux: /usr/lib/postgresql/9.x/bin
You only need to know this if your console does not automatically recognise pg_dump and psql as commands.
Microsoft SQL Server
Use SQL Server Management Studio to back up your database. Navigate to the database, right-click on it, and select tasks/backup or tasks/restore.
Please sign in to leave a comment.