Search Postgresql Archives

Re: restore question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: restore question
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Tue, 19 Jul 2022 09:50:56 -0700
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>, "Ray O'Donnell" <ray@xxxxxxxxxxxx>
Feedback-id: i76984098:Fastmail
In-reply-to: <CAD+mzowsiwyffLyKOfFo8ambG7LQcMREsZn-7Sc_LCOz_BagvA@mail.gmail.com>
References: <12b2292b-372c-4fe0-9f63-7f641bad688a@Spark> <72da6868-8a2c-4378-8857-8391763393cb@Spark> <89905c07-ae17-a1a7-2a26-ba8ab6109c50@rodonnell.ie> <592b6261-8a4f-481f-853a-b80f159dcb1e@Spark> <CAD+mzowsiwyffLyKOfFo8ambG7LQcMREsZn-7Sc_LCOz_BagvA@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.0

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.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- restore question
  - From: Ronald Haynes
- Re: restore question
  - From: Ray O'Donnell
- Re: restore question
  - From: Ronald Haynes
- Re: restore question
  - From: Benedict Holland

Prev by Date: Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Next by Date: Re: postgis
Previous by thread: Re: restore question
Next by thread: Re: restore question
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux