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 <rhayne...@gmail.com> 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 <r...@rodonnell.ie>, 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 > r...@rodonnell.ie > >
