PostgreSQL

08 May 2025 09:35

You could check following document that it explains all the options for your case of use https://wiki.postgresql.org/images/a/ad/Hierarchial.pdf

PostgreSQL

08 May 2025 00:33

That's covered in the patroni docs, as it happens.

PostgreSQL

07 May 2025 23:33

Do we have document to convert existing cluster to Patroni?

PostgreSQL

07 May 2025 20:11

Probably school assignment, he can try id< 25001

PostgreSQL

07 May 2025 19:23

If possible can you share the pdf of this book

PostgreSQL

07 May 2025 19:20

https://m.media-amazon.com/images/I/61oTDTLV9mL._AC_UF1000,1000_QL80_.jpg

PostgreSQL

07 May 2025 18:44

Hi,
Create publication p1 for table t1 where id in (1,2,3,4,5,6......25000)
Is this only way to create a PUBLICATION with 25k IN list values? Are they any other way to create it?

PostgreSQL

07 May 2025 17:32

How about you stop mixing case at all? It's a recipe for trouble....

PostgreSQL

07 May 2025 15:25

How to learn PostgreSQL DBA stuffs, not finding good resources

PostgreSQL

06 May 2025 11:03

Any openings for PostgreSQL?

PostgreSQL

04 May 2025 20:48

Disk free space %, Wal size growth, txid exhaustion monitoring, replica lag, temp usage, query response time, table/index bloat. Usually cloud vendors provide a way to set those alerts, if self hosted then these things to could be put in a cron script.

PostgreSQL

04 May 2025 13:43

I guess simple bash script, cron & resend can do work

PostgreSQL

04 May 2025 11:35

Everything described was carried out properly, sir. I would be glad to receive further recommendations.🥹🤓

PostgreSQL

03 May 2025 15:00

Friends, if anyone has worked with data languages ​​other than JSON and YAML, please dm 🌷

PostgreSQL

01 May 2025 15:45

Crunchy provided several tutorial and demo environments https://www.crunchydata.com/developers/tutorials

PostgreSQL

08 May 2025 09:23

How would you rappresent a generalization class from an UML class diagram in postgres?

PostgreSQL

08 May 2025 00:27

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

PostgreSQL

07 May 2025 23:02

Can anyone share postgres commands document

PostgreSQL

07 May 2025 19:45

You can buy it: https://www.packtpub.com/en-us/product/postgresql-16-administration-cookbook-9781835460580

PostgreSQL

07 May 2025 19:22

I've only thumbed through this and it seems to be a great resource

(mentioned in Postgres website too)

PostgreSQL

07 May 2025 19:10

Unless your "id" is e.g. a branch id, you seem to have missed the point what these filters are for...

PostgreSQL

07 May 2025 17:40

I don't get it what you say. What is that recipe for trouble?
I'm just interested with truncating quotes. As I understand it cannot possible to remove.
Anyway, I rewrote model and migration files to set table name in lowercase for simplicity and working well.

PostgreSQL

07 May 2025 15:33

https://roadmap.sh/postgresql-dba

PostgreSQL

07 May 2025 15:13

Hello everyone! Since I cannot send an image but I send completion output:

psql (17.4)
Type "help" for help.

api=# table
"Articles"           "SequelizeMeta"      public.
"Articles_id_seq"    information_schema.

PostgreSQL

05 May 2025 09:50

Thank you for the info, there are a few health check params I haven’t heard about. I’ll search m up

PostgreSQL

04 May 2025 19:08

Wdym with “resend” ?

PostgreSQL

04 May 2025 12:27

This is indeed quite interesting, I would also like to view what db-operations one placed in such scripts.

PostgreSQL

04 May 2025 08:32

Hello All,

Hope you all are doing well.. !!
Need small help, I am looking for a database health check script for Postgres which can be scheduled on daily basis to check the database health and send over email if possible.
Additionally looking for some sheep script to remove old archives on day condition as part of database maintenance.

If someone has these scripts handy then request you to please provide on my mail :
amitpawar.dba@gmail.com

PostgreSQL

01 May 2025 15:53

Go to aws, click on EC2, launch your instance and select *free tier Ubuntu machine then Google "how to install postgres on EC2 ubuntu". After you done with set up Google "how to generate sample data in Postgres", after that Google to how to analyze data then do that. Google or chatgpt skills will take you far in life.

PostgreSQL

01 May 2025 15:36

Gotcha. Thanks a lot for the answer