Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg_dump --comment?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jon Jensen <jon(at)endpoint(dot)com>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Chris Campbell <chris(at)bignerdranch(dot)com>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] pg_dump --comment?
Date: 2004-06-04 13:24:57
Message-ID: 200406041324.i54DOvq20574@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > The following patch adds start/stop times for pg_dump and pg_dumpall
> 
> What happens in a pg_dump -Fc / pg_restore scenario?

Uh, do those markers not appear in that dump type?  I thought they did.

I just tried pg_restore -v and while I see the lines, they are changing
every time I run it, meaning it isn't stored in the file but is showing
current time.  I looked in the dump file and I don't see the dates
either.

So, in non-ascii format, I need to dump a comment record and read it
back on restore?  Yuck.  Anyone want to tackle that?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Frank WilesDate: 2004-06-04 13:25:42
Subject: Re: Converting postgresql.conf parameters to kilobytes
Previous:From: Dave PageDate: 2004-06-04 12:44:54
Subject: Re: [HACKERS] Slony-I goes BETA

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-06-04 13:30:35
Subject: Re: Compiling libpq with VisualC
Previous:From: Andreas PflugDate: 2004-06-04 08:36:40
Subject: Re: Compiling libpq with VisualC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group