Re: oldest xmin is far in the past :: BUT xmin is not available in system

RNING: oldest xmin is far in the past Regards, BK On Tue, Apr 19, 2022 at 11:36 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > > > On Monday, April 18, 2022, bhargav kamineni wrote: > >> Hi Team, >> >> It seems vacuum is behaving somewhat weird on p

oldest xmin is far in the past :: BUT xmin is not available in system

Hi Team, It seems vacuum is behaving somewhat weird on postgres database , observing below HINTS on the vacuum logs WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. You might also need to commit or roll back old prepared transactions, or

Re: OID out of range

Any workaround to make it work ? On Thu, 16 Jan 2020 at 00:00, Adrian Klaver wrote: > On 1/15/20 10:18 AM, Konireddy Rajashekar wrote: > > I am getting ERROR: OID out of range while firing below SQL , what could > > be the reason? I am joining pg_class and one user_created table to > > compare t

Re: PMChildFlags array

s to be less, by the number of background processes we want to support. But it seems like a darn hard-to-hit bug, so I'm not quite sure that that explains your observation. On Fri, 4 Oct 2019 at 03:49, Tom Lane wrote: > bhargav kamineni writes: > >> What was the database doing

Re: PMChildFlags array

bhargav kamineni writes: > Postgres was rejecting a bunch of connections from a user who is having a > connection limit set. that was the the FATAL error that i could see in log > file. > FATAL,53300,"too many connections for role ""use

Re: PMChildFlags array

sword valid until infinity | > what could be the possible reasons for this to occur and is there any > chance of database corruption after this event ? The source(backend/storage/ipc/pmsignal.c ) says: "/* Out of slots ... should never happen, else postmaster.c messed up */ elo

Re: PMChildFlags array

Any suggestions on this ? On Thu, 3 Oct 2019 at 16:27, bhargav kamineni wrote: > Hi, > > Observed below errors in logfile > > 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 > 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array",,

PMChildFlags array

Hi, Observed below errors in logfile 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array","" 2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,,2019-09-20 02:00:24 UTC,,0,ERROR,58P01,"could not open shar

Re: pg_terminate_backend not working

minate those stuck process apart from restarting the database ? On Wed, 25 Sep 2019 at 00:05, Jerry Sievers wrote: > bhargav kamineni writes: > > > Hi Team , > > > > We are observing long running process hung in active state on one of > > our db from last two days

Re: pg_terminate_backend not working

Any thoughts on this ? On Tue, 24 Sep 2019 at 16:44, bhargav kamineni wrote: > Hi Team , > > We are observing long running process hung in active state on one of our > db from last two days with usename 'xyz', We have tried killing the > respective pid with pg_ter

pg_terminate_backend not working

Hi Team , We are observing long running process hung in active state on one of our db from last two days with usename 'xyz', We have tried killing the respective pid with pg_terminate_backned(pid), it's returning true but the quires are not actually being terminated. Based on the client address an

Extensions

Hi Team, I have a doubt regarding the extensions.My db has these many extensions Name --- adminpack btree_gist dblink file_fdw fuzzystrmatch hstore insert_username intarray pageinspect pg_buffercache pg_freespacemap pg_repack pg_stat_statements pg_trgm pgcryp

Re: log_min_duration_statement

uum statements? Nope, those are not autovaccum related logs , they are related to queries only. You have log_autovacuum_min_duration = 0 below. On Thu, 24 Jan 2019 at 20:53, Adrian Klaver wrote: > On 1/24/19 6:23 AM, bhargav kamineni wrote: > > Hi Team,, > > > > I have set lo

log_min_duration_statement

Hi Team,, I have set log_min_duration_statement=1000 as my configuration but when i observe log file i could see queries that ran below 1000ms are also getting logged , for instance duration: 0.089 ms duration: 0.175 ms duration: 0.139 ms duration: 0.451 ms duration: 0.136 ms duration: 0.340 m

