TQ Adriananother Question on the measuring egress (out bound traffic) /ingress
(inbound traffic) w.r.to " pg_dumpall " during usage of
pg_dumpall-h -p 5432 | psql -p 5462
taking data from old_vm and copying to new_vm, as i need to use across the
network for taking data and i cannot use "pg_
l ver 14.x needed python ver
3.x binary
On Friday, January 24, 2025 at 02:14:56 PM EST, Adrian Klaver
wrote:
On 1/24/25 10:01 AM, Bharani SV-forum wrote:
> Adrian
> Thanks
>
> This is the exact error which the system admin is facing
>
>
> postgresql15-contrib
On Friday, January 24, 2025 at 11:22:23 AM EST, Adrian Klaver
wrote:
On 1/24/25 07:50, Bharani SV-forum wrote:
> Team
> Need your additional input.
> VM is based on EC2 OS Version = Amazon Linux 2
> Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM)
> Targe
pre.req version python ver 3.6
My unix admin, too quoted me to have it installed under OS RHEL7 w.r.to
postgresql - EC2 version Best Viable option. I have tried with previous
suggestion steps and found "pg_upgrade" as the most viable and faster
Regards
On Tuesday, December 31, 2024
: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 VMHowever you get it, use the newest version you
can. As of this writing, it is Postgres 17.2. Version 15 is okay, but going to
TeamI am in the process of upgrading EC2-PGS ver 13.X to 15.X I am aware
since ver 14.X, we have restriction in the usage of schema=public and the DBA
need to grant exclusive priv for the tagged db user's.
Assume i want to enforce it,Can i retag all the object
tables/indexex/packages/procedure
I am having heavy polling into the database and need to perform certain tasks
without any application interference.
On Friday, December 20, 2024 at 03:13:21 PM EST, Adrian Klaver
wrote:
On 12/20/24 11:25, Y_Bharani_mbsv wrote:
> Team
> I have the need to have postgresql db running i
:09, Bharani SV-forum wrote:
> Adrian
> Inline image
>
> initially i had created tblspace outside pg_data env variable
Did you run CREATE TABLESPACE as shown below?:
https://www.postgresql.org/docs/current/sql-createtablespace.html
Did you ever use the tablespace?
> e.g PG_DATA
10 | | 1664 | pg_global | 10 | |
not having any entry about tablespace abc_data
Can you guide
On Thursday, December 19, 2024 at 06:46:33 PM EST, Adrian Klaver
wrote:
On 12/19/24 15:36, Bharani SV-forum wrote:
>
> cannot drop a tablespace which never exists in p
cannot drop a tablespace which never exists in pg_tablespace
I remember i had create previously an tablespace named " mq_data" , but cannot
find in pg_tablespace listing.
if i try to create the same tablespace name, it is giving error as " already in
use as a tablespace"how to force drop the p
th different OS.
Thank you for guiding me
On Monday, December 16, 2024 at 05:49:28 PM EST, Adrian Klaver
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) 1
6 andlater 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 .
On Monday, December 16, 2024 at 05:19:31 PM EST, Adrian Klaver
wrote:
On 12/16/24 13:19, Bharani SV-forum wrote:
> Team
> I am g
linux 2023] ,
pgsql Ver 13.16 is not supported
I cross checkedSELECT oid, count(*) FROM pg_largeobject_metadata group by oid
order by oid ;Rows = 4260170 rows
Can you suggest
On Wednesday, December 11, 2024 at 03:57:31 PM EST, Adrian Klaver
wrote:
On 12/11/24 11:12, Bharani SV-forum
On Wednesday, December 4, 2024 at 12:04:47 PM EST, Adrian Klaver
wrote:
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
>
&g
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
TeamNeed help on clarification on using" set
session_replication_role "
Assume i am loggging intopsql and issue\o output.lstset
session_replication_role=defaultupdate coming out of \psql command and
verifying log fileand assume i come out of the psql session without doing set
session_r
: EC2 --> EC2, are they the same region?ans3: Right Question. I assume the
same region
Can you pl provide your insight now
On Monday, December 2, 2024 at 07:20:52 PM EST, Adrian Klaver
wrote:
On 12/2/24 15:52, Bharani SV-forum wrote:
> Adrian
>
> Proposed new Server is intended
9.0 and then propose to have the Postgres to be upgraded
from ver 13.16.2 to 15.10
Hope u have understood my question
On Monday, December 2, 2024 at 06:47:10 PM EST, Adrian Klaver
wrote:
On 12/2/24 15:41, Bharani SV-forum wrote:
> Ron/Adrian
> Thanks for your input.
> Your sugg
to
15.10
pl Vet the newer steps (revised version).
RegardsBharani
On Monday, December 2, 2024 at 05:48:19 PM EST, 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 SV-forum
>> mail
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-exis
Team
Need exact SQL query to find List of Detach Partitioned Tables (Yet to be
Dropped)
The following is the query which i used, i am using and i found an bug which is
listing an newly created table (last week)
SELECT relnamespace::regnamespace::text AS schema_name, relname AS table_name
FROM
21 matches
Mail list logo
