Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
On 09/08/2007 23:40, [EMAIL PROTECTED] 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

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Richard Broersma Jr
--- Raymond O'Donnell [EMAIL PROTECTED] wrote: On 09/08/2007 23:40, [EMAIL PROTECTED] 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

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
On 10/08/2007 18:40, Richard Broersma Jr wrote: If you need to, you can append your own timestamp to the dump file if you need it. Heh heh, I just gave this same advice in reply to the post that prompted this idea. :-) Thanks, Ray.

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

2007-08-10 Thread Raymond O'Donnell
On 09/08/2007 23:40, [EMAIL PROTECTED] 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

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Tom Lane
Raymond O'Donnell [EMAIL PROTECTED] writes: Actually, it *would* be really handy if pg_dump included a timestamp in the plain-text output. Use the verbose option. regards, tom lane ---(end of broadcast)--- TIP 4: Have

Re: Timestamp in pg_dump output, was Re: [GENERAL] How I can know a back up database is up to date

2007-08-10 Thread Raymond O'Donnell
On 10/08/2007 19:10, Tom Lane wrote: Use the verbose option. [/me tries it out] That'll do nicely - thanks. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED]

[GENERAL] How I can know a back up database is up to date

2007-08-09 Thread son
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.