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 in (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 backup your database. Navigate to the database, right click on it and select tasks/backup or tasks/restore.