pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
To: Ron Watkins <rwatki@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: RE: How to move a postgres server
Date: Fri, 16 Feb 2018 20:51:37 +0000
Message-ID: <BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217> (raw)
In-Reply-To: <233701d3a759$091f98f0$1b5ecad0$@gmail.com>
References: <233701d3a759$091f98f0$1b5ecad0$@gmail.com>





From: Ron Watkins [mailto:rwatki@gmail.com]
Sent: Saturday, 17 February 2018 6:05 AM
To: pgsql-admin@lists.postgresql.org
Subject: How to move a postgres server

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?

Hi,

The best way to do that with minimal downtime would be to use streaming replication. But that depends on a few other findings as below


1)      Version of the PostgreSQL server

2)      Size of the databases

3)      What OS: Linux/Win etc. and their versions

If the downtime is affordable, then build a new server with most recent patch updates and an installation of the same PostgreSQL version on it. Then, shutdown the database cluster, copy the files across and bring up the cluster on the new server. Although, I would not recommend this approach but this is the simplest way to move the PostgreSQL server when downtime is not a big deal.

~

Nawaz Ahmed
Disclaimer

The information in this e-mail is confidential and may contain content that is subject to copyright and/or is commercial-in-confidence and is intended only for the use of the above named addressee. If you are not the intended recipient, you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you have received this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by reply e-mail to the sender and delete the document and all copies thereof.


Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email communication, it is the receiver’s responsibility to scan all communication and any files attached for computer viruses and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may result directly or indirectly from this communication or any files attached.


If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe@fast.au.fujitsu.com


view thread (4+ messages)  latest in thread

Message-ID: <BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217>
Permalink:  ../BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217/
Also on:    postgresql.org/message-id/BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Nawaz@fast.au.fujitsu.com, rwatki@gmail.com
  Subject: Re: How to move a postgres server
  In-Reply-To: <BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217>
  References: <233701d3a759$091f98f0$1b5ecad0$@gmail.com> <BAAE097528E6CB4FB2BE65AEFA6EEE04929FDA34@SYD1217>

* 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