From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: Ashish Chugh <ashish.chugh@lavainternational.in>
Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
Date: Fri, 4 Jun 2021 07:24:12 -0700
Message-ID: <45165dc6-cb05-3b67-b06e-c14ddaea5560@aklaver.com> (raw)
In-Reply-To: <KL1PR0601MB4433C171781B7246B1C13B80F03B9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: <17046-653f73611eea8857@postgresql.org>
<CAApHDvrXp0RrmnofqOpBSMKmzveLwaZZdDFYRDQndCFuH9B45w@mail.gmail.com>
<KL1PR0601MB4433B753276F4E27A3587E43F03C9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<0ff2f400-b8ac-c2cd-68a5-702a096c019d@aklaver.com>
<KL1PR0601MB4433C171781B7246B1C13B80F03B9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
On 6/4/21 4:46 AM, Ram Pratap Maurya wrote:
> Dear Adrian,
>
Please do not top post. It is the convention on this list to post inline
or bottom post.
> Currently I am using postgres 11 version and I want to upgrade postgres 13 and I am doing this activity , first we take pgbase_backup from from Postgres 11 and restore this backup on postgres 13 (new server).
Which version of pg_basebackup are you using to take backup of 11 version?
See here:
https://www.postgresql.org/docs/13/app-pgbasebackup.html
"pg_basebackup works with servers of the same or an older major version,
down to 9.1."
What is the exact command you are using?
> I am not using pg_dump .
> I have done this activity on test server and its is working fine .
> My confusion is it is possible to in future we face any issue like upgrade and vacume or we can`t use all added new feature in postgres 13.
You will still need to VACUUM, though AUTOVACUUM should take care of that.
Not sure what you mean about upgrade?
The new features will be available to you.
>
>
>
>
> Regards,
> Ram Pratap.
>
> -----Original Message-----
--
Adrian Klaver
adrian.klaver@aklaver.com
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-bugs@postgresql.org
Cc: adrian.klaver@aklaver.com, ram.maurya@lavainternational.in, pgsql-general@lists.postgresql.org, ashish.chugh@lavainternational.in
Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
In-Reply-To: <45165dc6-cb05-3b67-b06e-c14ddaea5560@aklaver.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