105 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
1
answer
2k
views
Setting the column COMPRESSION to LZ4 does not seem to work?
Working with Postgres 16.2 for Windows, I am attempting to set LZ4 compression on a column within one of our tables.
message text COMPRESSION lz4,
When I perform the following query:
SELECT attname,...
0
votes
0
answers
62
views
PEM auto discovery not working for community postgres 15
We’re using postgres community version 15 on suse linux 15.3 . We have enabled system config file and started the database. But while we try to auto discover the server in Postgres Enterprise Manager ...
0
votes
1
answer
935
views
Why does the PostgreSQL 16.0 EDB installer fail when using its own generated data folder for installation?
We are using the recently released PostgreSQL 16 Windows x86-64 installer to automatically install PostgreSQL 16.0 on our customer systems via a script. The installation works fine the first time. ...
0
votes
1
answer
97
views
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 ...
0
votes
1
answer
263
views
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 ...
0
votes
1
answer
502
views
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')
------------------------------------------
...
2
votes
1
answer
461
views
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,
...
1
vote
3
answers
7k
views
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 ...
1
vote
1
answer
670
views
plpgsql in EDB: SPL procedure with SPL-style OUT parameter or a function cannot be invoked using CALL in PL/pgSQL
I'm trying to run natively correct plpgsql code in EDB environment. Unfortunately there is a problem. Interestingly, the first run does not generate an error. Restarts generate an error, but after a ...
0
votes
1
answer
33
views
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 ...
0
votes
0
answers
472
views
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 ...
0
votes
1
answer
788
views
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 ...
0
votes
1
answer
874
views
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 ...
0
votes
0
answers
612
views
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 ...
0
votes
0
answers
291
views
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 ...