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
0
votes
0 answers

EDB Postgres Replication Server - Database connection cannot be added. Controller database is not initialized yet

I am using EDB Postgres Replication server to setup a replication for my EDB Advanced Server. Running it on 3 VMs using Centos 7. All have Advanced Server 13 installed. Creating a Single-Master Replication (SMR) Publication Server has been setup and…
Mark Davidson
  • 1
0
votes
1 answer

How to use the same equivalent of REGEXP_REPLACE(Oracle sql) in edb

I am migrating from oracle sql to edb and wanted to convert the regular expression replace, but i am not able to bring all the constraints to the edb equivalent. Could you please help. SET account_no = RTRIM (LTRIM (REGEXP_REPLACE (account_no,…
praveen kumar
  • 33
  • 6
0
votes
1 answer

Can a Java application connect directly to EnterpriseDB Advanced Server?

Team, I have a Java application that I want to access EnterpriseDB (EDB) Advanced Server. For example: myJavaApp => EDB Advanced Server v11 or does the connection look like this myJavaApp => Java Driver v42 => EDB Advanced Server v11 I have a high…
F. Fillmore
  • 3
  • 1
0
votes
0 answers

parameters on procedure (JDBC EDB)

I'm migrating application from Oracle to EDB, and I'm having some problems with stored procedures in packages. Supposing I have this type defined: CREATE TYPE public.obj_test AS ( version_in character varying(5), sessionid_in character…
sirsanchez
  • 1
  • 1
0
votes
0 answers

Some problem in Migrate MySQL database to PostgreSQL using EnterpriseDB Migration Toolkit

I understand you must be extremely busy with your new project, so I will just be brief. ​ I'm trying to convert my MySQL database to PostgreSQL using EnterpriseDB Migration Tool. My setup is as follows: Windows 10 x64 MySQL 5.6.33 EDB PostgreSQL…
shaking
  • 1
0
votes
0 answers

Escaping pipeline in PostgreSQL procedure varchar2

In a PostgreSQL procedure, a variable QUERY of type varchar2 holds a query string that is executed as OPEN resultset FOR QUERY; In QUERY there is a call to the function string_to_array(mystring,'|'). How do I escape '|' in the query string? I have…
S_S
  • 1,276
  • 4
  • 24
  • 47
0
votes
2 answers

sql profile option is disabled in EDB PEM TOOL

I am trying to activate sql profiler option in edb postgres. i have completed below prerequisites. -> installed sqlprofile rpm for edb -> added shared_preload_libraries = '$libdir/sql-profiler' in postgres.conf file -> Ran the sql-profiler.sql…
rajkishore patro
  • 78
  • 1
  • 5
0
votes
2 answers

LOG: connection failed during start up processing: user= database= FATAL: GSSAPI authentication failed for user "postgres"

I am trying to configure Kerberos for GSSAPI Currently I have two nodes One the KDC server (windows server 2016) and the the other is Postgres-server(Ubuntu). I have created Active directory on in kdc-server and create user with the name of postgres…
shanjay
  • 1
  • 1
  • 4
0
votes
1 answer

postgres service restart through batch script

i need postgres service restarts automatically when it crashed or shut down abruptly? I would like to do this batch script. I tried the following pg_ctl -w restart but it did not worked.
Maredi NaveenKumar
  • 21
  • 3
0
votes
1 answer

Multi-master replication with both snapshot and synchronization replication

We are setting up a Multi-Master replication setup using EDB Rep Server on Postgres. We are unable to create a Publication because some of the tables created by the Keycloak Application does not have Primary keys defined in them and Replication…
bjk7
  • 1
0
votes
1 answer

upgrade enterprisedb postgresl version

I installed EnterpriseDB postgresql version 9.3.12 on a CentOS Server by using the following steps. ./postgresql-9.3.12-1-linux-x64.run I now need to upgrade my postgresql to version 9.6. How can I do that? I know how to install a fresh enterprisedb…
Ashish Yadav
  • 1
0
votes
0 answers

Postgres Enterprise Manager - PEM worker agent continuously restarts

DB Host: Centos 7 DB Host PEM Agent version: edb-pem-agent v7.12.0-2.rhel7 DB Host DB Version: Postgresql v11.2 PEM HOST: Centos 7 PEM Host PEM Server version: v7.8 PEM Host DB Version: EDB Postgresql v11 Issue: After PEM Agent updated, the PEM…
mergos
  • 1
  • 2
0
votes
1 answer

PostgreSQL - getting an error when listing databases with message "ERROR: column d.daticu does not exist"

what could be causing the error below when listing databases in PostgreSQL. I have 2 clusters running on the same machine under different ports and different data directories. The command works fine when I connect to one of them but fails when I…
Kalema Edgar
  • 369
  • 5
  • 17
0
votes
0 answers

DB Link Query Taking Too much time

I have this query containing a dblink since I need to connect to another database and it seems so slow Is there any way to make it fast? In the other dblink query executing in Msec but once same query will be used in another server then its taking…
Deepak Patil
  • 17
  • 8
0
votes
1 answer

Support for EnterpriseDB in new (>5.0.0) flyway versions?

Flyway 5.0.0 Release Notes say: Important note for EnterpriseDB, Vertica, SolidDB, Phoenix and Greenplum: Support for these databases has been kept back and will be integrated later in the Flyway 5.0 series. You can keep using Flyway 4.2.0…
Joël Traber
  • 13
  • 1
1 2 3 4
5
6 7