Re: pg_restore: warning: invalid creation date in header

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: pg_restore: warning: invalid creation date in header
Дата
Msg-id CAOC+FBXLMUW2dqpckEXKsK7Y_r7gsYhXJ78m6vdGtqRXM_JOmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore: warning: invalid creation date in header  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
That's what I figured. Restore looks fine. Just hadn't seen that before (but also never had restored a PDT backup to a UTC machine). Just wanted to check.

On Sat, Jun 12, 2021 at 4:57 PM Ron <ronljohnsonjr@gmail.com> wrote:
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.


--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: pg_restore: warning: invalid creation date in header
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: vacuumdb idle processes