How to move a postgres server

From: "Ron Watkins" <rwatki(at)gmail(dot)com>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: How to move a postgres server
Date: 2018-02-16 19:04:55
Message-ID: 233701d3a759$091f98f0$1b5ecad0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a postgres server with 2 databases residing on a host which is being
de-commissioned.

I need to move the postgres server itself, including the databases to a new
host.

All the stuff I can find on the web talks about moving the database, but I
need to move the entire server.

Am I missing something here?

Am I suppose to create an identical server on the new host (with the same
server name), then backup/restore the databases individually? Is there not
any way to move the entire server?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-02-16 19:08:36 Re: postgres started without auto vaccum
Previous Message Laurenz Albe 2018-02-16 19:00:31 Re: postgres not starting