Many thanks folks, the last message by Adrian gave me the relatively simple prescription.
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, 2:22 PM -0230, Adrian Klaver <adrian.kla...@aklaver.com>, wrote: > On 7/19/22 9:44 AM, Ronald Haynes wrote: > > Thanks Ray, running > > > > pSql -f backup-file.sql > > > > > > > > psql: error: FATAL: database "rhaynes74" does not exist > > No that is expected as you did not specify a database to connect to > using -d <some_db>. In that case psql uses the OS user name you are > running the command as for the database name per: > > https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS > > dbname > > The database name. Defaults to be the same as the user name. In > certain contexts, the value is checked for extended formats; see Section > 34.1.1 for more details on those. > > So change the command to: > > psql -d postgres -U <db_user> -f backup-file.sql > > Where <db_user> is a database user that has the correct privileges to > load/create the databases. > > > > > 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 > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com
