PostgreSQL

22 March 2026 14:21

I always use wal_level logical in prod. Whatever benefits of minimum wal_level do not overpower flexibility of logical even at high dml rates.

PostgreSQL

22 March 2026 14:10

While I agree on that point.

That's it?

No comments on psql plug-ins?
Adding your own commands?

Do you use PSQL?

PostgreSQL

22 March 2026 14:05

will check this one!
same here - most are using promeheues+grafana

PostgreSQL

22 March 2026 10:35

Thanks @tzirechnoy
May I know which monitor tools you're using? I just found pg_dash but i wonder if there are better tools.

PostgreSQL

22 March 2026 10:13

I don't use docker or other automation, my pg runs on debian containers

PostgreSQL

22 March 2026 10:12

so you manually also backup the /etc?

PostgreSQL

22 March 2026 09:53

Why bother? Windows is just a dead OS at this point

PostgreSQL

19 March 2026 20:44

@unfoxo and @NickBluth (And any other power users)
Nik and I have been thinking about PSQL.
I tried twice to get the windows version to accept "readline" and got it "close".
But there are a FEW unacceptable issues.

Also, PSQL has zero extensibility, but the source code is decently organized.
Nik is experimenting with a rewrite in Rust (Using Claude + Agents).

I, OTOH, am strongly considering... Rewriting the existing PSQL into a Plug-In based architecture.
The existing functionality would be "Builtin" and not require any extra files. To be 100% Compatible.

But the overarching goals are to allow for plugins that could:
1) Add "\" commands (protecting from interfering with existing registered ones)
2) Add/Change the base "editing" of commands
3) Add Pre-Processing of commands, to support enhanced scripting (Likely requiring a --#!<fmt> header)
Nik has some interesting stuff working like this where template scripts can be created.
4) Add multi-buffer to the PSQL terminal so you can swap out, and do \d <table>
5) Add an error handler, with edit and rewrite on a bad query to correct it...
6) Potential AI or other tool integration (LSP for auto complete)
7) A plugin that lets you use the PLPGSQL Breakpoints and trace the code
8) etc...

But the ultimate goal would be to have an object file that could be wrapped and used by another program (like VIM) where it can load this as an API to hit PG. Without losing any core things that PG lets you do (Unless you specifically turn them off).

You no longer have to recreate everything PSQL does. You could write only the add-on features you want. And keep all of the base PSQL functionality as your starting point.

But the GOAL is to rebuild the maintained version of PSQL in this manner.

And over time, systems wrap this as their terminal approach to getting to PG?

So, PSQL only needs to support what it supports today. It can be externally grown/modified.

Obviously PSQL -X... Type option to NOT LOAD any plugins...

Thoughts? Issues? Ideas? Suggestions???
(Including, how do you think the Hackers will respond to this idea?)

PostgreSQL

17 March 2026 07:46

Please explain what is (MVCC) in posgre

PostgreSQL

16 March 2026 08:42

It's easier to convert physical replica to logical using pg_replication_slot_advance (before pg17) and skip initial sync.

PostgreSQL

16 March 2026 07:43

I mean technically that might work but only if you can pause the original DB until you are finished and can start the subscription.

Probably the way to go if you are CPU-limited on the replica is to remove indexes and then re-add them later. Or add entirely new ones. The indexes can differ, it's just the definition of the columns you copy that has to be at least compatible, IIRC.

PostgreSQL

12 March 2026 15:31

hey, anyone here is a Russian? could anyone from Russia dm me? I received a VN in Russian, which I don't understand

PostgreSQL

04 March 2026 02:19

PgAdmin will let you set breakpoints in the code and trace through them. I would NOT do this on a production server.

We created a routine that lets us turn ON and OFF NOTIFY output.
And we put the LOGGING code in the procedures. When it's off, it simply returns.
When it's on, we get the output messages to the console (and optionally can be logged to the postgresql.log).

But good luck. Nothing FREE that I know of has implemented the debugger piece...

PostgreSQL

03 March 2026 23:20

I never tried that, thanks for mentioning it

PostgreSQL

03 March 2026 22:27

Unless you work with GIS data. I like how pgadmin shows me a map of the items in my database, that is how I found errors before even trying to display the data on a map myself.

PostgreSQL

22 March 2026 14:14

I do use psql, but i find it already well done and complete for my needs. The console is limited compared to a GUI solution, i wouldn't know what to add to be honest

PostgreSQL

22 March 2026 14:06

this conversion means i will also need to restart the master in order to change the wal_level right?

PostgreSQL

22 March 2026 11:34

*i do not know and do not claim it is better or something like against the others. Maybe, zabbix is worse as I don't like zabbix....

In fact, most most of my friends do work with prometheus/grafana just fine.

PostgreSQL

22 March 2026 10:22

1) Yes, I'm nearly always backup /etc on my servers.
2) No, usually postgres configs are restored not from backups — they are saved in git with comments as the other code.

PostgreSQL

22 March 2026 10:12

I usually backup the entire system, except the data folder, so that when i restore i can do:
- restore the container/vm to have a ready made OS image running
- restore the data

PostgreSQL

22 March 2026 09:55

/etc part is stored in git and unpacked after restore (sometimes port and binding ip is corrected after that).

PostgreSQL

22 March 2026 09:51

by default the postgresql.conf is usually set to /etc
when you guys use pg_basebackup do you also copy the conf files manually or you just change the conf files to be part of the $PGDATA?

PostgreSQL

17 March 2026 08:27

I think this might give you a good start -> https://www.postgresql.org/docs/current/mvcc-intro.html

PostgreSQL

16 March 2026 08:43

https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/

PostgreSQL

16 March 2026 08:34

I would only need to stop the master in order to change wal level to logical no? I couldn't find anything online about this. Only the options of dump-restore and copy

PostgreSQL

16 March 2026 07:19

Question regard logical replication in version 13 - how do I make the initial copy for large DBs? Is it possible to make the replication from a pg-basebackup/a snapshot of the master machine?

PostgreSQL

04 March 2026 05:37

i use standard c debugger in vscode

PostgreSQL

04 March 2026 01:34

Hello Everyone,
What is the best free tool for debugging PostgreSQL functions and procedures?

PostgreSQL

03 March 2026 23:19

datagrip shows map as well

PostgreSQL

03 March 2026 22:25

psql is enough for any dba use case and pgadmin runs unnecessary queries for monitoring which is harmful at scale. Overall gui is trash, connection is counter intuitive for newbies. There are better options for gui addicts like dBeaver, datagrip etc