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

From: son(at)raider(dot)co(dot)nz
To: pgsql-general(at)postgresql(dot)org
Subject: How I can know a back up database is up to date
Date: 2007-08-09 22:40:58
Message-ID: 55617.202.78.240.7.1186699258.squirrel@www.raider.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

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.

Ta.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2007-08-09 22:54:00 Re: UPDATES hang every 5 minutes
Previous Message Arjen van der Meijden 2007-08-09 22:21:01 Re: Dell Hardware Recommendations