Re: restore question

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com>, Ronald Haynes <rhaynes74(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, Ray O'Donnell <ray(at)rodonnell(dot)ie>
Subject: Re: restore question
Date: 2022-07-19 16:50:56
Message-ID: b59bdce4-c6f2-4fe9-3356-3b8e3915f26d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/19/22 9:49 AM, Benedict Holland wrote:
> You have to create the database to restore to. Then pg_resrore should work.

The OP is not using pg_restore but psql as the dump file is plain text.
>
> Thanks,
> Ben

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2022-07-19 16:51:40 Re: postgis
Previous Message Sebastien Flaesch 2022-07-19 16:50:28 Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence