Team
I followed Greg suggested steps .One of big had only one table and around four
million recordsi am doing dev env restoration into new vmthe target VM env is
an POC server and took 3 hrs to restore four million records.Now it is doing
process of lo_open / lo_close / lowrite etci.e
pg-dum
On 12/4/24 04:42, Bharani SV-forum wrote:
Team /Ron/Adrian
Wann to reconfirm
we have an setup with
new server will be with
will be following the following suggestion
*On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) "
present in aws "us-east-1 region" and along with postg
On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum
wrote:
> a) is the above said steps is correct with the given existing and proposed
> setup
>
No. Here are some steps:
* Install Postgres on the new VM
However you get it, use the newest version you can. As of this writing, it
is Postgres 17.2. Ve
On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum
wrote:
> Team /Ron/Adrian
>
> Wann to reconfirm
> we have an setup with
>
> new server will be with
>
> will be following the following suggestion
>
> *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) "
> present in aws "us-east-
Team /Ron/Adrian
Wann to reconfirmwe have an setup with
new server will be with
will be following the following suggestion
On old VM [ existing server with OS "Amazon Linux release 2 (Karoo) " present
in aws "us-east-1 region" and along with postgresql ver 13.16.2 - community
edn ]
- "take
On 12/2/24 17:23, Ron Johnson wrote:
Adrian,
OP is moving to a new VM when migrating to PG 15. When was the
"cross-server" feature added to pg_upgrade?
Moving to a new VM was not the issue, my mistake was thinking the OS
version was staying the same.
Then:
On old VM:
"take offline ful
Adrian,
OP is moving to a new VM when migrating to PG 15. When was the
"cross-server" feature added to pg_upgrade?
On Mon, Dec 2, 2024 at 5:48 PM Adrian Klaver
wrote:
> On 12/2/24 14:46, Adrian Klaver wrote:
> > On 12/2/24 14:31, Ron Johnson wrote:
> >> On Mon, Dec 2, 2024 at 5:18 PM Bharani S
On 2024-12-03 00:25:15 +, Bharani SV-forum wrote:
> qsn1: What is the size of database(s) you are dealing with?
> ans1: roughly 25 GB (maximum size)
>
> qsn2 : What sort of downtime can you afford?
> ans2: can be maximum 30 mins or so
That does seem sufficient time to dump/restore a 25 GB da
AdrianNoted about, Logical replication would not have issue with this as that
is one of
it's use cases.
qsn1: What is the size of database(s) you are dealing with?
ans1: roughly 25 GB (maximum size)
qsn2 : What sort of downtime can you afford?
ans2: can be maximum 30 mins or so
qsn3: EC2 --> E
On 12/2/24 15:52, Bharani SV-forum wrote:
Adrian
Proposed new Server is intended to have higher OS Version (centos ver
9.0) and higher Postgres Version 15.10
Alright I did not catch this " ... with new OS" from your original post.
I saw "Take offline full backup (PG_DATA folder alone) using
Adrian
Proposed new Server is intended to have higher OS Version (centos ver 9.0) and
higher Postgres Version 15.10
Does logical replication will have issues , if the existing asis server is
having Postgres ver 13.16.2 with Cent Os 7.0 with the new server having higher
OS version Centos Ver 9.0
On 12/2/24 15:41, Bharani SV-forum wrote:
Ron/Adrian
Thanks for your input.
Your suggestion is
*option#1*
ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*
- ensure to capture all the pre.req meant for ver 15.10 are being met.
- enable logical replication tagged to prop
Ron/AdrianThanks for your input.Your suggestion is
option#1 ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*-
ensure to capture all the pre.req meant for ver 15.10 are being met.
- enable logical replication tagged to proposed new EC2 server (with newer
Higher OS Version
On 12/2/24 14:46, Adrian Klaver wrote:
On 12/2/24 14:31, Ron Johnson wrote:
On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
mailto:esteembsv-fo...@yahoo.com>> wrote:
Team
Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to
ver 15.X
Env = EC2 based Community Po
On 12/2/24 14:31, Ron Johnson wrote:
On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
mailto:esteembsv-fo...@yahoo.com>> wrote:
Team
Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to
ver 15.X
Env = EC2 based Community PostgreSQL Ver 13.16.2
we will be per
On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
wrote:
> Team
> Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver
> 15.X
>
> Env = EC2 based Community PostgreSQL Ver 13.16.2
>
> we will be performing upgrade of our EC2 server too along with new OS.
>
> Need help in vetting
On 12/2/24 14:18, Bharani SV-forum wrote:
Team
Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver
15.X
Env = EC2 based Community PostgreSQL Ver 13.16.2
we will be performing upgrade of our EC2 server too along with new OS.
Need help in vetting my steps for Postgres DB u
17 matches
Mail list logo
