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
-1
votes
2 answers

postgresql-10 : The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl" Check your Installation

I am new to this forum, i am facing this issue, where i get the below error. sudo -u shahid ./pg_ctl -D /root/pgsql10x/data/ initdb invalid binary "/root/pgsql10x/bin/pg_ctl" invalid binary "/root/pgsql10x/bin/pg_ctl" invalid binary…
-1
votes
1 answer

transform_geom: couldn't parse proj4 output string: projection not named

I recently upgraded my Amazon PostgreSQL RDS to version 10.3 but while fetching the projections I am getting error: ERROR: transform_geom: couldn't parse proj4 output string: '3857': projection not named CONTEXT: SQL function "st_transform"…
1 2 3
42
43