From: Ron Watkins <rwatki@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: How to move a postgres server
Date: Fri, 16 Feb 2018 12:04:55 -0700
Message-ID: <233701d3a759$091f98f0$1b5ecad0$@gmail.com> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rwatki@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to move a postgres server
In-Reply-To: <233701d3a759$091f98f0$1b5ecad0$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox