MIME-Version: 1.0
Date: Fri, 4 Mar 2016 14:27:59 -0800
Message-ID: 
 <CAEaSS0atiPVYLhMSwtzcZB5efeTxYjYDR1s3OZSshpkAY1VsAg@mail.gmail.com>
Subject: Clarification on using pg_upgrade
From: Tory M Blue <tmblue@gmail.com>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11c0b3b4a69f72052d40a08f
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a11c0b3b4a69f72052d40a08f
Content-Type: text/plain; charset=UTF-8

Howdy

Postgres9.2 going to 9.4
CentOS 6.5

So in most of my environments, I use slony and thus use slony replication
for my upgrades (Drop/add nodes etc).

But I've got a pretty big DB  just shy of a TB that is on a single node. A
dump restore would take over 48 hours because of index creations etc, so
thought maybe I would look at doing a upgrade via pg_upgrade.

There are some challenges, since I build my rpm's to a standard directory
for binaries and then the data directory. So I will have to move/rename
directories, but when that's done, I'm slightly confused on the pg_upgrade
using link options.

If my data is located in /data

and I link to a new dir in /data1,  what actually happens. do I end up with
2 file systems and links and thus am not able to delete or cleanup any old
data, or how does this work?

Also will the reindex creation still happen with this type of in-place
upgrade, as if so, then it may not save too much time vs a dump/import.

I'm nervous about using pg_upgrade but it's really tough to recover from
the jobs that backup during a dump/restore process (2-3 days), so really
trying to wrap my head around pg_upgrade..

Suggestions, opinions on pg_upgrade vs dump/restore, the filesystem/mount
below is what I'm working with.

Filesystem                       Size  Used Avail Use% Mounted on

/dev/sda6                        4.0T  1.1T  2.8T  29% /data

Thanks
Tory

--001a11c0b3b4a69f72052d40a08f
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra">Howdy</div><div class=3D"gmail_=
extra"><br></div><div class=3D"gmail_extra">Postgres9.2 going to 9.4</div><=
div class=3D"gmail_extra">CentOS 6.5<br></div><div class=3D"gmail_extra"><b=
r></div><div class=3D"gmail_extra">So in most of my environments, I use slo=
ny and thus use slony replication for my upgrades (Drop/add nodes etc).</di=
v><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">But I&#39=
;ve got a pretty big DB =C2=A0just shy of a TB that is on a single node. A =
dump restore would take over 48 hours because of index creations etc, so th=
ought maybe I would look at doing a upgrade via pg_upgrade.</div><div class=
=3D"gmail_extra"><br></div><div class=3D"gmail_extra">There are some challe=
nges, since I build my rpm&#39;s to a standard directory for binaries and t=
hen the data directory. So I will have to move/rename directories, but when=
 that&#39;s done, I&#39;m slightly confused on the pg_upgrade using link op=
tions.</div><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra"=
>If my data is located in /data</div><div class=3D"gmail_extra"><br></div><=
div class=3D"gmail_extra">and I link to a new dir in /data1, =C2=A0what act=
ually happens. do I end up with 2 file systems and links and thus am not ab=
le to delete or cleanup any old data, or how does this work?</div><div clas=
s=3D"gmail_extra"><br></div><div class=3D"gmail_extra">Also will the reinde=
x creation still happen with this type of in-place upgrade, as if so, then =
it may not save too much time vs a dump/import.</div><div class=3D"gmail_ex=
tra"><br></div><div class=3D"gmail_extra">I&#39;m nervous about using pg_up=
grade but it&#39;s really tough to recover from the jobs that backup during=
 a dump/restore process (2-3 days), so really trying to wrap my head around=
 pg_upgrade..</div><div class=3D"gmail_extra"><br></div><div class=3D"gmail=
_extra">Suggestions, opinions on pg_upgrade vs dump/restore, the filesystem=
/mount below is what I&#39;m working with.</div><div class=3D"gmail_extra">=
<br></div><div class=3D"gmail_extra">


<p class=3D""><span class=3D"">Filesystem =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Size=C2=A0 Used Avail Use% Mo=
unted on</span></p><p class=3D""><span class=3D"">/dev/sda6=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 4.0T=
=C2=A0 1.1T=C2=A0 2.8T=C2=A0 29% /data</span></p></div><div class=3D"gmail_=
extra"><br></div><div class=3D"gmail_extra">Thanks</div><div class=3D"gmail=
_extra">Tory</div></div>

--001a11c0b3b4a69f72052d40a08f--