Re: Capacity Planning

.postgresql.org/docs/11/high-availability.html";. > 5) The size of the budget for hardware and manpower. > > Allan. > > On Sat, Jan 19, 2019 at 1:38 PM bhargav kamineni > wrote: > >> Hi Team, >> >> >> What are the check lists for doing capacity planning for a postgresql >> server ? >> >> Regards, >> BK. >> > > -- > Angular momentum makes the world go 'round. >

Capacity Planning

Hi Team, What are the check lists for doing capacity planning for a postgresql server ? Regards, BK.

Temp tables

Hi, What happens if we create and insert/update the data in TEMP tables , Does that data really gets inserted at disk level or at buffer level and what happens to this data after completion of the transaction ? Thanks Banu

Re: order of reading the conf files

Thanks a lot Stephen. On Thu, Dec 6, 2018 at 8:53 PM Stephen Frost wrote: > Greetings, > > * Thomas Kellerer (spam_ea...@gmx.net) wrote: > > Stephen Frost schrieb am 06.12.2018 um 15:52: > > > The regular postgresql.conf file is read first, then > > > postgresql.auto.conf and then pg_hba.conf an

order of reading the conf files

Hi, may i know the order in which postgres reads the configuration files like conf , auto.conf , hba ? and how does postmaster forks postgres , can we see that forking process in logfile ? Thanks, Banu.

Tool for comparing parameters

Hi Team, Is there any opensource or paid tool that compares postgresql database parameters? (NOT SCHEMA) . Thanks Bhargav K

Re: Slot issues

2018 at 02:54, Andres Freund wrote: > Hi, > > As I just wrote: > > On Mon, 15 Oct 2018 at 02:40, Andres Freund wrote: > > > Please try to quote properly. > > On 2018-10-15 02:45:51 +0530, bhargav kamineni wrote: > > Yeah i have used rsync , Got it now will in

Re: Slot issues

Yeah i have used rsync , Got it now will increase the max_replication_slots to high enough , Thank you Andres Freund :-) On Mon, 15 Oct 2018 at 02:40, Andres Freund wrote: > Hi, > > Please try to quote properly. > > On 2018-10-15 01:57:53 +0530, bhargav kamineni wrote: > >

Re: [External] Re: Slot issues

creating the replication slot? >> >> can you share the query? >> >> also pls share the content of the recovery.conf on the standby nodes >> (both currently running and currently not running). >> you can scribble company secret stuff. >> >> >> Re

Re: Slot issues

I got his on standby, could you please explain in detail about --*but that *on the standby* haven't set max_replication_slots high enough* . Thanks, Bhargav On Mon, 15 Oct 2018 at 01:50, Andres Freund wrote: > Hi, > > On 2018-10-15 00:15:53 +0530, bhargav kamineni wrot

Re: [External] Slot issues

gards, >> Vijay >> >> >> On Mon, Oct 15, 2018 at 1:02 AM Vijaykumar Jain >> wrote: >> >>> I guess max_replication_slots has to be greater than active replication >>> slots. >>> maybe you need to increase max_replication_slots to 3 to

Slot issues

Hi Team, I am getting this ERROR while starting my second slave server PANIC: too many replication slots active before shutdown HINT: Increase max_replication_slots and try again. max_replication_slots on my master is 2 and one of them is already active for another slave, do i need to increase

Re: Replication Issues

Ee are using 9.5 version, slot option -s is not available ,can I go with -X stream option ? On Fri 28 Sep, 2018, 12:01 PM Laurenz Albe, wrote: > bhargav kamineni wrote: > > Hi Team, > > > > I have configured replication using slot ,But it failed by throwing the > >

Replication Issues

Hi Team, I have configured replication using slot ,But it failed by throwing the ERROR *pg_basebackup: could not get transaction log end position from server: ERROR: requested WAL segment 00012C9D0085 has already been removed *, which is unexpected because i have created the slot on