PostgreSQL (English)

Hi Team, I have enabled logical replication for Postgres to postgres database, which was working fine but now it is not working and showing wal status as extended when I am c...

Hello, how can I clear all triggers on a particular database in a single query ?

Hi Team, Can anyone help me with below requirement please? we have two rhel 8 servers in which we installed the postgres with a custom data directory path that is /u01/post...

Hello, I am doing research on the issues that need to be taken into consideration in order to have performance and best practice when creating database tables in applications...

Hi Community, I use patroni. I configure patronictl edit-config with LDAP authentication. My connections matches the wrong pg_hba line. I get this error : "password authenti...

Hi guys! How's it going? As an option to migrate a database from an RDS instance to another that has used AWS Database Migration Service (DMS), do you recommend it? Would the...

Hello I'm performing ora2pg migration there is blob data types in oracle, when I importing insert script in to postgres which is generated by ora2pg I'm getting this error ...

Hello everyone, How can I log who/when made a select query on a specific table ? I'm using PGAUDIT with pgaudit.log='write, ddl, role'. Since my disk space is limited, I do ...

Hi Everyone, Since I'm new to postgresql, I have a doubt regarding postgresql backup.. Why can't we run alter commands during pg_dump happening in the database ?

Hello everyone. When I want to restart my Postgres cluster, I get the following error: "Cluster is already running. Can't open PID file /run/postgresql/15-main.pid (yet?) af...

How to use plugins in postgresql ? Any video or relevant link for that ??

So I have a table with about 30 Billion Rows. I needed to insert 20 billion more. I have 2 indexes. One is a HUGE field (80 characters) and inserts are random. One is a simp...

Hey I’m looking for a tech advice: I want to estimate the # of rows in a resultset for an OLAP query before acutally running the query on a huge table. Motivation: return e...

Actually there are totally 1000 only, it taking 3 secs to fetch and print, shine joins are there, Need to fetch in milli sec , Any one can help me?

Any hints are there in postgres to fetch query fast ?

Hi.. we have been using C locale from a long time as we store data in different types of languages and C provides sort ordering even for different languages. In pg 14, we sta...

Is there anyone using Zabbix for postgresql monitoring?

Hi guys, I'd written an SP for user signup but I'm getting the wrong response 'user already exists' in the table, there is no user exists and I checked my SP but it looks lik...

Hello how are you friends? I need to know if there is any free tool that you have already used that I can use with Postgres versions higher than 10 like BI (Business Intellige...