Re: pg_restore -N loses extension comment

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pg_restore -N loses extension comment
Date: 2024-05-07 13:52:49
Message-ID: 4054893.1715089969@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby <pryzby(at)telsasoft(dot)com> writes:
> pg_dump -Fc |pg_restore -l -N schema:
> | 2; 3079 18187 EXTENSION - pg_buffercache
> Without -N schema also shows:
> | 2562; 0 0 COMMENT - EXTENSION pg_buffercache

Hmm, but what happens if you actually do the restore?

I think this may be a bug in -l mode: ProcessArchiveRestoreOptions
saves the result of _tocEntryRequired in te->reqs, but PrintTOCSummary
doesn't, and that will bollix its subsequent _tocEntryRequired checks
for "dependent" TOC entries.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2024-05-07 14:05:02 Re: WHERE CURRENT OF with RLS quals that are ctid conditions
Previous Message Robert Haas 2024-05-07 13:47:10 Re: WHERE CURRENT OF with RLS quals that are ctid conditions