PostgreSQL

08 March 2025 08:11

Does anyone have project on online voting system using postgresql

PostgreSQL

06 March 2025 19:14

For 12.22 it’s working fine ldap same configuration but rhel 8 version pg 15.10 version not working and frequently disconnected and connecting

PostgreSQL

06 March 2025 16:55

Yes to all 3 questions?

PostgreSQL

06 March 2025 15:34

Q: did it ever work? Can you query your LDAP server using those settings with e.g. ldapsearch?

PostgreSQL

06 March 2025 12:16

recovery.conf / standby.signal are the files to identify from the PGDATA either it's master/replica?

PostgreSQL

06 March 2025 02:15

I changed the port number and started PostgreSQL in the command prompt... Then the error problem was fixed but only temporarily... When I exit and open it again the error comes back!!

PostgreSQL

05 March 2025 21:38

Mostly ok, unless you want to use primarily IPv6 (me)

PostgreSQL

05 March 2025 21:31

Mellanox is good until it doesn't work

PostgreSQL

05 March 2025 21:31

aa i found HP 656089-001 661685-001 649281-B21 Mellanox 40Gbps for 15$

PostgreSQL

05 March 2025 21:30

consider 40Gbps, its like 50 eur per card, but result is OUTSTANDING

PostgreSQL

05 March 2025 21:27

i had some datalake, i can tell that 10G is very slow, 40mostly but also not enough

PostgreSQL

05 March 2025 21:23

For clusters eh, unless you have huge seq scans or ingest 10gbit/s that you have to continuously sync, i wouldn't care

PostgreSQL

05 March 2025 21:21

is it a thing? like have to adopt new config for new network

PostgreSQL

05 March 2025 21:19

have you considered 10G?

PostgreSQL

05 March 2025 21:17

still need to migrate the rest of the building to that rack 😊

PostgreSQL

07 March 2025 10:11

And do you get any error messages in the PG log?

PostgreSQL

06 March 2025 19:13

Ldapserach I tried it’s not working

PostgreSQL

06 March 2025 15:36

Also, do your clients really give the fully qualified username, incl. the whole ou= path?

PostgreSQL

06 March 2025 15:29

Hi Team,
We are facing ldap authentication failed error in Postgres 15 version with RHEL 8 version Anyone can help this ? Due to this issue production migration is pending and the ldap config line pg_hba.conf

Hostssl all +emea.xxx 0.0.0.0/0 ldap ldapserver=emea.xxx ldapscheme=ldaps ldaptls=0 ldapport=3269 ldapprefix=“” ldapsuffix=“”

PostgreSQL

06 March 2025 08:12

Because I didn't mean the Postgres service. PgAdmin4 comes with its very own one...

PostgreSQL

05 March 2025 21:38

Then you'll find it lacking

PostgreSQL

05 March 2025 21:33

everything is good until it stop working, what is your experience with mikrotik?

PostgreSQL

05 March 2025 21:31

now start to think...

PostgreSQL

05 March 2025 21:30

Not when all the data has to go through the 2x6gbit HBA

PostgreSQL

05 March 2025 21:27

but from other side no need to aggregate everything together

PostgreSQL

05 March 2025 21:23

This doesn't mean i'm not gonna spend 15€ for each server to install a 10G card

PostgreSQL

05 March 2025 21:22

10G networking + good quality compression is incredibly nice for backups and bulk loads/exports and also when the disks are connected via network

PostgreSQL

05 March 2025 21:20

does there actual difference in pg cluster changes when run faster network? or it just became faster and that's it?

PostgreSQL

05 March 2025 21:17

so far it's random small switches everywhere, and poe injectors because there's no POE

PostgreSQL

05 March 2025 21:17

yea if power is not issue, i get it