| From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
|---|---|
| To: | Ronald Haynes <rhaynes74(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: restore question |
| Date: | 2022-07-19 12:10:13 |
| Message-ID: | 89905c07-ae17-a1a7-2a26-ba8ab6109c50@rodonnell.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)rodonnell(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2022-07-19 13:05:23 | Re: [PATCH] Introduce array_shuffle() and array_sample() |
| Previous Message | Meera Nair | 2022-07-19 12:07:17 | RE: pg_dump is filling C: drive up to 100 percent |