Re: BUG #17065: pg_restore never returns even on simple situations (maybe I just don't understand something)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ktr(at)goldin-rudahl(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17065: pg_restore never returns even on simple situations (maybe I just don't understand something)
Date: 2021-06-20 17:26:01
Message-ID: 1510737.1624209961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> I tried the following commands, as user postgres
> -bash-4.2$ pg_restore -d copy
> ^C
> -bash-4.2$ pg_restore -d copy -v
> ^C
> -bash-4.2$ pg_restore -f animals-c -l
> ^C
> -bash-4.2$ pg_restore -f animals-p -l

> In each case, I ctrl-C'd after about 10 minutes of no activity.

In all these cases, pg_restore is expecting archive input to be
supplied on stdin. You've provided switches that indicate where
its output ought to go, but there's no input. Try something like

pg_restore -l animals-c

pg_restore -l <animals-c

pg_restore -d copy animals-c

pg_restore -f - animals-c

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-06-20 17:30:38 Re: 'within group'- or percentile_cont-expression seems to have ramifications on table ordering
Previous Message Bernd Hopp 2021-06-20 15:42:09 'within group'- or percentile_cont-expression seems to have ramifications on table ordering