Stack Overflow
Stack Overflow

Questions tagged [postgresql-13]

Use this tag to indicate that your question is about PostgreSQL version 13. Questions concerning database administration should go to https://dba.stackexchange.com/

368 questions
1
vote
0 answers

Authentication Issues (KRB5\GSS)

We are looking to migrate some systems away from MSSQL. We have our first few environments built and currently using LDAP, which is OK but has a good number of flaws. I followed this link to setup Kreberos\GSS for the most part:…
obtix
  • 11
  • 2
1
vote
1 answer

PostgreSQL-13: Partitioning with overlapping ranges

I have a blacklist with certain strings beginning with the character '0','1','2',...,'9','a','b','c','d','e','f','?'. Then I create the following table: CREATE TABLE blacklist (concat TEXT UNIQUE NOT NULL) PARTITION BY RANGE (concat); Now I do…
0xfb
  • 13
  • 3
1
vote
2 answers

Find closest match to value in another table

I have a table_a with many rows and columns for each timestamp in PostgreSQL 13. I'm trying to find the row where the value in column X is closest to a benchmark value obtained from another table. This second table has only a single benchmark value…
HH16
  • 35
  • 6
1
vote
1 answer

RETURNING ... INTO: syntax error at or near "INTO"

I am trying to return the generated id into a variable so i can use it for inserting referenced values in other tables. The error does not appear when I delete the 'INTO foo_id_0' part. But this is kind of essential for waht i am trying to do. What…
ETPJ
  • 11
  • 3
1
vote
5 answers

only authentication clear text password and authentication md5 password supported for now. received 10

I am using npgsql for postgresql13, but when trying to connect I get the following error: only authentication clear text password and authentication md5 password supported for now. received 10 My connection line is: NpgsqlConnection conn = new…
Fernando Pulupa Pasquel
  • 33
  • 1
  • 1
  • 5
1
vote
1 answer

PostgreSQL - Does a single archive file contain information for only a specific database on a cluster or is it the entire cluster?

Note: this question is with regards to PostgreSQL version 13. On my Ubuntu server, I have a cluster called main which has 2 databases inside it (the first one being for a fruits company and the second one for a car company). Here are my…
theQuestionMan
  • 1,270
  • 2
  • 18
  • 29
1
vote
1 answer

archive_cleanup_command does not clear the archived wal files

Main question: archive_cleanup_command in the postgresql.conf file does not clear the archived wal files. How can I get it to clear the archived wal files? Relevant information: My OS is Linux, Ubuntu v18.04 LTS. Database is Postgresql version…
theQuestionMan
  • 1,270
  • 2
  • 18
  • 29
1
vote
1 answer

PostgreSQL 13 FATAL: password authentication failed for user "postgres"

I'm getting authentication error like below with a right password I put during the installation. Read similar questions and answers but couldn't find a working solution for version 13. Tried empty password and all default passwords too. Can someone…
roe
  • 299
  • 1
  • 3
  • 10
1
vote
1 answer

psql create user SUPER USER WITH password throwing syntax error message

I am trying to create a SUPERUSER PostgreSQL user with an encrypted password using psql. CREATE USER my_username SUPERUSER WITH ENCRYPTED PASSWORD 'MYPASS'; However the above command results in the following error ERROR: syntax error at or near…
Arya
  • 8,473
  • 27
  • 105
  • 175
1
vote
2 answers

How to execute Anonymous Block PL/pgSQL (PostgreSQL 13) from Npgsql 4.1.5.0 in C#

I have this anonymous block PL/pgSQL: DO $$ DECLARE secuencial INT; BEGIN SELECT MAX("CodigoFactura") + 1 INTO secuencial FROM "Factura"; IF secuencial IS NULL THEN secuencial := 1; END IF; RAISE NOTICE '%',…
Ejrr1085
  • 975
  • 2
  • 16
  • 29
1
vote
1 answer

Error Installing PostgreSQL - Copying compressed file NodeIndexOnlyScan.sh

When I try to install postgresql I receive this error message: I thought there was an error with installer, so I tried a PostgreSQL 12 installer, but same error in a different location: Even, I downloaded a new installer but nothing seems to work.…
Diego
  • 151
  • 1
  • 6
1
vote
1 answer

Extact match the trimming_text in the rtrim function

If I run the following query in Postgres or Snowflake, it will remove test from the end of the input string, even though the trimming text is best: SELECT rtrim('rtrimtest',…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
0 answers

Can not connect Postgres after sometimes

Its been a week that I can not connect to Postgres 13 server after some period of idle time (I do not connect to database for about 1 - 2 hours), although it's status is Active. I am the only one accessing this database right now using…
padjee
  • 125
  • 2
  • 12
0
votes
0 answers

Secondary postgres node cannot start as max_wal_senders differ from primary node

During the upgrade process both appliances will shut down and restart. During this time, when secondary and primary are both down and then come back up. The primary comes back up as normal but the secondary node will not turn on and postgres will…
psheth
  • 1
  • 1
0
votes
1 answer

I want to create in postgrest, on multiple columns. There are multiple columns which i want to filter

If customer put filter in the as of now query result is very slow. Do i need to create index on all the filter columns in a single index or individual columns. the big issue is sorting. Below is the query select it.conversation_id,…
pramod N K
  • 3
  • 2
1 2 3
…
24 25