Re: restore question
| От | Ray O'Donnell |
|---|---|
| Тема | Re: restore question |
| Дата | |
| Msg-id | 89905c07-ae17-a1a7-2a26-ba8ab6109c50@rodonnell.ie обсуждение исходный текст |
| Ответ на | restore question (Ronald Haynes <rhaynes74@gmail.com>) |
| Ответы |
Re: restore question
|
| Список | 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@rodonnell.ie
В списке pgsql-general по дате отправления: