Stack Overflow
Stack Overflow

Questions tagged [enterprisedb]

EnterpriseDB (EDB) is the vendor of EDB Postgres Advanced Server, an Oracle-compatible variation of PostgreSQL, and associated tooling

EDB is a commercial vendor of products and services based on the PostgreSQL database. Use this tag for questions concerning EDB Postgres Advanced Server (self- or cloud-hosted) or the older Postgres Plus product (see also: ), as well as EDB-specific tools such as the EDB Backup and Recovery Tool and EDB Postgres Enterprise Manager.

For services, support, and other non-programming-related questions, please use EDB's customer support portal or contact EDB directly: https://www.enterprisedb.com/contact

Further reading:

105 questions
2
votes
0 answers

Error: Can not install PostgreSQL 9.5.11 on Windows 10 machine

So, I came across the same issue as posted here, BUT my error log says something different (see below, please). I have been trying to install PostgreSQL 9.5.11 on Windows 10 (x64) using Enterprise DB interactive installer. But, no success (I am…
khajlk
  • 791
  • 1
  • 12
  • 32
2
votes
1 answer

Cannot install PostgreSQL from EnterpriseDB due to error involving "getlocales.exe"

I am having trouble installing any of the Windows 64-bit PostgreSQL versions here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads I keep getting the same error: There has been an error. Unknown error while running…
Teuszie
  • 74
  • 1
  • 6
2
votes
0 answers

PostgreSQL EDB installer's post-install step fails

I'm using Ubuntu Budgie 17.10 64bit. When trying to install PostgreSQL 9.6 by EDB installer, and it fails on post-install step: Below is that part of the log file, where something went wrong. Initialising the database cluster (this may take a few…
Illia Ananich
  • 353
  • 4
  • 16
2
votes
1 answer

How to determine if a PostgreSQL connection is to Postgres or EnterpriseDB

My current programming project has me accessing a PostgreSQL database in Python3 using psycopg2 library. Although everything is going well, I am finding there are subtle differences between the open-source PostgreSQL and the EnterpriseDB version…
Ben Russell
  • 127
  • 1
  • 6
2
votes
1 answer

Adding JSON-C to existing POSTGIS install

Using EnterpriseDB's GUI installer, I installed Postgres 9.3.5 on my Mac running Mavericks. I selected the option to install spatial components and PostGIS 2.1.3 was installed automatically. After enabling the PostGIS extension, I was able to…
Don
  • 21
  • 3
2
votes
0 answers

Postgre SQL : Timeout while getting connection from connection pool

I'm facing problem of connection timeout in postgres SQL. I across lots of forums but none had helped me till now. Website works fine for some connections but when a user keep pressing on fatch data button the no of connections gets increased and…
Aijaz Chauhan
  • 1,511
  • 3
  • 25
  • 53
1
vote
1 answer

plpgsql in EDB: SPL procedure with SPL-style OUT parameter or a function cannot be invoked using CALL in PL/pgSQL

I'm trying to run natively correct plpgsql code in EDB environment. Unfortunately there is a problem. Interestingly, the first run does not generate an error. Restarts generate an error, but after a few repetitions, there is no error again. In…
Peter
  • 11
  • 1
1
vote
1 answer

Develop with Postgres Plus and Deploy Postgresql Open Source?

According to the answers in this comparison question, there's no technical difference between the core PostgreSQL engine and Postgres Plus server from EnterpriseDB. The developer license is only $95/seat. Their development tools look quite…
Andy Dent
  • 17,578
  • 6
  • 88
  • 115
1
vote
1 answer

What is the alternative of PL/Java for PostgreSQL 11 and 12?

Understand from: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/EDB_Postgres_Advanced_Server_Guide.1.80.html that PL/Java is deprecated in Advanced Server 11 and will be unavailable in server versions…
Jacky
  • 11
  • 1
  • 4
1
vote
1 answer

Cannot install plpython for postgres 12

First off , my question is posted after reading many other questions like this one Install PL/Python on Windows for PostgreSQL 12 and various trials of previous methods and comments. But I ve been stuck for about a month and half now when trying to…
jiquvox
  • 11
  • 3
1
vote
1 answer

How can I resolve this error "uncommitted xmin 1358613895 from before xid cutoff 1601650960 needs to be frozen"

I am getting the errors below in my postgresql log files. Seeking assistance on how to fix them. PostgreSQL version is 9.6 ==> postgresql-2020-03-10.log <== 2020-03-10 10:48:19 EAT|||ERROR: uncommitted xmin 1358613895 from before xid cutoff…
Kalema Edgar
  • 369
  • 5
  • 17
1
vote
3 answers

sysdate() causes Postgres to do ignore the Index and do a costly Sequential Scan

Anyone ever encounter this? Postgres Enterprise DB Advanced Server 11.5.12 sysdate() (Oracle proprietary) results in a Seq Scan of, in this case, 4,782 rows: EXPLAIN SELECT p.id, p.practice FROM PatientStatistics ps INNER JOIN Patients p ON…
Russell Brooks
  • 21
  • 4
1
vote
1 answer

Calling EDB Stored procedure(which is having output parameter) using EDB*plus from remote server

EDB plus is being used for the purpose of calling Enterprise Database procedure (EDB SPL), the return value of the procedure is to be captured in a shell variable. Need syntax and details for the same. The database is on a remote machine. I am able…
Pankti Vora
  • 11
  • 1
1
vote
1 answer

shell script has been retrieving from edbplus sql results with echo outputs

I am trying to call edbplus to count a table from a command-line linux shell script, but I have been retrieving from edbplus the response number with others outputs in the same response, I am trying to retrieve from it only an integer response…
Lucas Pires
  • 1,281
  • 14
  • 21
1
vote
0 answers

Shell Script getting terminated in the middle when unable to make DB connection

I have a function block as below which is getting called from somewhere. The call is happening fine but when it's executing any of the below psql check commands eg: local db_availability_check_88=`psql -h 10.95.187.88 -p 5444 -c "\pset tuples_only"…
Sandy
  • 11
  • 3
1
2
3 4 5 6 7