PostgreSQL

26 Dec 2024 15:30

Hi... Why on slave grow up pg_wal? On slave no slot replication, catalog pg_replslot empty, but pg_wal grow up to 100gb. (postgresql entrerprice 14)

PostgreSQL

26 Dec 2024 10:09

Create a logical replica to postgres 16 target and switch over application connection once db is in sync. That's the minimum downtime method.

PostgreSQL

26 Dec 2024 09:28

I think u need to first upgrade to 14 or 15.

PostgreSQL

23 Dec 2024 15:11

or source code if it’s easier to read code 🙂 we are Open Source, contribute back to Postgres and also happy to contribution
https://github.com/neondatabase/neon

PostgreSQL

23 Dec 2024 13:21

If there's no server, where is the data stored?

PostgreSQL

23 Dec 2024 13:10

yep, it’s here, we will fix redirect
https://neon.tech/postgresql/tutorial

thanks for telling about that, feel free to tag me if there are some issues related to Neon

and actually it should work:

❯ curl -v https://www.postgresqltutorial.com/
* Host www.postgresqltutorial.com:443 was resolved.
* IPv6: 2606:4700:3030::6815:3d16, 2606:4700:3031::ac43:cd29
* IPv4: 172.67.205.41, 104.21.61.22
*   Trying [2606:4700:3030::6815:3d16]:443...
* Connected to www.postgresqltutorial.com (2606:4700:3030::6815:3d16) port 443
…
< HTTP/2 301
< date: Mon, 23 Dec 2024 12:12:43 GMT
< content-type: text/html
< content-length: 167
< location: https://neon.tech/postgresql/tutorial
< cache-control: max-age=3600

PostgreSQL

23 Dec 2024 13:09

let me take a look and I will reach team responsible for that

PostgreSQL

23 Dec 2024 12:17

Simple use Google with logical replication on standby and some howto guide will be recommended

PostgreSQL

23 Dec 2024 12:14

Yes, but you need v16 at least

PostgreSQL

23 Dec 2024 11:52

postgresqltutorial.com got bought by some company named Neon?? :(

This is the last copy I can find - https://web.archive.org/web/20241009000549/https://www.postgresqltutorial.com/

Going to postgresqltutorial.com now redirects to https://neon.tech/postgresql/postgresql-tutorial :/

It was a nice website, especially for beginners.

PostgreSQL

20 Dec 2024 12:19

It's a odoo issue. Could you focus on what is the postgres issue in order to help you.

PostgreSQL

20 Dec 2024 11:13

https://nometa.xyz/

PostgreSQL

20 Dec 2024 06:45

https://theartofpostgresql.com/

PostgreSQL

19 Dec 2024 20:40

What I want is mostly books

PostgreSQL

19 Dec 2024 17:02

yeah, etcd is an important component to store info about each node to orchestrating the communication between nodes, but it won't work as a repo for pgbackrest at the same time

PostgreSQL

26 Dec 2024 11:10

I'll add that there are some talks about it on YouTube, like one from Gitlab. There a slightly different tools to do it and at least for me I think it's very informative to get to know how others did it

PostgreSQL

26 Dec 2024 09:28

Without doing this u can't directly jump to 16

PostgreSQL

26 Dec 2024 09:13

Hi All .. we have to upgrade Pg9.6 to 16 , DB size is 5 TB with minimum downtime. Any suggestion ?

PostgreSQL

23 Dec 2024 15:10

here is quick architecture overview: https://neon.tech/docs/introduction/architecture-overview

PostgreSQL

23 Dec 2024 13:17

Oh wow thank you! I'm a general PostgreSQL user, so I don't know about Neon, sorry if my message came out wrong way. I was just worried that the site got bought and like many take-overs, it will be discontinued.

Thanks for restoring the site. 🙌

PostgreSQL

23 Dec 2024 13:09

it wasn’t our goal, seems just some redirect is broken, we will keep that site running

PostgreSQL

23 Dec 2024 13:07

Never saw this before but neon has few good postgres hackers and contributors so I don't see a problem.

PostgreSQL

23 Dec 2024 12:15

How?
What changes or any documentation on it
Or link please

PostgreSQL

23 Dec 2024 11:54

Is this replication architecture possible
If then how?
Primary DB -> Streaming replica -> Logical replica
Want SR to be a publisher node

PostgreSQL

21 Dec 2024 16:41

We have postgres onprem as source and aurora as target and replicating via dms/msk, now the application looking for before image , we have enabled pk option only but it didn't help and now they wanted to enable replica identity full for ll the table's. I have read that if we enable replica identity full it will create more wals and impact the performance, is there any suggestions here?

PostgreSQL

20 Dec 2024 11:40

Database odoo17 not initialized, you can force it with -i base how can I fix this

PostgreSQL

20 Dec 2024 11:07

Hey guys anyone can help me in postgres problem?

PostgreSQL

19 Dec 2024 20:46

https://www.amazon.com/Mastering-PostgreSQL-deployment-optimization-strategies-ebook/dp/B0DQ4WQSC9/

I don't read books about postgres cause I can read source code and install everyday at work but I have attended Hans-Jurgen's talks in Postgres conference and he was one of the best speakers.

PostgreSQL

19 Dec 2024 19:04

cfp for 2025.pgconf.dev closes soon: https://2025.pgconf.dev/cfp.html

PostgreSQL

19 Dec 2024 17:00

Well, yes, ok. You should have a repo host. I guess your etcd tie-breaker will work.