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

19 Dec 2024 16:58

I was asking him, because in Patroni, u need to install pgbackrest in each and every node of patroni, then have a dedicated server for pgbackrest repository, and set the configuration to allow pgbackrest to take backup from patroni nodes, then finally u have to set the archive_command and restore parameters in patroni yaml files in each node, that's it so far I guess. Correct me if I am missing something, pls

PostgreSQL

19 Dec 2024 16:30

Hi everyone, I'm a beginner in postgres, do you have any recommendations like books to boost my skills in it?

PostgreSQL

19 Dec 2024 12:28

I know how to set up backrest in standalone...how about when we have ha setup

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.

PostgreSQL

19 Dec 2024 16:55

Patroni just manages Postgres. No difference there.
But you can benefit from pgbackrest in your Patroni config, e.g. for initial cloning etc. There are examples in the Patroni docs, check them out.

PostgreSQL

19 Dec 2024 15:06

You define pg2-* and decide if you want to backup_standby

PostgreSQL

19 Dec 2024 12:15

Do not automate basebackup, but rather use pgbackrest or other backup solutions