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
28
votes
3 answers

Alter column set not null fails

Consider the following table with approximately 10M rows CREATE TABLE user ( id bigint NOT NULL, ... CONSTRAINT user_pk PRIMARY KEY (id) ) WITH ( OIDS=FALSE ) Then i applied the following alter ALTER TABLE USER ADD COLUMN BUSINESS_ID …
dimcookies
  • 1,930
  • 7
  • 31
  • 37
17
votes
1 answer

No getdate() function in EnterpriseDB PostgreSQL

Do you have any idea on how to have a getdate() function in EnterpriseDB PostgreSQL? I upgraded to EDB-PSQL, and when I try to restore old data from the free PSQL, it returns error on some tables since there is no getdate(). I believe this should…
Suezy
  • 1,071
  • 4
  • 13
  • 19
12
votes
3 answers

EDB Postgres server from local host Apache, Server is up and running The default Apache context is www in the Apache installation

I have been trying to get rid of postgresEDB apache HTTP server within my localhost and I am failing to do it. I have tried various options, including: netstat -ano|findstr :8080 and taskkill /pid number /F but failed, as everytime I re-start…
Santosh Ravi Teja
  • 247
  • 1
  • 7
  • 18
9
votes
2 answers

SCRAM authentication requires libpq version 10 or above in

I get an error when I try to connect to the Postgresql server with PHP, and I get an error like this one: Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above in I use EnterpriseDb, and is pg_connect();…
robby dwi hartanto
  • 425
  • 1
  • 4
  • 8
8
votes
4 answers

Windows 10 Kill EDB Postgres 8080 server

I want to kill and remove the software that uses the 8080 port that EDB Postgres localhost server so I can use the port for Jenkins. Using tasklist it tells me the port which is processing, fine for kill the process, but where can I delete uninstall…
noobnoob
  • 115
  • 1
  • 2
  • 6
7
votes
1 answer

Is the debugger plug-in not available for PostgreSQL 9.2 EnterpriseDB for Win7 x-64

I followed the installation notes C:\Program Files\PostgreSQL\9.2\doc\installation-notes.html Edited the postgresql.conf file shared_preload_libraries = '$libdir/plugin_debugger.dll' Stopped and Restarted the PostgreSQL service in pgAdmin Went…
Tim
  • 8,669
  • 31
  • 105
  • 183
7
votes
2 answers

Postgres Plus Cloud Database vs Amazon Relational Database Service (Amazon RDS)

The Postgres Plus Cloud Database was announced early this year. As I do not have a lot of experience on database clustering, I am wondering which one I should use. Can anyone give me a compare between Postgres Plus Cloud Database and Amazon RDS in…
leon
  • 71
  • 2
4
votes
1 answer

Copying Data from Oracle to Postgres

We have a daily process that pulls all data out of a number of tables in an Oracle database and imports them into a Postgress (EnterpriseDB) database - Version 8.4. We are currently using a java application to select * from each table, change the…
user739866
  • 891
  • 1
  • 9
  • 18
4
votes
3 answers

Connect by query

I'm storing hierarchical data in a table. When a resource is accessed by its hierarchical path (grantParent/parent/resource), I need to locate the resource using a CONNECT BY query. Note: SQL commands are exported from EnterpriseDB, but it should…
Karthik Murugan
  • 1,429
  • 3
  • 17
  • 28
4
votes
1 answer

Database migration from PostgreSQL to Oracle

I am migrating my database server from PostgreSQL to Oracle 11g. I tried various tools like Squirrel SQL. But most of the migration tools support table and views to migrate. I cannot find a solution to migrate my procedures and functions. What is…
Jeyasithar
  • 543
  • 4
  • 17
3
votes
1 answer

Postgresql jdbc driver vs EDB driver

What's difference between Postgresql driver and EnterpriseDB driver for Postgresql. It seems like the former doesn't support procedures and the later supports it. Anybody messed with executing callable statement with both the drivers ?
Stunner
  • 961
  • 2
  • 19
  • 39
3
votes
1 answer

when using functions on PostgreSQL partitoned tables it does a full table scan

The tables are partitioned in a PostgreSQL 9 database. When I run the following script: select * from node_channel_summary where report_date between '2012-11-01' AND '2012-11-02'; it send the data from the proper tables without doing a full table…
Bernard Brideau
  • 31
  • 1
2
votes
1 answer

Issue with UTL_MAIL.SEND_ATTACH_RAW function sending mail with attachment using EDB postgres

I am using the function SEND_ATTACH_RAW to send a mail with an attachment: UTL_MAIL.SEND_ATTACH_RAW( sender=>v_sender, recipients=>v_recipients, cc=>NULL, bcc=>NULL, subject=>'foto', message=> 'foto de prueba', …
Anthony Sotolongo
  • 1,395
  • 2
  • 9
  • 17
2
votes
1 answer

why does the transaction age of template0 DB increase in postgresql

why does the transaction age of template0 DB increase while it is never been used? datname | age | ----------------------+-----------+ template0 | 192232070
Rejo
  • 79
  • 4
2
votes
1 answer

PostgreSQL: Creating a Trigger that tries to do work on a non existing table

as we start to migrate our Application from using Oracle to PostgreSQL we ran into the following problem: A lot of our Oracle scripts create triggers that work on Oracle specific tables which dont exist in PostgreSQL. When running these scripts on…
Hammerfels
  • 21
  • 2
1
2 3 4 5 6 7