Use this tag to indicate that your question is about PostgreSQL version 13. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-13]
368 questions
0
votes
1 answer
Convert JSONB Keys to Columns
I have a user table users containing id , name and information of type jsonb
User Table
id
name
information
1001
Alice
{"1":"Google","2":"1991-02-08"}
1002
Bob
{"1":"StackOverflow","3":"www.google.com"}
I have another Table having all…
Chess Knowledge
- 15
- 4
0
votes
1 answer
name list in PostgreSQL 13.0
list the name autors with the first name chris by alfabetic order
Tabela ESTRELAS
Nome da coluna Tipo Descrição
id INTEGER id do gênero
nome_estrela VARCHAR Nome da estrela de cinema (atores e atrizes)
SELECT nome_estrela
FROM ESTRELAS
WHERE…
dogo
- 3
- 1
0
votes
0 answers
how to configure a crashdumps/minidumps of the postgres.exe in windows for random crash?
I am trying to generate a minidump of the postgres.exe when it crashes.
I followed the postgres wiki, where it states that this function is already included in the new version of postgres. Only the step is to create a crashdumps folder and give it…
Sujeet Chaurasia
- 97
- 8
0
votes
0 answers
RDS Postgres "canceling statement due to conflict with recovery"
I using 3 RDS Postgres Instance (1 master, 2 slave, version 13).
And my Postgres config is using the default parameter group.
max_standby_archive_delay = 30s
max_standby_streaming_delay = 30s
Recently, the following error occurs frequently.
ERROR:…
0
votes
1 answer
What is the proper way of converting interpolated array of objects to a postgresql array of composite type?
I am using SQL functions to perform multi-inserts, but because they can't accept recordsets as arguments I have to convert them to an array first. It works fine for array of primitives because they can simply be cast with CAST (${value} as…
Biller Builder
- 303
- 3
- 10
0
votes
0 answers
can I tell pg_rewind -c to resolve restore command relative from target data directory?
Context
I have a pretty standard postgresql setup, with one main server and one hot standby.
I am testing a procedure to promote the standby server when the main server stops, and then turn the previous main server into a new standby.
When I call…
LeGEC
- 46,477
- 5
- 57
- 104
0
votes
1 answer
Postgres 13 taking long to shut down without any significant logs
TL;DR : PG taking long to shut down and I am unable to find the root cause or reproduce the issue.
PG major version : PG 13.
Full issue : For an operation, our workflow performs a couple of checkpoints before issuing the SIGINT to shutdown the DB.…
user5566364
- 173
- 2
- 12
0
votes
1 answer
How do you get conditional filters within query files?
I was using conditional template string interpolation before, which looked like this:
const queryArgs = {
type,
status,
}
const query = `
SELECT
id,
type,
status,
content
FROM
some_table
WHERE
${type ? "type =…
Biller Builder
- 303
- 3
- 10
0
votes
0 answers
Sudden drop in postgreSQL Memory
Version: 13.6
Hi ,
This is a 2 days old issue. Our Postgresql is hosted on AWS RDS Postgresql. Suddenly our free memory dropped from 1300 MB to 23 MB and swap memory increased from 150 mb to 12OO. MB. CPU was little high, read and write iops were…
Monika Yadav
- 381
- 2
- 12
0
votes
1 answer
Updating JSONB values while keeping not matching one
I have a project of Laravel with two tables
Variants
id | name | data (jsonb)
Devices
id | name | variants_id | data (jsonb)
Some of the values in Devices tables used from variant but it also has it's own values too.
So when we create a new device…
Zee
- 351
- 1
- 15
0
votes
1 answer
Why is directory pg_commit_ts empty?
I have installed PostgreSQL 13 and created a new database, a few tables and inserted data on those tables. I used transactions to insert data, but still pg_commit_ts is empty.
what is the function of this directory and why is it empty?
Monika Yadav
- 381
- 2
- 12
0
votes
0 answers
dbt link to postgresql@13 instead of postgresql@14
Since installing postgresql@14 I have encountered an unwanted isse. By running dbt locally I get an error, specifically by running dbt debug following error message appears:
Encountered an…
Albin
- 822
- 1
- 7
- 25
0
votes
1 answer
ImportError: psycopg2 for creating engine
I've been trying to create a connection to my postgres DB. By doing so, I get following error by running this code
import pandas as pd
import numpy as np
import os
from sqlalchemy import create_engine, text
from datetime import datetime,…
Albin
- 822
- 1
- 7
- 25
0
votes
0 answers
Why I got the next errors?
could someone help me with this error please:
Output for command: systemctl start postgresql-13.service
Job for postgresql-13.service failed because the control process exited with error code.
See "systemctl status postgresql-13.service" and…
MauricioNC
- 33
- 1
- 6
0
votes
0 answers
How can I get ldap-sync for postgres to grant the AD Group role to its group-members?
We are using ldap-sync (github.com/larskanis/pg-ldap-sync) to bring members of an AD Group into a postgres cluster as user-roles however the user role that is based on the AD Group is not being granted to the user role based on the AD Account that…
Orlando Colamatteo
- 97
- 9