Wells Oliver <wells.oliver@xxxxxxxxx> writes: > These are the first lines when trying to restore a dump created on a > machine in the PDT time zone, into a machine in UTC. Not sure if it > matters, but I wanted to ask. > pg_restore: warning: invalid creation date in header Hmm. Looking at the code for that, it knows nothing of timezones. It's complaining that mktime() failed, which perhaps is because of bad data in the archive header ... but I'm betting it has something to do with failing to initialize all the fields of the struct tm it passes. However, that code's been like that a long time and we've not heard previous reports of this. Could you say exactly what the (receiving) platform is? How was pg_restore built (any special switches, etc)? The output of pg_config on that machine might be helpful. regards, tom lane
