PostgreSQL

28 Apr 2025 18:04

Does logical replication does the same or is that different?

PostgreSQL

28 Apr 2025 18:03

Is this called logical replication?

PostgreSQL

28 Apr 2025 18:02

If with "entire contents" you mean views, indexes and so on, then yes it replicates everything

PostgreSQL

28 Apr 2025 18:00

Then setup normal streaming replication /w wal archive

PostgreSQL

28 Apr 2025 17:22

PostgreSQL Person of the Week interview with: Adam Hendel

https://postgresql.life/post/adam_hendel/

PostgreSQL

28 Apr 2025 17:03

Hello, can anyone tell me the easiest way to replicate the entire postgres db including schema and other details? Are there any tools for doing that? Can it be done within a single machine with two postgres instances?

PostgreSQL

28 Apr 2025 08:06

Yes, you'll need to arrange a downtime after the OS switch to rebuild indexes that contain text columns.

PostgreSQL

27 Apr 2025 18:45

I use both, mostly the latter. dBeaver is nice because I can use it for many client DBs.
I use the Free version, leaving it behind on the various servers, in case I need to run scripts, or queries.
The upside is that I can copy my library of SQL queries over with it, and know what to run if I have to check something out. Visual reminders.

DataGrip is too big to install everywhere, and the license is really for my machine(s) and my use.
So that's how I use it. It has a ton more features and is my GOTO when I am NOT in psql on the command line.

The challenge when you work with 30yrs of clients... You have MANY DBs you've built over the decades.
And you want some level of familiar tools. I don't ONLY DO "PostgreSQL". I support a lot of different DBs.
Some written in the 1990s...

I burned through a LOT of tools at great expense over the years.

And sometimes it's not about me. It's also about the people I leave behind to manage stuff after my job is done.
But when they call me in. They don't need me installing a bunch of stuff so I can "have a look". So, I usually have my own account, and a login that gives me access to tools I am comfortable with.
YMMV (Your Mileage May Vary). But ALWAYS ask yourself. Will this be here in 10yrs?

PostgreSQL

27 Apr 2025 16:38

That kind of defeats the purpose of having automation in place to do dml in production.

PostgreSQL

27 Apr 2025 15:49

How do you put those edit in flyway, liquibase, ansible etc? 😉

PostgreSQL

27 Apr 2025 14:52

I'm always using psql as a DBA, for some development of writing sql code, functions, procedures, I use any client

PostgreSQL

27 Apr 2025 10:41

Yes, It's for lazy users who prefer edit instead of writing proper update statement etc. Not for DBAs.

PostgreSQL

27 Apr 2025 03:55

Recently few of my client moved their databases from MySQL to Postgresql. There they used phpmyadmin , I know security issue is also there but as per client need I setup phppgadmin there it’s fully functional. But at the same time I tried to use features which pgadmin offers eg we can open Psql and sql query tool side by side. To obtain this feature I tried to use it through web . I did all the things bit in the end it does not work on web , although whole installation process is there that how we can access pgadmin 4on web but it’s not running , does anyone faced the same problem with pgadmin 4

PostgreSQL

26 Apr 2025 23:29

It's a cool toolkit that does so much more than psql

PostgreSQL

26 Apr 2025 23:26

It has lots bugs and dashboard runs heavy queries in background. It's not used on any latency sensetive and large production databases. Also it's counter intuitive to provide it for non-DBAs who will struggle with ux. DBAs generally use psql, I don't know of any use case where anything apart from psql is needed for DBA.

PostgreSQL

28 Apr 2025 18:03

No, replication slots with log shipping

PostgreSQL

28 Apr 2025 18:02

Replicating that way means you can switch from one db to another seamlessly and apps will not even notice the difference

PostgreSQL

28 Apr 2025 18:01

Thank you. Does that replicate the entire contents of the db or just the tables?

PostgreSQL

28 Apr 2025 18:00

I want the replication to happen as changes are made to the db

PostgreSQL

28 Apr 2025 17:14

You can just copy the entire pgdata folder and config files

PostgreSQL

28 Apr 2025 09:18

Do we need to reinstall or install new postgres binaries on rehel 8.8

PostgreSQL

28 Apr 2025 07:38

Hello All,

Our organization is planning to upgrade the operating system from centos 7 to Rehel 8.8. Currently, postgres 14.9 is running on centos 7.

if upgrading the OS will impact postgres functionality?

PostgreSQL

27 Apr 2025 18:27

I don't use it as a dba, just for some small data in order to query the results. I was more curious about the other alternatives.

PostgreSQL

27 Apr 2025 16:00

If you want, you can do a "export to sql". You can open a table and play around with it, altering adding indexes and stuff, then you can obtain the sql that would be used to apply those changes.

PostgreSQL

27 Apr 2025 14:53

as a DBA, all u need is to use psql, no need for any clients to not overhead ur environment with unnecessary tools

PostgreSQL

27 Apr 2025 10:44

I'm gonna be lazy, you can keep editing your stuff manually 😎

PostgreSQL

27 Apr 2025 03:57

Thank you so much all for your quick and genuine advise , I loved this group and will share my experience too here

PostgreSQL

26 Apr 2025 23:30

Yes, you still have the various \d* commands to extract meta info about the database, but pgadmin makes it really fast and easy

PostgreSQL

26 Apr 2025 23:29

Editing tables interactively
Mass selection and export of data
Checking statistics and other values at a glance

PostgreSQL

26 Apr 2025 23:21

What do you use and why?