Questions tagged [postgresql]
PostgreSQL is an open-source, relational database management system (RDBMS) available for all major platforms, including Linux, UNIX, Windows and OS X. Mention your version of Postgres when asking questions. Consider dba.stackexchange.com for questions concerning the administration or advanced features.
postgresql
169
questions
0
votes
0
answers
13
views
I have this error: directory "/var/lib/postgresql/data" exists but is not empty
I have this issue in context Docker when execute .yml file. this file execute
initdb: error: directory "/var/lib/postgresql/data" exists but is not empty initdb: hint: If you want to create ...
0
votes
1
answer
16
views
How to add permission to custom role in postgres to create index
I am currently creating a role for a particular database using the below sql script executed as master user (postgres).
CREATE USER customrole WITH PASSWORD 'mypassword';
-- removed CREATE ...
0
votes
0
answers
13
views
Quickfix/n App - Kafka - Missing messages in Kafka
First of all if I need to separate the post in multiple questions please tell me how to do it by preserving the diagram and general information. thanks
I implemented a dropcopy fix reader and ...
0
votes
1
answer
25
views
Springboot JPA postgres performance is slow
I have Springboot JPA integration with 2 databases. One is Oracle and the other is postgres 42.6.
I am fetching data from rest-api with 500 records in each request and saving it in postgres. Mostly ...
0
votes
0
answers
14
views
Materialized view with Postgresql/Hibernate/Panache
I have created a panache entity in Quarkus which map existing Materialized view. When I execute a refresh view from a test it's not work.
@Entity(name = "MY_VIEW")
@Immutable
@...
0
votes
0
answers
17
views
I can't open server in 0.0.0.0 instead it is working in 127.0.0.1 in while using Docker , Django and Postgres [duplicate]
I am a newbie to this.
settings.py file is:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'postgres',
'USER': 'postgres',
'PASSWORD':...
0
votes
1
answer
18
views
WARNING: there is no transaction in process (PostgreSQL)
I kind of ran into something interesting. I've executed a SQL script using pgAdmin as GUI. With both autocommit on and off respectably.
Executed script contains these statements as follows:
begin;
...
0
votes
0
answers
13
views
How can i generate the arrow function format typeorm migration file?
when ever i am generating migration file i am getting this kind of format
public async up(queryRunner: QueryRunner): Promise<void> {
await queryRunner.query(`ALTER TABLE "transaction&...
0
votes
0
answers
26
views
How to catch the PSQLException exception? [closed]
How to catch the **PSQLException ** exception? I am using Spring boot JDBCTemplate and it can throw a PSQLException exception. Using try-catch, I get this message from IDEA: "Exception 'org....
0
votes
0
answers
18
views
Why two queries with very different EXPLAIN plan cost estimate run in the same time?
I am trying to optimize the index of my table table. For this I have created two indices index_a and index_b.
When I run EXPLAIN plan. The cost for index_a reads as:
Index Only Scan using index_a on ...
0
votes
0
answers
16
views
DB2 to Aurora PostgreSQL Migration issues with trailing spaces
We are migrating the data from DB2 LUW to Aurora PostgreSQL database using AWS DMS.
For few tables we have a column with data type varchar(22) and the value of the column could end up having ending ...
0
votes
0
answers
8
views
How to Properly Create the Data Architecture for a PERN Stack Application?
I'm building a web application using the PERN stack, and I'm looking for best practices on how to design the data architecture.
I just did a basic pernTODO in order to practice my postgressSQL skill a ...
0
votes
1
answer
23
views
In pgloader loading csv file and i want to skip a row from file if specific column value is null
Loading csv file in pgloader using load file and I want to skip rows based on column condition for example if specific column value is null then i want to skip that row
Not able to get the approach ...
0
votes
0
answers
13
views
Navicat 16 Backup Error: 'column d.datlastsysoid does not exist' for Postgres 15.4 Database [duplicate]
I am using Navicat 16 to back up my remote PostgreSQL database, which is running version 15.4. However, during the backup process, I encounter an error that reads:
[ERR] ERROR: column d.datlastsysoid ...
1
vote
1
answer
59
views
INSERT rows that were missing for the UPDATE
I want to write a query that, if I was using variables, would look something like (pseudocode)
records = SELECT * FROM table_1 WHERE id = x
numberOfRowsUpdated = UPDATE table_2 SET column_1 = y WHERE ...