Re: Display of timestamp in pg_dump custom format - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Display of timestamp in pg_dump custom format
Date
Msg-id 20140905232248.GF26717@momjian.us
Whole thread Raw
In response to Re: Display of timestamp in pg_dump custom format  (Bruce Momjian <bruce@momjian.us>)
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade and epoch
Next
From: Greg Stark
Date:
Subject: Re: pg_upgrade and epoch