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

Using psql option

#version: ppas 9.2 #pg_hba.conf local edb,testdb enterprisedb trust local edb user1 trust local edb user2 trust local all all md5 #pg_env.sh PGDATABASE=edb When I type psql, I will connect to the edb database as an enterprisedb user without…
김소영
  • 1
0
votes
0 answers

Why do I get this error message when running 'yum install edb-as11-server'

I have followed the instructions for edb installation on centos7: yum install -y https://yum.enterprisedb.com/edbrepos/edb-repo-latest.noarch.rpm edit /etc/yum.repos.d/edb.repo file, To enable a repository, change the value of the enabled parameter…
taohe2
  • 1
  • 2
0
votes
2 answers

PostgreSQL PL/Python could not load library plpython3u

I am trying to install the PL/Python extension for PostgreSQL. Executing the command CREATE EXTENSION plpython3u; results into the following error message: ERROR: could not load library "C:/Program Files/PostgreSQL/11/lib/plpython3.dll": The…
Sens4
  • 605
  • 1
  • 11
  • 29
0
votes
1 answer

Is there a way to list stored procedures and functions source with parameter definition in EDB Postgres using a SQL against the catalog

I want to list all procedures and functions in EDB Postgres with their input & output parameter definitions in a CSV file. Looking at pg_catalog.pg_proc table in EDB, I see that the information about I/O parameters is spread out in two columns…
AJay
  • 3
  • 1
  • 2
0
votes
0 answers

Update unique id (start with 1)against the foreign key and unique id will again start with 1 the next foreign key

I need to update product_details table with unique ID(CHARGE_NUMBER) againt each batch_ID and for the next batch ID unique ID again will start with 1 I have write a code using sequence. update product_details set charge_number =…
Deepak Patil
  • 17
  • 8
0
votes
1 answer

PostgreSQL : IF UPDATING ( COLUMN NAME ) equivalent in postgres

I am doing a Oracle to EDB Migration. In oracle i have used : IF UPDATING(column name) and :OLD.value <> :NEW.value THEN But I am unable to use the syntax in Postgres and need to make changes. Kindly suggest how to implement the functionality in…
urs_ng
  • 33
  • 11
0
votes
0 answers

postgresql error when import dump

I got sql dump from my client, and this is a port of the sql dump script generated from postgresql -- -- EnterpriseDB database dump -- -- Dumped from database version 10.1.5 -- Dumped by pg_dump version 10.1.5 SET statement_timeout = 0; SET…
yozawiratama
  • 4,209
  • 12
  • 58
  • 106
0
votes
0 answers

Create Password Verification Function for Enterprise PostgreSQL

How is it possible to create a function in EDB PostgreSQL to check the password? The password should contain: at least 1 upper case at least 1 lower case at least 1 digit at least 8 characters long at least 1 special character So far I searched…
SQLDBA
  • 13
  • 5
0
votes
1 answer

How to reduce WAL file count in edb postgresql 9.6 instance?

Edb postgresql instance is producing more number of WAL file segments ( each 16 MB ) in size and mount point is getting filled up . How can the WAL file size be reduced and increase the checkpoint
Dheeraj Nambiar
  • 21
  • 1
0
votes
1 answer

How to run pg_dumpall in enterprisedb 9.6

Need help backing up a database in enterprisedb. The pg_dumpall command doesn't work. When I run the command, it says can't connect to the database. I connect to the database and run the command, it doesn't give any errors, but the file doesn't show…
Phil
  • 1
  • 1
0
votes
0 answers

Does Enterprise DB can be migrated to Cloud SQL from Google Cloud?

I'm currently trying to migrate from a SQL dump file from an EnterpriseDB server to Cloud SQL Product from Google Cloud. While searching in logs i got these messages: "FATAL: pg_hba.conf rejects connection for host "201.xxx.xx.xxx", user…
Jorge C
  • 1
  • 1
0
votes
1 answer

List Partition in Postgres

I'm using Enterprise Postgres with Oracle Compatibilty. Here is a table I have created in my database. CREATE TABLE ALL_COUNTRIES ( COUNTRY_ID numeric(20,0), CHARACTERISTIC_NAME character varying(255) ) PARTITION BY LIST…
user1720827
  • 137
  • 1
  • 3
  • 15
0
votes
0 answers

Issue with ROWNUM in Enterprise Postgres

The below query should return only 4 rows (24-12-2017 to 27-12-2017). I'm using enterprise Postgres with Oracle compatibility. But some how the last line of the query is not working. It should be because of the ROWNUM. It's ignoring the ROWNUM…
user1720827
  • 137
  • 1
  • 3
  • 15
0
votes
0 answers

PostgreSQL 9.5 showing unexpected behavior when installed with different locale other than default

On Windows 7, I am trying to install PostgreSQL 9.5 ( postgresql-9.5.2-1-windows-x64.exe) with different locales, but it is getting installed with default locale only, which is, English_United States.1252. I tried both the methods, GUI and…
user
  • 383
  • 1
  • 5
  • 20
0
votes
0 answers

Remote access to EnterpriseDB PostgreSQL

When I install PostgreSQL from BigSQL I can connect from QGIS on other PC to my local PostgreSQL Server (both PCs are on the same local network 192.168.100.0/24). But then I can't install PostGIS because it always says $libdir/postgis-2-3 can't be…
Aleksandar
  • 1,163
  • 22
  • 41
1 2 3 4 5
6
7