Re: How to find out version and install security patches?

On Sat, 31 May 2008 15:54:07 -0700, A. Farber wrote:

> Also is there maybe an easy way for me to create daily snapshots of the
> program database?
>
> For PostgreSQL I have a cronjob
> pg_dump phpbb > /mnt/backups/pg-`date +\%F`.sql

The "pg_dump" program used with the .sql extension (without -F c) is akin to Oracle export/import. As is the case with PgSQL, which produces SQL script to be "restored" by psql, SQL format is much slower to restore then the "custom" format, which is a physical backup to be restored by pg_restore.

So, in the world of Oracle, you could create a "snapshot" by using the export utility. Here I wholeheartedly advise you to go to at least oracle 10g as "data pump" versions are much faster and restartable. If you want to create backup, you would normally use RMAN for that purpose. RMAN is much faster because it backs up physical data files.

-- 
http://mgogala.freehostia.com