public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bharani SV-forum <[email protected]>
To: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
To: Adrian Klaver <[email protected]>
Subject: Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
Date: Mon, 16 Dec 2024 23:05:18 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com>
<[email protected]>
<[email protected]>
<CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
TeamBeing dev server, I noticed, we haven't performed analyze/vacuum process.
Noticed and re-triggerred vacuum full and analyze for all the application related db's
Re ran backup.
No issue's appeared during backup.
Not yet performed restoration in pgsql ver 15.09 in new vm with different OS.
Thank you for guiding me
On Monday, December 16, 2024 at 05:49:28 PM EST, Adrian Klaver <[email protected]> wrote:
On 12/16/24 14:30, Bharani SV-forum wrote:
> *a) *
> *user = *
> postgres
>
> b)
> *pg_dump version = *
> /usr/bin/pg_dump -V
>
> pg_dump (PostgreSQL) 13.16
>
> c)
>
> *DB version*
>
> select version () ;
> version
> ----------------------------------------------------------------------------------------------------------
> PostgreSQL 13.16 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
> 20150623 (Red Hat 4.8.5-44), 64-bit
>
> *use this script for backup*
>
> pg_dump -Fp -p 5432 -U "$USERNAME" "$DATABASE"
>
> using username = postgres
>
> for one of the DB (ver 13.16), it worked fine by doing oldvm = pg_dump
> from ver 13.16 and
> later restoring in new VM with new OS and new db binary 15.09, post
> creating dummy db (appln related) and restoring the pg_dump from oldvm .
>
That's nice, but the issue is the case that did not work.
What process where you running that caused the error?
--
Adrian Klaver
[email protected]
view thread (61+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox