| From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
|---|---|
| To: | Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Subject: | Re: How to transfer databases form one server to other |
| Date: | 2020-01-27 09:39:04 |
| Message-ID: | 487f8a6e-bcf6-5580-93a5-6037b2412cab@rodonnell.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 26/01/2020 22:47, Andrus wrote:
> Hi!
>
>> Before you do any of this I would check the Release Notes for the
>> first release of each major release. Prior to version 10 that would be
>> X.X.x where X is a major release. For 10+ that is X.x. I would also
>> test the upgrade before doing it on your production setup.
>
> I want to create test transfer first, check applications work and after
> that final transfer.
>
>> Best practice if you are going the dump/restore route is to use the
>> pg_dump binary from the new server(12) to dump the old server(9.1)
>
> Postgres version 12 pg_dump probably cannot installed in old server
> (Debian Squeeze 9).
I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo:
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandip Pradhan | 2020-01-27 11:10:36 | Need support on tuning at the time of index creation |
| Previous Message | Andrus | 2020-01-27 06:56:18 | Re: How to transfer databases form one server to other |