pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17046: Upgrade postgres 11 to 13 version
6+ messages / 4 participants
[nested] [flat]
* BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-03 10:50 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: PG Bug reporting form @ 2021-06-03 10:50 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: ram.maurya@lavainternational.in
The following bug has been logged on the website:
Bug reference: 17046
Logged by: Ram Pratatp maurya
Email address: ram.maurya@lavainternational.in
PostgreSQL version: 13.1
Operating system: RHEL 8.3
Description:
Hi Team,
i want to upgrade postgres version 11 to 13 . i am doing this activity as
given below.
i am creating new server and installed postgres -13 and take PG_BACKUP form
current PRD server (PG version 11) and restore DB on PG-13 server. can you
suggest if we doing upgrade by this activity there is any issue.
Regards,
Ram Pratap
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-03 12:31 David Rowley <dgrowleyml@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: David Rowley @ 2021-06-03 12:31 UTC (permalink / raw)
To: ram.maurya@lavainternational.in, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Fri, 4 Jun 2021 at 00:22, PG Bug reporting form
<noreply@postgresql.org> wrote:
> i am creating new server and installed postgres -13 and take PG_BACKUP form
> current PRD server (PG version 11) and restore DB on PG-13 server. can you
> suggest if we doing upgrade by this activity there is any issue.
The form you've used is for reporting bugs yet, this does not seem to
be a bug report.
If you're looking for general help and advice then you should consider
asking on one of the mailing lists.
https://www.postgresql.org/list/
pgsql-general might be the best fit.
David
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-03 12:53 Ram Pratap Maurya <ram.maurya@lavainternational.in>
parent: David Rowley <dgrowleyml@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ram Pratap Maurya @ 2021-06-03 12:53 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi Team,
I am creating new server and installed postgres -13 and take PG_BACKUP form current PRD server (PG version 11) and restore DB on PG-13 server.
can you suggest if we doing upgrade by this activity there is any issue.
Regards,
Ram Pratap.
-----Original Message-----
From: David Rowley [mailto:dgrowleyml@gmail.com]
Sent: 03 June 2021 18:01
To: Ram Pratap Maurya; PostgreSQL mailing lists
Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
On Fri, 4 Jun 2021 at 00:22, PG Bug reporting form <noreply@postgresql.org> wrote:
> i am creating new server and installed postgres -13 and take PG_BACKUP
> form current PRD server (PG version 11) and restore DB on PG-13
> server. can you suggest if we doing upgrade by this activity there is any issue.
The form you've used is for reporting bugs yet, this does not seem to be a bug report.
If you're looking for general help and advice then you should consider asking on one of the mailing lists.
https://www.postgresql.org/list/
pgsql-general might be the best fit.
David
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-03 21:37 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Ram Pratap Maurya <ram.maurya@lavainternational.in>
0 siblings, 1 reply; 6+ messages in thread
From: Adrian Klaver @ 2021-06-03 21:37 UTC (permalink / raw)
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 6/3/21 5:53 AM, Ram Pratap Maurya wrote:
> Hi Team,
>
> I am creating new server and installed postgres -13 and take PG_BACKUP form current PRD server (PG version 11) and restore DB on PG-13 server.
> can you suggest if we doing upgrade by this activity there is any issue.
When doing this you should use the later version(13) of pg_dump to dump
the earlier version, are you doing that? If you are then you have
eliminated one possible issue.
You should also read the Release Notes section of version 12 and 13:
https://www.postgresql.org/docs/12/release.html
https://www.postgresql.org/docs/13/release.html
to see what things have changed that may affect your current set up.
>
>
>
> Regards,
> Ram Pratap.
>
> -----Original Message-----
> From: David Rowley [mailto:dgrowleyml@gmail.com]
> Sent: 03 June 2021 18:01
> To: Ram Pratap Maurya; PostgreSQL mailing lists
> Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
>
> On Fri, 4 Jun 2021 at 00:22, PG Bug reporting form <noreply@postgresql.org> wrote:
>> i am creating new server and installed postgres -13 and take PG_BACKUP
>> form current PRD server (PG version 11) and restore DB on PG-13
>> server. can you suggest if we doing upgrade by this activity there is any issue.
>
> The form you've used is for reporting bugs yet, this does not seem to be a bug report.
>
> If you're looking for general help and advice then you should consider asking on one of the mailing lists.
>
> https://www.postgresql.org/list/
>
> pgsql-general might be the best fit.
>
> David
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-04 11:46 Ram Pratap Maurya <ram.maurya@lavainternational.in>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ram Pratap Maurya @ 2021-06-04 11:46 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Ashish Chugh <ashish.chugh@lavainternational.in>
Dear Adrian,
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).
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.
Regards,
Ram Pratap.
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: 04 June 2021 03:07
To: Ram Pratap Maurya; pgsql-general@lists.postgresql.org
Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
On 6/3/21 5:53 AM, Ram Pratap Maurya wrote:
> Hi Team,
>
> I am creating new server and installed postgres -13 and take PG_BACKUP form current PRD server (PG version 11) and restore DB on PG-13 server.
> can you suggest if we doing upgrade by this activity there is any issue.
When doing this you should use the later version(13) of pg_dump to dump the earlier version, are you doing that? If you are then you have eliminated one possible issue.
You should also read the Release Notes section of version 12 and 13:
https://www.postgresql.org/docs/12/release.html
https://www.postgresql.org/docs/13/release.html
to see what things have changed that may affect your current set up.
>
>
>
> Regards,
> Ram Pratap.
>
> -----Original Message-----
> From: David Rowley [mailto:dgrowleyml@gmail.com]
> Sent: 03 June 2021 18:01
> To: Ram Pratap Maurya; PostgreSQL mailing lists
> Subject: Re: BUG #17046: Upgrade postgres 11 to 13 version
>
> On Fri, 4 Jun 2021 at 00:22, PG Bug reporting form <noreply@postgresql.org> wrote:
>> i am creating new server and installed postgres -13 and take
>> PG_BACKUP form current PRD server (PG version 11) and restore DB on
>> PG-13 server. can you suggest if we doing upgrade by this activity there is any issue.
>
> The form you've used is for reporting bugs yet, this does not seem to be a bug report.
>
> If you're looking for general help and advice then you should consider asking on one of the mailing lists.
>
> https://www.postgresql.org/list/
>
> pgsql-general might be the best fit.
>
> David
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17046: Upgrade postgres 11 to 13 version
@ 2021-06-04 14:24 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Ram Pratap Maurya <ram.maurya@lavainternational.in>
0 siblings, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2021-06-04 14:24 UTC (permalink / raw)
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Ashish Chugh <ashish.chugh@lavainternational.in>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-06-04 14:24 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-03 10:50 BUG #17046: Upgrade postgres 11 to 13 version PG Bug reporting form <noreply@postgresql.org>
2021-06-03 12:31 ` David Rowley <dgrowleyml@gmail.com>
2021-06-03 12:53 ` Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-06-03 21:37 ` Adrian Klaver <adrian.klaver@aklaver.com>
2021-06-04 11:46 ` Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-06-04 14:24 ` Adrian Klaver <adrian.klaver@aklaver.com>
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