Search Postgresql Archives

Re: restore question

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

 



You have to create the database to restore to. Then pg_resrore should work.

Thanks,
Ben

On Tue, Jul 19, 2022, 12:44 PM Ronald Haynes <rhaynes74@xxxxxxxxx> wrote:
Thanks Ray, running 

pSql -f backup-file.sql 



psql: error: FATAL: database "rhaynes74" does not exist

Which seems odd since rhaynes74 is a user not a database name in the file. 

Sincerely,

Dr. Ronald D. Haynes
Professor, Department of Mathematics and Statistics
Chair, MSc and Phd Scientific Computing Programs
Memorial University of Newfoundland

We acknowledge that the lands on which Memorial University’s campuses are situated are in the traditional territories of diverse Indigenous groups, and we acknowledge with respect the diverse histories and cultures of the Beothuk, Mi’kmaq, Innu, and Inuit of this province.
On Jul 19, 2022, 9:40 AM -0230, Ray O'Donnell <ray@xxxxxxxxxxxx>, wrote:
On 19/07/2022 11:11, Ronald Haynes wrote:
Hi folks,  I am a fairly novice postgresql user.



I have a backup file for a couple of small postgresql databases.    The
backup file was created using postgresql 12.2, my Mac now has a
postgresql 13.x or 14.x versions.   I would like to restore the setup
from the backup file.


That looks like a dump file generated by pg_dumpall, so restoring it
should be as simple as:

psql -f backup-file.sql

You'll possibly need other connection parameters as required by psql,
such as -U (the PostgreSQL user to use for connecting) or others.

HTH,

Ray.


--
Raymond O'Donnell // Galway // Ireland
ray@xxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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