Category Archives: Databases

No ODBC driver after installing Oracle 11g R2

Posted on January 14, 2011 by Maris

Today, after installing Oracle Database 11g R2 Client there was no ODBC driver listed under Data Sources (ODBC) window. First I tried to change Setup type to Administrator, then Instant Client, etc… noting worked. Then I remembered my last issue … Continue reading →

Posted in Databases, OS | Tagged , , , , | 4 Comments

Backup / restore PostgreSQL database

Posted on July 31, 2009 by Maris

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: … Continue reading →

Posted in Databases | Tagged , | Leave a comment