Stack Overflow
Stack Overflow

Questions tagged [postgresql-10]

for PostgreSQL questions specific to version 10

On 5 October 2017, PostgreSQL 10.0 was released. Major enhancements in PostgreSQL 10 include:

  • Logical replication using publish/subscribe
  • Declarative table partitioning
  • Improved query parallelism
  • Significant general performance improvements
  • Stronger password authentication based on SCRAM-SHA-256
  • Improved monitoring and control

Note that as of version 10, PostgreSQL has moved from 3 component version ids to 2 components, so 10.1 is a minor release.

The official documentation for this version is available at: http://www.postgresql.org/docs/10/static/index.html

632 questions
2
votes
1 answer

Snowflake null values quoted in CSV breaks PostgreSQL unload

I am trying to shift data from Snowflake to Postgresql and to do so I first load it into s3 in CSV format. In the table, comas in text could appear, I therefore use FIELD_OPTIONALLY_ENCLOSED_BY snowflake unloading option to quote the content of the…
Victor
  • 23
  • 6
2
votes
0 answers

PostgreSQL cannot work when opens SSL on Windows 10

I am not sure this topic will fit here but I don't know ask it where. I am trying to open the SSL of PostgreSQL 10.16 on Windows10. I read a lot of documents about creating an SSL certificate to PostgreSQL but documents spend on Windows 10 are rare…
Pham
  • 21
  • 1
2
votes
2 answers

unsupported frontend protocol 1234.5680: server supports 2.0 to 3.0

I am running confluence 7.9.1 and postgres 10 but when we start only postgres container it doesn't throw below logs unsupported frontend protocol 1234.5680: server supports 2.0 to 3.0 but when we start confluence with version 7.9.1 , postgres…
Samurai
  • 121
  • 1
  • 4
  • 15
2
votes
1 answer

ERROR: cannot deconstruct an array as an object

This question is the follow-up of this I have the following table with sample records: create table jtest ( id int, jcol json ); insert into jtest values(1,'[{"name":"Jack","address1":"HNO 123"}]'); insert into jtest…
MAK
  • 6,824
  • 25
  • 74
  • 131
2
votes
1 answer

Multi-column indices ordering by date and created_at exhibit strange behavior for different queries

On postgres 10, I have a query like so, for a table with millions of rows, to grab the latest posts belonging to classrooms: SELECT "posts".* FROM "posts" WHERE "posts"."school_id" = 1 AND "posts"."classroom_id" IN (10, 11, 12, 13, 14, 15, 16, 17,…
Andrew Smith
  • 1,434
  • 13
  • 29
2
votes
2 answers

In PostgreSQL , can certificate authentication and basic authentication(username/password authentication) co-exist at one time?

Can we configure both Basic authentication and Certificate authentication for PostgreSQL simultaneously for the same IP address of client. I think no , because they are 2 different authentication mechanisms and cannot co-exist at same time...…
MSTechnie
  • 175
  • 10
2
votes
1 answer

How can I force prefix "pg_" to create new user in postgres?

I have problem with postgres. It is possible to force prefix "pg_" to create user in PostgreSQL? For example: CREATE USER pg_admin PASSWORD 'qwerty'; I am using PostgreSQL 10.6
HOLz1919
  • 68
  • 5
2
votes
0 answers

How to Optimize PostgresqlSQL Query which contain INNER JOIN

I am trying to create a view which contain Suspicious order from a orders table. The condition for the suspicious order is, every new order(in an interval), which have "New Customer" tag and used the discount codes(_sdc_sequence) from a table…
Faseela Thayattuchira
  • 459
  • 6
  • 13
2
votes
1 answer

Postgresql : Index on partition table

I am from SQL Server background so very limited knowledge in Postgres. We have a partition table with more than 100 partitions based on clientid. queries to that table is being very slow so planning to create an index on that partition. I did refer…
VBAGuy
  • 172
  • 1
  • 9
2
votes
1 answer

Backing up postresql database in openshift to outside the pod

Looking for some guidance/best practice on how to back up a postgresql database running in an Openshift pod. I've come across this rsync solution for application data -…
bzo
  • 1,532
  • 7
  • 27
  • 40
2
votes
0 answers

Generated column from date column in postgresql 10

Having a problem with this, trying to add a column which returns the year from a date column in postgresql 10: This is my SQL ALTER TABLE stats ADD COLUMN year_ integer GENERATED ALWAYS AS (date_part('year', date)) STORED; However, this returns a…
Mark Mukamutala
  • 21
  • 3
2
votes
1 answer

PostgreSQL-10: query JSONB property with multiple types

Assume a table json_table with a column data (jsonb). A sample value would be {"a": [{"b":{"c": "xxx", "d": 1}},{"b":{"c": "xxx", "d": 2}}]} I used to run SQL queries like the following: SELECT data FROM json_table j WHERE NOT EXISTS (SELECT 1 …
Georgios Varisteas
  • 35
  • 1
  • 3
2
votes
2 answers

Postgres convert empty string to NULL

I run a Postgres database and would like to convert empty string into NULL. The following snipped should do this with all columns, but it isn't working. SELECT * FROM schema.table NULLIF(columnname,''); The error message is: ERROR: syntax error at…
Michael
  • 219
  • 2
  • 10
2
votes
0 answers

Postgres Database Import failing on zero-length identifier using btree ("") (Drupal)

Postgres database problem: I'm trying to import a Postgresql 10 database from a working* Drupal 8 installation and I'm stuck on this type of error: Error in query: ERROR: zero-length delimited identifier at or near """" LINE 1: ...ON…
UrsulaAntares
  • 51
  • 3
2
votes
1 answer

PostgreSQL: point-in-time recovery for individual database and not whole cluster

As per standard Postgres documentation As with the plain file-system-backup technique, this method can only support restoration of an entire database cluster, not a subset. From this, I understood that it is not possible to setup PITR for…
user3792812
  • 155
  • 1
  • 4
  • 13
1 2 3
…
42 43