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

Extensions shown in phpinfo() don't match with those enabled in loaded php.ini

I use EnterpriseDB ApachePHP on Windows XP (32 bit). I tried to enable some extensions in php.ini in the directory with ApachePHP, but nothing changed. Then I found that phpinfo() not just doesn't show the extensions I uncommented in php.ini, but it…
Pavel V.
  • 2,653
  • 10
  • 43
  • 74
1
vote
1 answer

postgres treat null as empty string when concatenated with string

When I fire below query on one of our servers select null || 'query' ,'|',version the result is null nothing is displayed when i fire the same query on another server which has same version of postgresql server I am getting result as …
Raj Pannala
  • 67
  • 1
  • 9
0
votes
2 answers

how to find what languages are loaded into EnterpriseDB?

How can I find what languages have been loaded into EnterpriseDB(PL/pgsql, SPL, Java)? EnterpriseDB is built on top of PostgreSQL if anyone knows of a way to find the loaded languages on PostgreSQL. It should work the same.
WolfmanDragon
  • 7,851
  • 14
  • 49
  • 61
0
votes
7 answers

Time out error when connecting to my postgres enterprise manager server

I installed postgres enterprise manager,EDB extended server as well as PEM agent from their official website.I navigated to the web interface using my ip address.Each time I try to connect to the server I keep getting timeout error despite inputting…
Chidera Stella Onumajuru
  • 35
  • 5
0
votes
0 answers

EDB Postgres Distributed (PGD) node restart do not replicates data

I have followed instruction from PDG Docker and installed everything as described, and everything went well. After creating the schema in the BDRDB database, I ensured that it was successfully replicated to other nodes. Next, I deliberately stopped…
djuRa
  • 9
  • 3
0
votes
1 answer

Trying to build PLJAVA 1.5.6 on java 8 + enterprisedb 15.2 fails

Modified the Changes for PLJAVA 1.5.6 since we cannot update the java version to 9 . but now linker is failing while i do the mvn clean install . doing the mvn command from microsoft visual studio command prompt as suggested in installation…
Maverick
  • 131
  • 1
  • 4
0
votes
0 answers

Label for postgresEDB in kubernetes

I want to add a label for the cluster, could anyone tell me how to add the label using the template for the cluster with apiVersion: postgresql.k8s.enterprisedb.io/v1 kind: Cluster
HARISH
  • 193
  • 4
  • 14
0
votes
1 answer

PGAgent - Scheduling a job to drop my old partitions

I have a script below which is running fine when i'm executing directly via PGAdmin however when i schedule it to run using PGAgent though, it's showing successful but my partitions were still untouched. Below is the PostgreSQL version our…
Joshua Wong
  • 1
  • 1
0
votes
1 answer

Date Difference in Oracle And EDB (Postgres)

In case of Oracle the Query select SYSDATE - TO_DATE('23-03-1022','dd-mm-yyyy') from dual; is Giving the Output SYSDATE-TO_DATE('23-03-1022','DD-MM-YYYY') ------------------------------------------ 21715.2233 In…
anant
  • 15
  • 1
  • 5
0
votes
2 answers

Postgresql: Error running c:\\...getlocales.exe : child killed: unknown signal

I tried installing PostgreSQL v14.2, 14.1, 11.1 from EnterpriseDB, but I keep getting the following error after the splash screen Here's the error popup: error image Here's the error message: There has been an error. Error running…
Prinss Alex
  • 1
  • 1
  • 1
0
votes
1 answer

Is it possible to limit which DB users/logins are audit logged in EnterpriseDB

I need to audit log database DML in EnterpriseDB, but only interactive DB users/logins (i.e. SQL client accesses), not accesses by system users/logins. I haven't been able to figure out if audit logging can be defined by users/loging. Alternatively,…
Rubio
  • 1,067
  • 1
  • 14
  • 25
0
votes
0 answers

install pg_stat_monitor on edb advanced server

I started playing with edb advanced server and got it installed on Rocky Linux. It is working fine with no issues. I now want to install percona pg_stat_monitor extension using dnf. This extension is available via PostgreSQL dnf repositories. When I…
Shery
  • 1,808
  • 5
  • 27
  • 51
0
votes
1 answer

how to restore data values that already converted into scientific notation in a table

so i have a problem where i inserted some values into my table that the value automatically converted into a scientific notation (ex: 8.24e+04) does anyone know how restore the original value or how keep the original values in the table? i'm using…
dsg1810
  • 1
  • 1
0
votes
1 answer

How to get numbers to words conversion using cash_words function in indian currency format in postgres

I am using cash_words('100'); It is showing one hundred dollars and zero cents but i want one hundred rupees as output using cash_words only For that i used lc_monetary ='en_IN.UTF-8' but no use any other parameters need to change
Anvesh
  • 1
  • 1
0
votes
0 answers

pgadmin4 container with kerberos

I'm trying to use the pgadmin4 container image with kerberos, according to https://www.pgadmin.org/docs/pgadmin4/development/kerberos.html. The pgadmin webinterface keeps telling me "Delegated credentials not supplied." But the Authorization header…
fjf2002
  • 872
  • 5
  • 15
1 2 3
4
5 6 7