CPU is 100% azure rds postgreSQL-11

Hi Team, One of our RDS postgresql -11 version CPU is drastically high continuously. we are unable to find what is causing. the server is 4Vcore 100 GB storage. is there any way what is causing the issue.? we have datadog integration with custom metrics. we have done all vacuum and analyze opera

Re: scram-sha-256 encrypted password in pgpass

, Jun 22, 2020 at 1:35 PM Pavan Kumar wrote: > >> scram-sha-256 encrypted passwords are supported in .pgpass file ? If yes >> kindly provide us an example. >> >> I am using below format and it is not working for me >> >> *pglnx1*:*5432*:

scram-sha-256 encrypted password in pgpass

jaMew==$rzSoYL4ZYsW1WJAj7Lt3JtNLNR73AVY7sfsauikweblk][=:Hxx/juPXJZHy5djPctI=*"* Please advise -- *Regards,#! Pavan Kumar--*- *Sr. Database Administrator..!* *NEXT GENERATION PROFESSIONALS, LLC* *Cell# 267-799-3182 # pavan.dba27 (Gtalk) * *India # 9000459083* *Take Risks; if yo

Re: install pgcrypto module to existing postgreSQL

PM Ron wrote: > IOW, you installed it from source instead of a package. > > On 9/17/19 4:18 PM, Pavan Kumar wrote: > > Hello Adrian, > > i have used configure command install postgres > > $ ./configure --prefix=/pgbin/11.2 --with-segsize=32 --with-pgport=5432 > &g

Re: install pgcrypto module to existing postgreSQL

to install pgcrypto module on > > postgres cluster. > > what is the way to install pgcrypt library ? > > > > please advise > > > > -- > > *Regards, > > > > #! Pavan Kumar > > --*- > > *Sr. Dat

install pgcrypto module to existing postgreSQL

advise -- *Regards,#! Pavan Kumar--*- *Sr. Database Administrator..!* *NEXT GENERATION PROFESSIONALS, LLC* *Cell# 267-799-3182 # pavan.dba27 (Gtalk) * *India # 9000459083* *Take Risks; if you win, you will be very happy. If you lose you will

how to understand checkpoint information in pg_control data

if I am wrong? Latest checkpoint's REDO WAL file:000300020097, to my understanding this wal file has the latest record lsn , from where recovery will start and rollover. please correct me if I am wrong ? -- *Regards,#! Pavan Kumar--

Re: configure multiple repository path in pgbackrest

been performed? 2019-06-05 19:36:32.826 P00 INFO: check command end: aborted with exception [055] [postgres@oralnx v2demo4448]$ here is my configuration On Wed, Jun 5, 2019 at 10:09 AM Ron wrote: > > > On 6/5/19 9:48 AM, Pavan Kumar wrote: > > Hello Experts, > > Is it possi

configure multiple repository path in pgbackrest

Hello Experts, Is it possible to configure multiple backup repositories in pgbackrest tool in one server? I am getting few issues with that. -- *Regards,#! Pavan Kumar--*- *Sr. Database Administrator..!* *NEXT GENERATION PROFESSIONALS, LLC* *Cell

postgres database complete recovery

er=> ltuser=> exit = >>>> validation results since we lost every thing, it only performed recovery till last available log in hotbackup. since we lost every thing, it only performed recovery till last available log in hotbackup. latest data in current wal log is lost and there we have test table. lost of latest wal file/log will give some data loss, need to find a way to have redundant copy on latest wall logfile -- *Regards,#! Pavan Kumar--*- *Sr. Database Administrator..!* *NEXT GENERATION PROFESSIONALS, LLC* *Cell# 267-799-3182 # pavan.dba27 (Gtalk) * *India # 9000459083* *Take Risks; if you win, you will be very happy. If you lose you will be Wise *