PostgreSQL

16 Nov 2024 12:58

YouTube have many postgres videos, choose some of them

PostgreSQL

16 Nov 2024 10:54

Rule 34 content, I suspect.

PostgreSQL

16 Nov 2024 10:52

What are you looking for from the videos in particular?

PostgreSQL

16 Nov 2024 10:49

I need postgresql videos

PostgreSQL

15 Nov 2024 13:57

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

15 Nov 2024 11:42

And can we get rid of the likes?

PostgreSQL

15 Nov 2024 11:33

Try running pg_controldata on your $PGDATA and see if that produces some reasonable results.

PostgreSQL

15 Nov 2024 10:01

Hi guys, i am facing this error when using pg_rewind ‘WAL segment size must be a power of two between 1 MB and 1 GB, but the control file specifies 131072 byte’
Any idea why ?

PostgreSQL

14 Nov 2024 11:49

## csv with header
$ psql -U$db_user -h$db_host -p$db_port -d DB_NAME \
  -c "\COPY TB_NAME FROM 'data_sample.csv' WITH (FORMAT CSV, header);"

## csv without header
$ psql -U$db_user -h$db_host -p$db_port -d DB_NAME \
  -c "\COPY TB_NAME FROM 'data_sample.csv' WITH (FORMAT CSV);"

## csv without header, specify column
$ psql -U$db_user -h$db_host -p$db_port -d DB_NAME \
  -c "\COPY TB_NAME(COL1,COL2) FROM 'data_sample.csv' WITH (FORMAT CSV);"

PostgreSQL

13 Nov 2024 20:42

pgagent might have died. you probably want to check if it's still running.

PostgreSQL

13 Nov 2024 12:02

Yes needs a bit of understanding of pgbouncer. It works best with these type of application pools. App developers usually spawn large number of kubernetes pods with significantly tiny connection pools (compared to good old days of bare-metal) and hence large number of idle connections. Session pooling isn't good enough for such mechanism. Generally those with managed services cope by scaling instance memory but if it's self hosted then pgbouncer is the way.

PostgreSQL

13 Nov 2024 09:33

What prevents you from using pgbouncer additionally to HikariCP? We use pgbouncer in transaction mode in addition to application connection pool. That keeps idle sessions under control.

PostgreSQL

13 Nov 2024 09:08

I'm not familiar with that. I suggest looking for more specialised or professional support

PostgreSQL

13 Nov 2024 08:37

(there is no reason to do so)

PostgreSQL

13 Nov 2024 08:35

Ok. As per my knowledge postgresql doesn't have an inbuilt feature to close idle connection (v12). I already set the max pool size and timeout setting in hicaricp. Still more than 1000 connections are idle . How to resolve this?

PostgreSQL

16 Nov 2024 10:55

I am an expert in Oracle, I want to differentiate between these two databases

PostgreSQL

16 Nov 2024 10:53

Actually, I need complete course videos

PostgreSQL

16 Nov 2024 10:50

We are not a search engine 🙃

PostgreSQL

16 Nov 2024 09:27

This company is real and trusted to trade with @TRADER_RILEY, I invested the minimum of $100 and  I got a return of $1,500 within 24 hours of trading, everything is 100% safe, this is an opportunity to start making money just click on the link below to get started

PostgreSQL

15 Nov 2024 11:54

Spammers are getting smart gosh..

PostgreSQL

15 Nov 2024 11:40

All: apparently @Jasmine_dgFVvfK liked a lot of stuff, which I can neither remove nor ban her (she's not in the group apparently). I apologize, and maybe some other admin has a clue how to get rid of that kind of spam?

PostgreSQL

15 Nov 2024 11:01

Your pg_control is probably a garbage.

(Or you are pointing pg_rewind to something that's not a postgres).

PostgreSQL

14 Nov 2024 12:02

Hi people
Does any one need Postgres job support or interview support please ping me

PostgreSQL

14 Nov 2024 11:05

How to migrate data from csv file to aurora postgres

PostgreSQL

13 Nov 2024 12:17

I am new to Postgres.Postgres was installed & working fine..pgagent is installed & jobs are created and scheduled.but the jobs are not starting as per the schedule..i tried simple insert statement also..it's also not at all working...if we run the same code in the query window.it's executing.No errors in error log also.we are using Centos OS.

PostgreSQL

13 Nov 2024 10:42

That's generally a good idea, however using transaction mode isn't trivial. Much less trivial than understanding one's own pooler config, at least 😏

PostgreSQL

13 Nov 2024 09:19

You have 2 datasources
40*14 = 560
20*14 = 280
That's 820 max connections. Apparently they get used enough in a round-robin fashion that they don't get earmarked as idle by the pools.
I reckon

SELECT now()-state_change FROM pg_stat_activity;

PostgreSQL

13 Nov 2024 09:00

spring.datasource.tomcat.initial-size=10
spring.datasource.tomcat.max-wait=30000
spring.datasource.tomcat.max-active=40
spring.datasource.tomcat.max-idle=5
spring.datasource.tomcat.min-idle=4

spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=20
spring.datasource.hikari.idle-timeout=100000
spring.datasource.hikari.max-lifetime=1000

This I already set but the problem persists. Could you please guide?

PostgreSQL

13 Nov 2024 08:37

Check your pooler, postgresql will not close idle connections

PostgreSQL

13 Nov 2024 08:32

Psql uses one connection and \c changes the current db but doesn't open any additional one