Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1emlJl-00064U-J3 for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 19:05:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1emlJk-0006DF-I2 for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 19:05:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1emlJk-0006D1-71 for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 19:05:08 +0000 Received: from mail-io0-x234.google.com ([2607:f8b0:4001:c06::234]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1emlJe-00006a-02 for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 19:05:07 +0000 Received: by mail-io0-x234.google.com with SMTP id p78so5126399iod.13 for ; Fri, 16 Feb 2018 11:05:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=0kdkq1ML5QMAU2SELxH2sP8Dgdhk77M2GCwIWphHsj4=; b=Cykgb+aUSwva7ty8207/ELd4mRMW4Q0Og9yBA7MX54rdxa3MXpkCtCXpUzHLWXiF+Z d450P35TyVU7Y44CWiGgk3FiQVoym5QAIBjE3wZjiJbxVmb9ArOo7pobsG9LaoDVhv0p HKSmtVquoWgE+6TA9DpzkNfVHHmSlQU5DlRyw3xnhwPjHKILPfGP8ZtbGVcNUONLon5M ZcnWDle2imqY2QvntsH8gwALrD4ZjWNUITOrSOSW835D6shJO0Vge/Fa2n2X4wWP3mjE J70uYpWtbMg7+GbJbNbAFHPxGOANSvAFgPPvrblF5rGrzivZkvN4ud6HCiip4R7gv3Nd ZhMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=0kdkq1ML5QMAU2SELxH2sP8Dgdhk77M2GCwIWphHsj4=; b=XeRZcvTmtLcukhFcKY6nnmPADFVTjZxtOPapdTHa/hudydKZWm/IDxk06fWKeV1S7u 215OpVFgweSN5Q7tj8+r5PgFWq3KbDW7aQUtmE01DoWA/qy/iV6WDYsV80UG1fHJMrqP YldmKXpggYN6NafbvTuQKTYF10jzcbbsMVnPUXF7zK8Stn5dWDK6A3FMVZ6BlgmMl4rA GkOSx58fFOFGb2i+TTRjsNV3UPAJr+CAvaoN8EtPvzhD0AOOnAkf23palQ+ETFaxYIE5 mCE38ii9SvfEp8zZ8flQZ87/oxi82xcaVmHOds8OYgbXnTENE7aiFLCL4lNWlcxsWF2J G5ww== X-Gm-Message-State: APf1xPBH1/tH4216fadbjsE/7HSaUYZahAeVPe4VAdkMjsoCls68wTys bxtIoOHF7h6atHTHi0KD7Qzn8w== X-Google-Smtp-Source: AH8x2247BGSIQa1wVklOkN8JuB+JlviYvDkByaeFxejWhysqOizljW/Fphlyi+KDt7xeng6lLru1xQ== X-Received: by 10.107.68.2 with SMTP id r2mr7548676ioa.21.1518807899572; Fri, 16 Feb 2018 11:04:59 -0800 (PST) Received: from RonPC (wsip-72-214-222-226.ph.ph.cox.net. [72.214.222.226]) by smtp.gmail.com with ESMTPSA id e83sm18854114iof.71.2018.02.16.11.04.57 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 16 Feb 2018 11:04:58 -0800 (PST) From: "Ron Watkins" To: Subject: How to move a postgres server Date: Fri, 16 Feb 2018 12:04:55 -0700 Message-ID: <233701d3a759$091f98f0$1b5ecad0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_2338_01D3A71E.5CC10F10" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdOnWL9vvK0DxaR4S2KMpgLwpfBtug== Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_2338_01D3A71E.5CC10F10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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? ------=_NextPart_000_2338_01D3A71E.5CC10F10 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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?

 

------=_NextPart_000_2338_01D3A71E.5CC10F10--