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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-06-04 13:30:35 Re: Compiling libpq with VisualC
Previous Message Andreas Pflug 2004-06-04 08:36:40 Re: Compiling libpq with VisualC