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
1
vote
1 answer

psycopg2.OperationalError: FATAL: client authentication failed

I am getting below error, when trying to connect to enterprise DB, any information is appreciated. psycopg2.OperationalError: FATAL: client authentication failed DETAIL: no pool_hba.conf entry for host "xxx.xx.xx.xxx", user "enterprisedb",…
Sayantan Indu
  • 11
  • 2
1
vote
0 answers

unnest & scalar table function in Enterprise postgres

The below is the snippet where I pass a cursor as input paramter in Oracle. And Im trying to convert the same to EntepriseDB. create or replace FUNCTION FUNCTION_1 ( …
user1720827
  • 137
  • 1
  • 3
  • 15
1
vote
1 answer

How to avoid a big log file with WAL archiving?

I enabled WAL archiving in EDB Postgresql 9.6 for PITR, but now every time a 16MB log file is created and filling Disk volume. How do I avoid that? These are the changes made to Postgresql.conf to enable the wal archive: wal_level =…
SQLDBA
  • 13
  • 5
1
vote
0 answers

EXECUTE IMMEDIATE in Enterprise Postgres - query returned no rows error

I'm using Enterprise Postgres 9.5 with Oracle Compatibility. I have a problem with the EXECUTE IMMEDIATE command. Say I have a table with few columns and one of them can accept NULLs. If I do EXECUTE IMMEDIATE 'select null_col from '||table_name||'…
user1720827
  • 137
  • 1
  • 3
  • 15
1
vote
0 answers

DBLINK Between Postgres and EnterpriseDB

I have 2 databases, one of them (DB_1) is POSTGRESQL 9.3 on port 5432 and other one (DB_2) is Postgres EnterpriseDB on port 5444. I'm trying to create a view in DB_1 by creating a DBLINK between the 2 databases by running the following statement: …
Global Dictator
  • 1,539
  • 9
  • 24
  • 37
1
vote
0 answers

Pulling a timestamp across a database link from postgres to oracle

The company I work for is in the process of switching from oracle to EnterpriseDB and I'm trying to update a query that uses a timestamp from a table, but whenever I try to pull that timestamp it gives me: [Devart][ODBC][PostgreSQL]Invalid TIMESTAMP…
Eric B
  • 217
  • 1
  • 14
1
vote
0 answers

how to use the -skipFKConst option can only be given with -constraints option

I have used offline migration command to create an SQL scripts but I need to omit the migration of foreign key constraints. So I have used the below commands but getting this error : 'MTK-03000: General Error java.lang.NullPointerException One or…
sevanthi
  • 21
  • 2
1
vote
1 answer

Error when running postgresql function from java

We've recently switched over to using postgresql (enterpriseDB), and I moved a function over but when I run it I get: com.edb.util.PSQLException: ERROR: bind message has 2 result formats but query has 1 columns The function is: CREATE OR REPLACE…
Kynian
  • 660
  • 4
  • 15
  • 30
1
vote
2 answers

Which variant of PostgreSQL to choose for my .NET app.?

I want to use PostgreSQL for my standalone .NET Windows application. I downloaded PostgreSQL Advanced Server from EnterpriseDB's website and it is very smooth. The GUI also very good. But I suspect how along EnterpriseDB will support it. The second…
RKh
  • 13,818
  • 46
  • 152
  • 265
1
vote
1 answer

PSQL file execution

I am trying to execute a .sql file using UNIX command line for postgres 9.5. I have tried psql -s localhost -d postgres < filename.sql where postgres is the name of my database, as well as psql postgres username < filename.sql and also psql -af…
user3264659
  • 341
  • 2
  • 7
  • 20
1
vote
1 answer

Can postgres use an index when clause is a modulo

I've searched around for an answer to this, but the only reference I could find was an obscure forum post that suggested that operators, including % (modulo) were "sargable" (i.e. could use the index that the operator was operating on) However, we…
mrmoosehead
  • 145
  • 1
  • 8
1
vote
0 answers

PostgreSQL Service unexpectedly closing

using PostgreSQL 9.2 on Windows Xp(RAM 4GB) sometimes the Database service is closing unexpectedly. am new in PostgreSQL Database, So i cannot figure out the reason behind it, can any one help me ?! log 1 log 2 Current Backend Access…
user3814846
1
vote
3 answers

PostgreSQL / Ruby for commercial application

I am planning a web-based commercial application with front-end RoR and back-end PostgreSQL. I've some confusion about RoR and PostgreSQL Edition to use. For RoR, I have Aptana RADRails installed. For PostgreSQL, a free variant is also available at…
RKh
  • 13,818
  • 46
  • 152
  • 265
1
vote
1 answer

Issue in having a maven local repo dependancy for edb-jdbc jar

I am trying to create a simple maven project in java which connects to EDB and get the records from a table. But i am getting a class not found exception in the line, Class.forName("com.edb.Driver"); In my pom.xml, i am having the following…
user2851992
  • 11
  • 3
1
vote
0 answers

Unable to connect my android device to enterprisedb apache server

I am using enterprisedb apache server and I want to connect my android device to this local server installed on my laptop. I am certain that I'll need to change something in httpd.conf file but I'm not able to get the exact solution. my httpd.conf…
user3064103
  • 27
  • 7
1 2
3
4 5 6 7