Re: Log archiving (like db2, Oracle)

I am new to Postgres (we are looking at swaping out our Oracle databases to
save on the repressive licencing fees).

Archive logging is not just for database recovery - it can be used to
implement standby databases. Archived redo logs is one of the bigger gaps,
as we use standby databases to help maintain 24x7 (or our best attempt at).

Of course, adding this feature is one more step away from the features you
like (a fast, reliable, easy-to-administer database) and one step closer to
an Oracle database (slower, less reliable, and harder to administer).

David

----- Original Message -----
From: "Holger Marzen" <holger(at)marzen(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 12, 2002 11:04 PM
Subject: [GENERAL] Log archiving (like db2, Oracle)

> I am working and playin with PostgreSQL for about a year now, and I
> still find out new, great features. It is really great, stable and very
> easy to admininistrate compared to db2 or Oracle.
>
> But there is one important feature that ist missing compared to the big
> players: Recovery of a database with the last full dump (e.g. nightly)
> and all the archived logs. There are no archived logs in PostgreSQL by
> now. PostgreSQL only has th WAL that does a crash recovery. Are there
> plans to include archiving of "used" logs?
>
> Regards
> Holger
>
> --
> PGP/GPG Key-ID:
> http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org