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
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.
Than
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
---
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.
On 12/16/24 13:19, Bharani SV-forum wrote:
Team
I am getting the following error.
pg_dump: error: error reading large object 2113418:
pg_dump: error: could not open large object 3391830:
What user are you running pg_dump as?
What version of pg_dump?
I tried to give this command DB name =
TeamI am getting the following error.
pg_dump: error: error reading large object 2113418:
pg_dump: error: could not open large object 3391830:
I tried to give this command DB name = abcefg
ALTER DATABASE abcefgd SET lo_compat_privileges=on;
and reran and once again , i am getting the same error
On 12/11/24 11:12, Bharani SV-forum wrote:
Team
As suggested from old server, post shutdown of DB, I did OS level dump
of PG_DATA folder and had restored in the new server.
If you follow the process shown here:
https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_TeWMFMRv
TeamAs suggested from old server, post shutdown of DB, I did OS level dump of
PG_DATA folder and had restored in the new server.
Any idea on how to install the older binary postgres 13.18 ( OS=Amazon Linux
2023.6.20241121) under a dedicated folder suffixed as the following e.g.)
/usr/pgsql1318
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
c 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 C
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
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>
> <mailto:esteembsv-fo...@yahoo.com>> wrote:
> >>
> >> Team
> >> Pl Help in v
; On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
>> mailto:esteembsv-fo...@yahoo.com>
<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
>>
>
to: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 performing upgrad
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 Com
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 w
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.
>
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
TeamPl 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 upgrade from Ver 13.X to ver 15.X
ASIS
25 matches
Mail list logo
