To backup / dump entire DB (database cluster), use the following command: pg_dumpall > outfileor with username and gzipped pg_dumpall -U postgres | gzip > db_backup.gz-U usename – connect as specified database user To restore from dump file “db_backup” use: psql -f db_backup postgres
Monthly Archives: July 2009
STL breaks after installing Microsoft Security Advisory 973882
After installing through Microsoft Update Vulnerabilities in Microsoft Active Template Library (ATL) Could Allow Remote Code Execution STL broke with the following error: c:\program files\microsoft visual studio 9.0\vc\include\xutility(2764) : error C3861: ‘_Swap_adl’: identifier not found Most probably, this is caused by accidentally deleted the following function: template inline void _Swap_adl(_Ty& _Left, _Ty& _Right) { // …
Continue reading “STL breaks after installing Microsoft Security Advisory 973882”
Batch script to test if folder / directory is empty
Yesterday I needed a Dos batch script to check if folder is empty. A little Google search revealed some methods: Using dir and find commands, does not work on non-english Windows versions: www.computing.net Using dir command with /a-d, does not work for folders: www.computing.net Using dir and findstr commands, does not work on non-english Windows …
Continue reading “Batch script to test if folder / directory is empty”