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] --

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:

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: 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

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 u

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 u

[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. --