On 6/12/21 6:47 PM, Wells Oliver wrote:
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
pg_restore: while PROCESSING TOC:
Given that it's just a warning, did the restore complete?
As for the reason... since PDT is -7 to UTC, I bet the creation date is
less than the clock date, which pg_restore warns about.
--
Angular momentum makes the world go 'round.