Forgot to mention: the same concerns about possible index corruption are
relevant for the pg_upgrade option too (because it doesn't rebuild
indexes). So, I'd definitely choose dump/restore if the database is small.
In the case of pg_upgrade, I would rebuild all the indexes during the
maintenance wi
On 9/2/21 11:55 AM, Vano Beridze wrote:
I just want to upgrade to the OS and Postgres that is supported.
If I just stop the service on both VMs and upgrade Ubuntu, then start
Postgres, will it work or I should go with clean install and dump/restore?
Prudent behavior before you do any upgrading
On Thursday, September 2, 2021, Vano Beridze wrote:
> I just want to upgrade to the OS and Postgres that is supported.
> If I just stop the service on both VMs and upgrade Ubuntu, then start
> Postgres, will it work or I should go with clean install and dump/restore?
>
>>
>>
Personally I find the
I just want to upgrade to the OS and Postgres that is supported.
If I just stop the service on both VMs and upgrade Ubuntu, then start
Postgres, will it work or I should go with clean install and dump/restore?
On Thu, Sep 2, 2021 at 10:41 PM Adrian Klaver
wrote:
> On 9/2/21 11:34 AM, Vano Beridz
On 9/2/21 11:34 AM, Vano Beridze wrote:
> What repo are you getting Postgres from, Ubuntu or PGDG?
Ubuntu
So you are going to get version 10.
Is that what you want?
If you want to move to something newer then this maybe the time to move
to the PGDG repos, as they allow you to install any of
> What repo are you getting Postgres from, Ubuntu or PGDG?
Ubuntu
On Thu, Sep 2, 2021 at 10:13 PM Adrian Klaver
wrote:
> On 9/2/21 10:38 AM, Vano Beridze wrote:
> > Hello,
> >
> > I've got 2 VMs with Postgresql 9.5 cluster with streaming replication.
> > VMs have Ubuntu 16.04.
> > I would like
Logical way – dump/restore.
Bringing PGDATA physically may lead to corrupted indexes due to glibc
version changes. 16.04 -> 18.04 shouldn't cause it, but it may. You can
check btree index with amcheck and GIN indexes with a patched version of it
(some backporting would be needed). You can find exa
On 9/2/21 10:38 AM, Vano Beridze wrote:
Hello,
I've got 2 VMs with Postgresql 9.5 cluster with streaming replication.
VMs have Ubuntu 16.04.
I would like to upgrade Ubuntu and Postgresql to newer versions.
Ubuntu 16.04 supports upgrading to 18.04.
What is the safest way to upgrade Postgresql cl
Hello,
I've got 2 VMs with Postgresql 9.5 cluster with streaming replication.
VMs have Ubuntu 16.04.
I would like to upgrade Ubuntu and Postgresql to newer versions.
Ubuntu 16.04 supports upgrading to 18.04.
What is the safest way to upgrade Postgresql cluster along with it?
The database is not b
