Re: How I can know a back up database is up to date

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: son(at)raider(dot)co(dot)nz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How I can know a back up database is up to date
Date: 2007-08-10 17:29:03
Message-ID: 46BCA05F.9060908@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/08/2007 23:40, son(at)raider(dot)co(dot)nz wrote:

> My database is restored from a dump file every day. How I know that this
> database is up to date (as it has no timestamp in any table).
>
> If I create a file, I can know when I created it by seeing its property.
> How I can do the same thing with a back up database.

Do the backup from a shell script that names the output file with the
current date/time.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-08-10 17:30:38 Re: Dell Hardware Recommendations
Previous Message Tom Lane 2007-08-10 17:10:04 Re: CREATE RULE on VIEW with INSERT after UPDATE does not work