PostgreSQL

01 Apr 2025 07:00

Hi https://www.postgresql.org/docs/current/

PostgreSQL

31 Mar 2025 23:58

Bye, "Nick"... impostor😎

PostgreSQL

31 Mar 2025 19:34

no words, wasted 3 hours

PostgreSQL

31 Mar 2025 19:33

Well, until you provide more details, no one can help you.

PostgreSQL

31 Mar 2025 19:32

the only thing that's different is the framework, cause pycharm plugin uses psycopg

PostgreSQL

31 Mar 2025 19:31

The error message is about the IP of the client not being listed in the HBA file. I highly doubt the driver is doing anything odd. But the IP address your server sees of your client would depend on a bunch of things, highly dependent upon your network setup.

PostgreSQL

31 Mar 2025 17:59

https://pastebin.com/1JUziLV7

im getting fucking crazy: asyncpg changing IP by itself ?!?!

PostgreSQL

31 Mar 2025 16:45

Does anyone has experience with Vanna AI?

PostgreSQL

31 Mar 2025 13:15

Wow, today everybody mistook us for a search engine textbox

PostgreSQL

31 Mar 2025 12:40

Checkout pgEdge or EDB BDR etc offering two active (primary) nodes. It's not a pure HA solution but something small database on low budget can opt for instead of a proper 3 node patroni cluster.
https://www.pgedge.com/products/pgedge-platform

PostgreSQL

31 Mar 2025 09:00

It has documentation. And it's really not that complicated, so please RTFM first, will you?

PostgreSQL

31 Mar 2025 08:22

Try https://github.com/the4thdoctor/pg_chameleon

PostgreSQL

31 Mar 2025 08:21

I have two physical server

PostgreSQL

31 Mar 2025 08:20

you can have 2 servers but you won't have orchestration, if one server is unavailable the master won't move to another server.
ideally you should have 2 physical or virtual servers for databases, and one is not powerful, well 2 cores 4 RAM

then you can solve it with orchestration

install ETСD on all these 3 servers
install Patroni + Postgresql on two for DB servers

PostgreSQL

31 Mar 2025 08:14

https://www.postgresql.org/docs/current/pgupgrade.html

PostgreSQL

01 Apr 2025 04:30

Can you send postgresql performance tuning ebook if you have

PostgreSQL

31 Mar 2025 19:34

Welcome to computing

PostgreSQL

31 Mar 2025 19:34

let me tell what solved: not specifying the default port 5432

PostgreSQL

31 Mar 2025 19:33

im using asyncpg instead

PostgreSQL

31 Mar 2025 19:32

the network setup is fine: pycharm database plugin is working smoothly with the same credentials

PostgreSQL

31 Mar 2025 18:42

mb something, somewhere changed that?

PostgreSQL

31 Mar 2025 17:11

PostgreSQL Person of the Week interview with: Akshat Jaimini

https://postgresql.life/post/akshat_jaimini/

PostgreSQL

31 Mar 2025 13:23

PgEdge platform version is free.

PostgreSQL

31 Mar 2025 13:14

How to install pg_wait_sampling and pg_stat_monitor extension for postgres 15

PostgreSQL

31 Mar 2025 09:09

Ok, so some HA 101 first. To serve anything highly available, you have to be able to determine the cluster's state at any given time. If server A goes down, server B doesn't know if it's just a network disconnect, neither does it know if it's just his own network that is down, if it's A's network, etc.
So there *has* to be a server C that A and B talk to, serving as an arbitrator. Only when B and C *agree* that A is dead, they decide that B should take over.
Keywords for your google journey: "quorum", "stonith".
Or you just start reading the docs of e.g. Patroni or any other HA solution...

PostgreSQL

31 Mar 2025 08:23

I'm going to test vip manager Cybertec do you have good tutorial?

PostgreSQL

31 Mar 2025 08:21

One leader and another replica

PostgreSQL

31 Mar 2025 08:20

I have copied a project from git which has mqsql database i want it in pgsql

PostgreSQL

31 Mar 2025 08:20

Any one who can help me to convert mysql to pgsql

PostgreSQL

31 Mar 2025 08:09

If you're upgrading to that version because you're using something like oldstable, you should be able to use pg_upgradecluster just fine, however we need more info to give you effective support