Stack Overflow
Stack Overflow

Questions tagged [postgresql-12]

For PostgreSQL questions specific to version 12.

PostgreSQL 12 is a major release of the PostgreSQL RDBMS.

Improvements include, but are not limited to:

  • performance improvements for partitioning and indexes
  • CTEs (WITH queries) are by default inlined for better query performance
  • JSON path queries per SQL/JSON specification
  • support for case- and accent-insensitive ICU collations
  • (stored) generated columns
  • extended statistics for “most common values”
  • page checksums can be enabled and disabled without initdb
  • authentication: support for encrypted GSSAPI authentication and LDAP server discovery
  • “pluggable storage” to add different table storage methods

More information regarding the release is available here.

554 questions
0
votes
1 answer

Postgres SQL function and trigger to insert record in another table

I need help to complete the following requirements: [x] Profile table with columns id, username, ... [x] Comment table with columns id, content, ... [x] CommentReference table with columns id, profile_id, comment_id, ... When a new comment is…
pedrobern
  • 1,134
  • 9
  • 24
0
votes
0 answers

PostgresQL query using index scan backward instead of index only scan

I'm running into something I cannot explain and I have been googling for a few days now and have not yet found the cause for my "problem" with the PostgresQL scheduler causing a (relatively simple) query to take massive amounts of time. Let's start…
Alex
  • 1,425
  • 11
  • 25
0
votes
1 answer

Is it possible to connect Debezium with Postgresql which is not in docker?

Currently I am using PostgreSQL 12 in my WSL2 environment, I wish to implement cdc with debezium and kafka. As I am a first timer to do this, My searched all tutorial showing this process with docker. In my case no issue with docker if it is not…
Saiful Islam
  • 186
  • 1
  • 3
  • 13
0
votes
1 answer

Change PostgreSQL log directory

How can I change the log directory from PostgreSQL 12? I need to change the default /var/log/ location to point to another disk location.
Shagoon
  • 11
  • 1
  • 5
0
votes
1 answer

How to solve postgresql connection problem while working remote server?

I have an Ubuntu 18 Server configured as a PostgreSQL 12 database server which should be remotely accessed. And I am connectiong to databae from my home using ip address. After I connected to database, I am running some queries. The responses come…
barteloma
  • 6,403
  • 14
  • 79
  • 173
0
votes
1 answer

Installing Postgresql 12.2 on SUSE Linux Enterprise Server 11 Patch 3 with --without-readline AND --without-zlib

I'm trying to install Postgresql 12.2 at SUSE Linux Enterprise Server 11 Patch 3. I run ./configure until there is some message Use --without-readline to disable readline support After that, I run ./configure --without-readline, until there's a…
ilham setiawan
  • 7
  • 3
0
votes
1 answer

Can I add same value for range partition in PostgreSQL-12?

CREATE TABLE tbl_prop_demand_dtls_mango PARTITION OF tbl_prop_demand_dtls_partition FOR VALUES FROM (28) TO (28); I got this error ERROR: empty range bound specified for partition "tbl_prop_demand_dtls_mango" DETAIL: Specified lower bound ('28')…
Niranjan
  • 57
  • 1
  • 4
0
votes
2 answers

How to monitor async streaming replica delay from the slave?

We have a system with PostgreSQL 12.x where all changes are being written to master database server and two read-only streaming async replicas are used to reduce load from the master server for read-only transactions that can deal with slight…
Mikko Rantalainen
  • 14,132
  • 10
  • 74
  • 112
0
votes
1 answer

Receive bytea with asp .net api

First of all, sorry for the probable English mistakes I created a table in my postgresql database using the entity framework. In edmx in the creation section I passed as bytea, however in the mapping I used binary (primitive type use is…
mribeiro
  • 197
  • 11
0
votes
0 answers

Facing Difficulty While Login into postgreSQL through cmd in Windows 10

I am new to postgreSQL.1st time i installed postgreSQL and then PGAdmin also. While installing i provided a password for default superuser "postgres" also. But i did not create any separate user with password. I also add the bin dir path in my…
kisan kumar behera
  • 1
  • 1
0
votes
1 answer

PostgreSQL UPDATE doesn't seem to update some rows

I am trying to update a table from another table, but a few rows simply don't update, while the other million rows work just fine. The statement I am using is as follows: UPDATE lotes_infos l SET quali_ambiental = s.quali_ambiental FROM…
Calil
  • 57
  • 2
  • 7
0
votes
1 answer

Peer authentication failed for user

I am using PostgreSQL-12 with ruby 2.7 & rails 6.0.3 on ubuntu desktop 20.04LTS whenever I try to rails db:create i get the following error FATAL: Peer authentication failed for user "postgres" Couldn't create the 'myap_development'…
bottles
  • 25
  • 7
0
votes
2 answers

Duplicate key value violates unique constraint (EF Core & PostgresSQL)

I'm building a Blazor App with dotet core 3.1, ef core 3.14 and postgres 12. Initially I had been using the mssql localdb that comes with Visual Studio to build the app and everything was going well, but then I changed over to postgres, ran the…
Fearthainn
  • 111
  • 1
  • 6
0
votes
1 answer

Error When Creating an Unbounded Child Partition in PostgreSQL

I am running Postgres 12 and following examples from a book titled PostgreSQL: Up and Running published by O'Reilly Media. I am trying to create a partitioned table group like so: CREATE TABLE logs ( log_id int GENERATED BY DEFAULT AS IDENTITY, …
bmfnerfherder
  • 3
  • 2
0
votes
1 answer

Postgresql v12 reference partitioned table to partitioned table but not with partition key

I've been trying to reference partitioned table in postgresql v12 but got an issue. The tables are partitioned by range on a date column, and the values for each partition are month delimiter (eg: FOR VALUES FROM ('2020-04-01T00:00:00') TO…
Coodie_d
  • 35
  • 6
1 2 3
…
36 37