ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
An upgrade needs a compatibility check, a tested release and a recovery path. Which changes deserve particular attention before the new version reaches production?
The goal is to determine whether NetBox can automatically direct read‑only SQL traffic to a PostgreSQL replica without requiring administrators to define a custom database router, thereby lowering hardware or managed‑service costs for low‑traffic deployments. NetBox documentation shows that a read‑only replica can be used, but it requires setting DATABASES w
A performance change should improve the measured workload without sacrificing correctness or wasting capacity. Which measurements and bottlenecks should be considered first?
I have a problem with displaying my databse structure through Intellij's Data Sources and Drivers page. I can connect to my database which is hosted on a redhat server through using application.properties of my spring project: spring.datasource.url=jdbc:postgresql://192.168.0.38:5432/cms_database which works fine. Although, whenever I try to use Intellij's D
On a running PostgreSQL 13 instance, I tried modifying it's wal_level system setting as follows, but it's not being respected: postgres@localhost:postgres> SHOW wal_level +-------------+ | wal_level | |-------------| | replica | +-------------+ SHOW Time: 0.021s postgres@localhost:postgres> ALTER SYSTEM SET wal_level = logical; ALTER SYSTEM Time: 0.007
I have table for store file information. File content is stored in column (column datatype is bytea in PostgreSQL). Now I want to get file content size, based on bytea column data. In SQL Server, I am able to get by using below query: select convert(nvarchar(50),DATALENGTH(FileDataInVarbinary)/ 1048576.0 ) +' MB' as FileSize from Table_FileInfo Could you sug
I am trying to create a docker-compose stack with pg and pgadmin as follows, version: '3.1' services: pg-admin: image: dpage/pgadmin4 volumes: - /Users/pkaramol/Desktop/backup.tar:/pgadmin4/dvdrental.tar ports: - "8181:80" environment: PGADMIN_DEFAULT_EMAIL: user@domain.com PGADMIN_DEFAULT_PASSWORD: 1234 depends_on: - pg pg: image: postgres:12 volumes: - ./p
I created this first table named 'bookstore' where Primary Key is book_name: create table bookstore (book_name varchar primary key, author varchar, price decimal); I am trying to create a second table named 'name' where name is primary key. I want to make this primary key- author.name as a foreign key of bookstore.author. create table author (name varchar pr
I know that this question has been asked other times but I didn't find a solution to this problem! I downloaded PostgreSQL 13 with pg Admin 4 and when I open it for the first time after installation it asks me for the master password that I was asked to set during installation, after I give the master password and this gets accepted I try to connect to the d
java
docker