Valid until

Hi team, I have a question about the "valid until" parameter in the "create role" command. I recently set a user's password validity to "2024-05-13", but despite this, the user is still able to connect to the database. Is this a bug, or is the "valid until" parameter just for identification

About postgres pg_upgrade

Hi Team, Could you please explain me how does pg_upgrade works one of my friends it works based on pg_restore I am bit confused

About rsync

Hi Team, I have primary and stand by setup in that customer using wal_keep_segment very low number and database size were also high so that cilent asking with me in order use pgbase backup can't we use rsyn Here my question is if the wal is is presented on primary and not in standby then rsync

PITR partial timing

Hi team, I m testing PITR 1.if I am doing full recovery what ever the new tables were create will not be appear how to handle it 2. I have given my logs which time log I have to choose for PITR partial recovery 2023-10-16 16:22:35 UTC [16561]: [13-1] user=postgres,db=postgresLOG: statement:

How to store query result into another table using stored procedure

Hi All, I have a table like below Create table if not exists digi_card( Digi_card_id varchar(100), created_date timestamp, updated_date timestamp, status varchar(50), reason varchar(50) ); Sample values: Insert into digi_card values ('ee4422', '2019-03-01 00:25:00',

Vacuum full issue

Hi All, One of my friend project they did vacuum full last week since one of the table column data type were CLOB after that activity the dev team found out some of the data were missing or corrupt (XML) , please explain me will vacuum full have any limitation like that? Thanks Ramakrishnan

How to select unique records in PostgreSQL

Hi All, I want to get the unique wallet_id from this table even it was repeated on multiple occasions I should calculate only once as well as if the wallet_id was calculated on previous month it shouldn't be calculate on next months create table student_id ( student_wallet_id int, card_id int,

Value Too long varchar(100)

Hi team, We are getting csv file from client to upload data in my db table , one particular column I. E clinet description column contains more than 100 character hence I am getting value too long varchar (100) so we decided to upload db only first 100 characters. How to use this thing in copy

About foreign data wrapper

Hi all, What Is the difference between dblink and foreign data wrapper? Thanks Ramakrishnan

Re: Postgresql acid components

Hi Adrian Thanks for your valuable reply. On Wed, 14 Sep, 2022, 01:11 Adrian Klaver, wrote: > On 9/12/22 09:34, Rama Krishnan wrote: > > Hi all, > > > > In ACID property which postgresql components is supporting it > > > > > > The database as

Postgresql acid components

Hi all, In ACID property which postgresql components is supporting it

Sub:column "" is of type bigint but expression is of type character varying

Hi All, I am having table name called tickets \d tickets Column|Type | Collation | Nullable | Default --+-+---+--+- id | bigint

Re:

On Tue, 26 Jul, 2022, 20:34 Adrian Klaver, wrote: > On 7/26/22 06:27, Rama Krishnan wrote: > > Hi all, > > > > How to take a table backup using directory format? > > pg_dump -d -U -t -Fd -f > > > I am having huge size of table when I am using a pg_dump i

[no subject]

Hi all, How to take a table backup using directory format? I am having huge size of table when I am using a pg_dump it tooks more time kindly suggest me

Re: Batch process

Hi Adrian, Thanks for the update. Is it possible to achieve 1 records deletion on every iteration because my original table contains 5M records during the deletion process it consumes more cpu and resources. On Wed, 20 Jul, 2022, 20:37 Adrian Klaver, wrote: > On 7/19/22 22:08, R

Batch process

Hi All, I am doing purge activity my sales table contains 5M records I am going to delete more than 1 year data (which was 3M) records so it was running more so I want to do batch wise deletion through plsql created or replace function data_purge() returns void as$$ Declare Begin Drop table

Function inside query status

Hi All, Is it possible to check the query execution status inside the function. created or replace function data_purge() returns void as$$ Declare Begin Drop table test_old; Create table test_old as select * from sales where bill_date

[no subject]

Hi , What type of temp database should i use to maintain logs or export logs? Thanks Rama-krishnan

How to get response message

Hi All, I am want to delete old records using function so my senior has function like below but I want to get response of this particular inside query wheter it is successful or failure How to get response of the function status create or replace function data_purge() returns void as$$ Declare

[no subject]

Hi, After pg_repack do we face any perfomancr issue or any other issues in production DB

[no subject]

Hi All, How to install pg_repack and use? Thanks RamaKrishnan

Re: Vertical partition

Thanks a lot. Which means normal primary key and foreign key relationship right can u pls send me any reference link On Sat, 7 May, 2022, 06:21 David G. Johnston, wrote: > > > On Friday, May 6, 2022, Rama Krishnan wrote: > >> Hi , >> >> Can you pls tell us

Vertical partition

Hi , Can you pls tell us how to do a vertical partition in postgresql Thanks RamaKrishnan

Performance issue questions

Hi all, It was a famous interview question If the table contains multiple indexes what kind of performance issue or impact will be there.

Doubt in pgbouncer

Hi All, What is the limit value for fixing connection timeout issues? As i searched in google and verified pgbouncer document client_login_timeout If a client connects but does not manage to log in in this amount of time, it will be disconnected. Mainly needed to avoid dead connections stalling

Re: Logical replication from Rds into on-premise

Awesome, thanks! Can you please share docs my Rds version is 12.3 On Tue, 27 Jul, 2021, 19:00 Miles Elam, wrote: > On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer > wrote: > >> >> Does RDS allow logical replication >> > > Yes, it does. I believe it was patched for v9.6, but v10 and above support >

Re: Logical replication from Rds into on-premise

gt; On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan >> wrote: >> >>> Hi all, >>> >>> I have a postgres server on Aws RDS no i want to replicate the data or >>> logical replication into the on-premise server. I have gone through DMS >>> pr

Logical replication from Rds into on-premise

Hi all, I have a postgres server on Aws RDS no i want to replicate the data or logical replication into the on-premise server. I have gone through DMS provides the service buy it pricing was high. Do we have any option or method to achieve this? Thanks RamaKrishnan

Re: Doubt on pgbouncer

orde. >> >> On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, wrote: >> >>> >>> Hi Team, >>> >>> How can I split read and write queries using pgbouncer >>> >>> Regards >>> >>> A.Rama Krishnan >>> >>>

Re: Doubt on pgbouncer

Thank you for the clarification. On Sat, 3 Jul, 2021, 23:20 Ben Chobot, wrote: > Rama Krishnan wrote on 7/3/21 8:35 AM: > > > Hi Team, > > How can I split read and write queries using pgbouncer > > > You do it with your application. Make a pgbouncer database for rea

Re: Doubt on pgbouncer

Hi Bruce Thank you for the clarification. Can you pls share any links or docs about my doubt that can be helpful for me further information On Sat, 3 Jul, 2021, 21:21 Bruce Momjian, wrote: > On Sat, Jul 3, 2021 at 09:05:58PM +0530, Rama Krishnan wrote: > > > > Hi Team, > >

Doubt on pgbouncer

Hi Team, How can I split read and write queries using pgbouncer Regards A.Rama Krishnan Virus-free. www.avast.com

Re: Query processing in postgresql

Thank you so much a drain Thanks Rama Krishnan On Thu, 15 Apr, 2021, 22:40 Adrian Klaver, wrote: > On 4/15/21 10:04 AM, Rama Krishnan wrote: > > Hi Guys, > > > > How the select statement has been processed in the postgresql > > https://www.postgresql.org/developer

Query processing in postgresql

Hi Guys, How the select statement has been processed in the postgresql Thanks RK

Import data from one instance another

? Thanks Rama Krishnan

Re: Doubt in pgbouncer

Yeah. Rob On Fri, 2 Oct, 2020, 05:14 Rob Sargent, wrote: > > > > On Oct 1, 2020, at 5:42 PM, Rama Krishnan wrote: > > > > Hi Friends, > > > > By using pg bouncer can we split read and queries > > > > Thank > > Rk > > Did you mean reads vs writes? >

Re: Doubt in pgbouncer

Yeah rob can we spilt read/write queries using pgbouncer On Fri, 2 Oct, 2020, 08:43 Rama Krishnan, wrote: > Yeah. Rob > > On Fri, 2 Oct, 2020, 05:14 Rob Sargent, wrote: > >> >> >> > On Oct 1, 2020, at 5:42 PM, Rama Krishnan wrote: >> > >> &g

Doubt in pgbouncer

Hi Friends, By using pg bouncer can we split read and queries Thank Rk

Re: Need a depth information about bloat

Thanks for your reply brother ✌ On Mon, 10 Aug, 2020, 09:47 Adrian Klaver, wrote: > On 8/9/20 8:01 PM, Rama Krishnan wrote: > > Hi Mentors, > > > > > > I am searching for an understanding of bloat in PostgreSQL > > > > What is bloat? > > > >

Re: Need a depth information about bloat

Thank you for the clarification brother  On Mon, 10 Aug, 2020, 09:47 Rob Sargent, wrote: > > > > On Aug 9, 2020, at 9:01 PM, Rama Krishnan wrote: > > > >  > > Hi Mentors, > > > > > > I am searching for an understanding of bloat in PostgreSQL

Need a depth information about bloat

Hi Mentors, I am searching for an understanding of bloat in PostgreSQL What is bloat? How does it work? What is the use of bloat? Limitations of bloat? Thanks Rama Krishnan

Re: Doubt in pgbase

Thanks, I'll check it out. On Thu, 6 Aug, 2020, 07:51 Ian Barwick, wrote: > On 2020/08/06 11:10, Rama Krishnan wrote: > > Hi Experts, > > > > > > > > Can anyone explain me how the pg base backup will works? > > Have you seen the documentation page? &

Doubt in pgbase

Hi Experts, Can anyone explain me how the pg base backup will works? Thanks Rama Krishnan

How does vacuum works in postgresql

Hi Experts, I read this tutorials blog on edb it says vacuum has three phases 1.ingest phase 2.pruning phase 3.cleaning phase Apart from this blog, no one has explained about the vacuum working I m getting confusion on each can anyone explain me

Re: Doubt in mvcc

and writes this value. As a result, the customer lost $100. Will u please provide more details Serialize is the solution to this issue. On Mon, 13 Jul, 2020, 14:12 Francisco Olarte, wrote: > Rama: > > On Mon, Jul 13, 2020 at 9:52 AM Rama Krishnan > wrote: > > I m preparing

Doubt in mvcc

Hi sir, I m preparing for interview one of the recruiter asked me mvcc drawbacks as i told due to mvcc it use more space and need to perform maintenance activity. Another one is the same data causes an update conflict because two different transactions can update the same version of the row. he