PostgreSQL

13 Nov 2024 04:10

Yes. tomcat and hikaricp .. in hikaricp max_connection is 20 in 14 applications.
But I want to know from a postgresql perspective, how it creates connection and closes it. Suppose I write psql -U postgres.. it creates a new connection, now if I do \c mydb.. will it create a new connection or use the existing one?

PostgreSQL

12 Nov 2024 13:54

How connections are created in postgresql when connected by jdbc. In my case it suddenly reaches 800 where the max_connection is 1000. I don't know what's happening in the backend. If anyone knows plz help

PostgreSQL

12 Nov 2024 11:52

Configure both. If the replica fails to connect to the primary, it will fall back to fetching WALs from the archive (i.e., log shipping).

PostgreSQL

12 Nov 2024 10:41

If you have a standby server that recover using log shipping, it's going to restore getting archive files from the place that they were archived and apply them

PostgreSQL

12 Nov 2024 10:38

Log shipping, 16mb of lag, size of archive file

PostgreSQL

11 Nov 2024 19:21

In Postgres you can LISTEN for events. But those work very well.

This does NOT sound like a PostgreSQL issue.
At least not until you get down to the LISTEN / NOTIFY

PostgreSQL

11 Nov 2024 18:25

Please someone help me I need your help desperately . I have been trying to ask a lot of people and look up a lot of resources but none have worked so far

PostgreSQL

11 Nov 2024 14:58

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

09 Nov 2024 04:49

How to upgrade psql client from 11.x to 15.x on EC2 instance.

PostgreSQL

08 Nov 2024 17:06

Last 2 messages were copy and paste

PostgreSQL

08 Nov 2024 16:41

Same message of oom, without anymore data that you sent several days ago. Try giving more info

PostgreSQL

08 Nov 2024 16:31

Good job. Keep watching!

PostgreSQL

08 Nov 2024 13:47

I want postgre SQL notes

PostgreSQL

08 Nov 2024 12:52

Have you checked that pgagent daemon is working properly, I mean, daemon runs?, daemon have no errors?, then check property dialog that show you last run, last result..

PostgreSQL

08 Nov 2024 08:05

Hi, Can we discuss more?

PostgreSQL

12 Nov 2024 17:51

You probably have a client side connection pool (e.g. HikariCP) and configured that to use up to 800 connections. They usually default to actually use them if they get them 🤷‍♂

PostgreSQL

12 Nov 2024 11:53

N.B.: you should configure both anyway!

PostgreSQL

12 Nov 2024 10:44

i understand its possible to combine the two - log shipping + strearming.
how does it work and how i configure this?

PostgreSQL

12 Nov 2024 10:39

Everytime a wal file get full, is archived. And archiver is like copy from one directory to another place.

PostgreSQL

12 Nov 2024 10:27

Hi
I need some help understanding log shipping / streaming replication
streaming = streams wal records and apply on replica
log shipping = transfer the whole WAL file and apply on replica
so it means log shipping might have more lag?
how exactly does it work?

PostgreSQL

11 Nov 2024 19:08

What is related to postgres?

PostgreSQL

11 Nov 2024 18:25

Why am I not able to broadcast an event over a channel.I created event MessageSent. Had a private channels chat.$this->message->receiver_id.Then broadcasted the event in my sendMessage controller function by broadcast(new Message($message)).Started my reverb server debug mode.Wrote an Authorization route in channels.php.Also did some configuration in bootstrap/app.php regarding api token from sanctum. In database only jobs table is populated. But I dnt get the event in frontend.Yes I have run queue pho artisan queue:listen command as well

PostgreSQL

09 Nov 2024 08:15

I Need postgresql documentation file

PostgreSQL

08 Nov 2024 17:23

Well, you may start with the exact description of your tooling, query, the exact error message(s), explain of the query and so on.

A usual start of postgres debugging. Or anyother computer program debugging.

PostgreSQL

08 Nov 2024 16:45

Yes actually i am trying to reproduce this in test environment but enable to reproduce

PostgreSQL

08 Nov 2024 16:36

Any idea why this behaviour i am experiencing

PostgreSQL

08 Nov 2024 16:28

I have a PostgreSQL database cluster with two databases, both containing the same data. The difference between the databases is that one has a collation of ‘C’, while the other has a collation of ‘en_US.UTF-8’. When I run the same insert query on both databases, it executes successfully on the database with the collation ‘en_US.UTF-8’, but gives an Out of Memory (OOM) error when run on the database with the ‘C’ collation. Any idea why this behaviour

PostgreSQL

08 Nov 2024 12:53

IMHO I would use plain crontab or pg_cron

PostgreSQL

08 Nov 2024 12:04

Hi i am new to postgresql..installed pgadmin & pgagent in Centos OS .after scheduling the jobs they are not starting in pgagent. No error messages also .can some one help me .

PostgreSQL

08 Nov 2024 08:00

Hi we are hiring for contractual job opportunity with no pf for PostgreSQL (High priority)
Remote
Contract-3 TO 6 months
Exp-6-8 Years
Timings-12 pm to 9 pm IST
Contact 7233911117
chitra.vgemperts@gmail.com

JD-
Expert-level proficiency in PostgreSQL, including stored procedures, window functions, CTEs and subqueries.
· In-depth understanding of PostgreSQL database architecture, partitioning, scaling, performance tuning and optimization.
· Intermediate level experience with any one of the following- Kafka, Kinesis, Event Hub
· Intermediate level experience of Python programming language
· Ability to work independently and meet tight deadlines.
· Excellent problem-solving and analytical skills.
· Strong communication and collaboration skills.
· Self-driven and motivated
We request you to please check your resource pool and share the available bench resources matching the mandatory skillset