I have a couple of microservices developed using spring boot and each has its own Postgres database. These microservices exchange data with a CDC mechanism prov
I wanted to check if there is a way to stop and resume PostgreSQL replication using pglogical? For some reason, if either the publisher or subscriber needs to r
I have a function that uses set_config with is_local = true to set a variable. Now I expected that a select statement using the variable with current_settings w
I'm trying to query against a schema called DOCUMENT in my postgres db using node-postgres. I can't seem to get a query to run against the specified schema. T
I'm having a problem with running unit tests in django while using ElephantSQL, when running command python manage.py runserver everything works just fine, I'm
I am using brew postgresql-upgrade-database to upgrade postgresql from 11.8 to 12 and migrate the data. The process failed with the following output Upgrading
I have a column with numbers - 1,2,3...100. 5 of them looks like 1_, 3_, 5_ So, actually I have 1, 1_, 2, 3, 3_, 4, 5, 5_, 6, 7, 8 ... I did the query: SELECT c
I have logged into my database as the database owner (a superuser as well) and have created a role_write role with nologin and noinherit flags. I've revoked the
Collecting psycopg2 Using cached psycopg2-2.9.3.tar.gz (380 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup
This script works fine when running on dbeaver, I can work with the new created temp table: SELECT someField INTO TEMP tmp_TableZZ FROM "_fdw
i'm trying to implement docker in my rails api but I keep getting this error PG::ConnectionBad: SCRAM authentication requires libpq version 10 or above. I've tr
I have a legacy Django project (django-1.1.29) and some tests in pytest (pytest-4.3.0), all running inside Docker. The database is PostgreSQL 10 and is a docker
.score.sh is given as #!/bin/bash pass=0; fail=0; if [ $? -eq 0 ];then worker=`ps -eaf|grep nginx|grep worker` master=`ps -eaf|grep nginx|grep master`
I have created Custom columns by SELECT 'CREATE VIEW myview AS SELECT ' || string_agg( format( '%I AS %I', column_name, co
PROBLEM: In an aggregate-state Axon SpringBoot application @AggregateIdentifier is of type UUID and PostgreSQL database column is of type UUID. When persisted o
I am new to web development in Python and would really appreciate some help. I am trying to set up psycopg2/peewee on WSL (Windows machine). In my Python code I
I have an issue with TransactionRollbackError: could not serialize access due to concurrent update while updating the table.I'm using postgres with odoo V13, th
I am writing a query to be used as databases view, it looks now like this: SELECT contact.*, contact_users.names AS user_names, contact_status.status_
I have a postgreSQL database set up in google cloud. To connect via SSL google cloud provides 3 .pem files, server-ca, client-cert and 'client-key'. I am using
Here is the specification of my PostgreSQL. PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit server_encod