Re: Display of timestamp in pg_dump custom format

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Display of timestamp in pg_dump custom format
Date: 2014-09-05 23:22:48
Message-ID: 20140905232248.GF26717@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 4, 2014 at 01:19:31PM -0400, Bruce Momjian wrote:
> Uh, not sure what I was thinking --- strftime() is the way to go. Here
> is the new output:
>
> ;
> ; Archive created at 2014-09-04 13:00:15 -0400 <---
> ; dbname: test
> ; TOC Entries: 8
> ; Compression: -1
> ; Dump Version: 1.12-0
> ; Format: CUSTOM
> ; Integer: 4 bytes
> ; Offset: 8 bytes
> ; Dumped from database version: 9.5devel
> ; Dumped by pg_dump version: 9.5devel
>
> I found two other places in our dump code that use strftime with a
> similar format, but they had problems with the timezone string on
> Windows, so I switched those over to use a numeric timezone offset as
> well.

Patch applied.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2014-09-05 23:26:55 Re: pg_upgrade and epoch
Previous Message Bruce Momjian 2014-09-05 23:19:57 Re: pg_upgrade and epoch