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@rodonnell.ie