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
