Stack Overflow
Stack Overflow

Questions tagged [postgresql-11]

For PostgreSQL questions specific to version 11.

PostgreSQL 11 is a major release of PostgreSQL RDBMS.

Key features center around performance, working with larger data sets, and ease-of-use.

Improvements includes, but not limited to:

  • Partitioning
  • Parallelism SQL Stored Procedures
  • Just-In-Time (JIT) Compilation Introduced
  • Window Functions Fully Support SQL:2011 standard
  • Channel Binding for SCRAM Authentication
  • User Experience Enhancements

More information regarding release available here.

553 questions
172
votes
18 answers

FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any in the…
Michelley
  • 1,739
  • 2
  • 8
  • 9
23
votes
3 answers

How to fix 'postgres.h' file not found problem?

I am trying to write a base type for PostgreSQL in C (using xcode), and I already installed PostgreSQL 11, but it seems that postgres.h cannot be simply included in the file ("'postgres.h' file not found"). Could someone tell me how to fix that…
Jasper Zhou
  • 449
  • 1
  • 5
  • 13
20
votes
3 answers

Function uuid_generate_v4() does not exist postgres 11

I am trying to use node-pg-migrate and run migrations to create tables in my node project. When I run migrations I get function uuid_generate_v4() does not exist. I did check in my extensions and uuid-ossp is available. extname | extowner |…
Rockr
  • 319
  • 1
  • 2
  • 11
16
votes
2 answers

Can a Postgres Commit Exist in Procedure that has an Exception Block?

I am having a difficult time understanding transactions in Postgres. I have a procedure that may encounter an exception. There are parts of the procedure where I might want to commit my work so-far so that it won't be rolled back if an exceptions…
Matthew James Briggs
  • 2,085
  • 2
  • 28
  • 58
13
votes
1 answer

Cannot execute ANALYZE during recovery

We have a insert only table for which we often get bad results due to query plan using nested loops instead of hash joins. To solve this we have to run ANALYZE manually (vacuum sometimes don't run on insret only tables, long story, not the point…
Damir Ciganović-Janković
  • 821
  • 2
  • 12
  • 30
13
votes
3 answers

Get table size of partitioned table (Postgres 10+)

I came across this query on Postgres weekly which shows tables, their sizes, toast sizes and index sizes in bytes: SELECT relname AS table_name, pg_size_pretty(pg_total_relation_size(relid)) AS total, pg_size_pretty(pg_relation_size(relid)) AS…
Damir Ciganović-Janković
  • 821
  • 2
  • 12
  • 30
12
votes
1 answer

Partition by date range PostgreSQL scans all partitions

I have a table partitioned per month (timestamp column). when querying the data, explain shows that all partitions are being queried when I'm constructing a date with date functions, whereas when I use hard coded dates only the targeted partitions…
Elger Mensonides
  • 6,930
  • 6
  • 46
  • 69
11
votes
3 answers

How to get cosine distance between two vectors in postgres?

I am wondering if there is a way to get cosine distance of two vectors in postgres. For storing vectors I am using CUBE data type. Below is my table definition: test=# \d vectors …
Anant
  • 3,047
  • 2
  • 27
  • 33
11
votes
4 answers

I can't start server PostgreSQL 11: "pg_ctl: could not start server"

I am in CentOS Linux release 7.5.1804 (Core) When I login as postgres and run: bash-4.2$ /usr/pgsql-11/bin/initdb -D /var/lib/pgsql/11/data The files belonging to this database system will be owned by user "postgres". This user must also own the…
VyR
  • 201
  • 1
  • 2
  • 13
10
votes
3 answers

PostgreSQL 11 configurations doesn't allow pgAdmin4 to connect

I'm pretty new to PostgreSQL so the question may be simple. So. I have installed PostgreSQL 11 and pgAdmin 4 on Fedora 29. I can connect to the database via terminal or AzureDataStudio, but when I try to connect with pgAdmin, I get this…
amiry jd
  • 27,021
  • 30
  • 116
  • 215
9
votes
2 answers

How to get result set from PostgreSQL stored procedure?

I created a stored procedure in PostgreSQL 11 to perform CRUD operation, and it works fine for 1. Create 2. Update 3. Delete, but while I run read command by passing Condition = 4 to select a result set, I get below error. I have used PostgreSQL…
Nafees Sardar
  • 133
  • 1
  • 1
  • 10
9
votes
3 answers

How to change/set the block size in Postgres? Is there any file to make the configuration?

I'm looking for the BLOCKSIZE configuration in postgres. I want to know is there a way to change/set the value?
Rajin
  • 93
  • 1
  • 3
9
votes
1 answer

PostgresSQL / pgAdmin4 / dump server version mismatch

I tried to make a backup with Postgres 11.1 in pgAdmin4, but it failed. pgadmin displayed a window with Status: Failed (exit code: 1). pg_dump:server version: 11.1; pg_dump: 10.5 pg_dump: aborting because of server mismatch I don't really…
black_hole_sun
  • 908
  • 11
  • 41
8
votes
3 answers

Convert from JS timestamp to Postgresql Timestamp with time zone

I have a simple t = Date.now; which goes to Postresql t_time column declared as timestamp with time zone via REST API. I got the error:date/time field value out of range. I can't use the answer from this post as I don't write raw SQL but use…
SharpBCD
  • 547
  • 1
  • 7
  • 25
8
votes
10 answers

Win 10 Postgresql 11 database cluster initialisation failed

i got a new laptop from Dell(XPS 15), with Windows 10 Pro. I have always the same issue During installation of postgres "Problem running post-install step. Installation may not complete correctly. The Database cluster initialisation failed." . i…
Hades85
  • 103
  • 1
  • 1
  • 10
1
2 3
…
36 37