We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [enterprisedb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
40 views

Do any of the PostgreSQL releases for Windows support automatic updates?

PostgreSQL has two distributions for Windows, EnterpriseDB BigSQL Do either of these Windows distributions support automatic updates for the term of support? Something that looks for the updates ...
0
votes
1answer
288 views

Pgpool - 3.5 configuration

[enterprisedb@pgdvdb1dr bin]$ 2017-06-20 11:34:41: pid 103313: WARNING: could not open configuration file: "pgpool.conf" 2017-06-20 11:34:41: pid 103313: DETAIL: using default configuration ...
0
votes
2answers
320 views

How to drop and recreate catalog view in postgres [closed]

Can any one please help me to drop and recreation of sys views in EDB(Postgres).
3
votes
2answers
2k views

Connection timeout errors from Postgres Update Monitor (postgres 9.6)

I am running PostgreSQL 9.6 on windows 10 It seems it has an update monitor that does not use any information about the proxy agent from Windows (we have a corporate proxy). It also does not look at ...
0
votes
1answer
2k views

What is the pgAgent service account?

Im installing pgAgent using Stack Builder. In one step ask me for service account. Should I use PC, Domain or DB user? Or create a new one? I try using my DOMAIN\my.user.name also using the ...
0
votes
1answer
143 views

Does EnterpriseDB support Oracle RAC to Postgres replication?

Does EnterpriseDB support Oracle RAC to Postgres replication?
0
votes
1answer
38 views

I need to create SYNONYM with name 'END'

Using EnterpriseDB I am not able to create/drop SYNONYM with name 'END' DROP SYNONYM END; CREATE SYNONYM END FOR TABLENAME; I am getting similar issue while creating table with column name ...
-1
votes
1answer
200 views

PostgreSQL 9.5 and PostGIS on OSX

I have installed PostgreSQL 9.5 on OSX using the EnterpriseDb package. How do I install PostGIS on it? The official PostGIS OSX Page says that: The OSX PostgreSQL/Stackbuilder combination from ...
2
votes
0answers
120 views

Paid support for PostgreSQL

We're planning to sell a small ERP product that utilized PostgreSQL on the backend, targeting between 10 to 500 users per client. The management insisted on getting paid support for PostgreSQL, but ...
1
vote
0answers
140 views

Enterprisedb, PostgreSQL cast to date

How to cast '2015-11-13 00:00:00' (text or timestamp) to '2015-11-13'(date) in Enterprisedb (EDB) ? With 4 queries below: 1/ SELECT '2015-11-13 00:00:00'::date ; --> result: "2015-11-13" 2/ ...
1
vote
2answers
4k views

Postgres consumes a lot of RAM (cached)

I have a small database PostgreSQL (v9.3) on Centos 6 x64 ( RAM: 8 GB ). postgresql.conf max_connections = 512 shared_buffers = 3000MB temp_buffers = 8MB work_mem = 2MB ...
0
votes
1answer
447 views

Tuning postgresql.conf when benchmark

Description: We build a new database server Enterprisedb v9.3 (PostgreSQL commercial), so we use JMX to benchmark it with 1000 users. Here is our detailed information: Operating System: Centos 6 x64 ...
3
votes
1answer
5k views

Pgpool II : unable to read message length between two network interfaces

Start log file: 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for 0.0.0.0:9999 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for :::9999 2015-03-06 01:57:56: pid 2760: LOG: pgpool-...
2
votes
1answer
2k views

FATAL: terminating walreceiver due to timeout

1/ DESCRIPTION: Machine 1 (slave): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Local) Machine 2 (master): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Cloud) Machine 1 (slave) and machine 2 ...
0
votes
1answer
302 views

Can any one Explain me What is the Use of Cascading Replication in Postgresql?

What are the advantages of cascading replication in PostgreSQL. I have done Testing On this With three nodes. M1---->S1----->S2 What is the Use if My master(M1) goes Down(failover). Where the ...
0
votes
0answers
1k views

A issue on DB link between Postgres and Oracle?

I am trying to create a DB link between Oracle and PostgreSQL using OCI. CREATE DATABASE LINK oraedb CONNECT TO hr IDENTIFIED BY 'hr' USING oci '//127.0.0.1/xe'; CREATE DATABASE LINK When I am ...
0
votes
0answers
107 views

How to config Enterprisedb work with PostgresXC ?

Util now, I created a cluster (PostgreSQL database + Postgres-XC) with 5 server: 1 GTM, 1 Coordinator, 3 Data Nodes. I intend to create a Enterprisedb (Postgres Plus Advanced Server, link: EDB's home ...
1
vote
1answer
958 views

Function quote_nullable(timestamp without time zone) is not unique

When I run this query on "enterprisedb 9.2", it raises an error: select quote_nullable(to_date('09-02-2014 ','dd-MM-yyyy'))::date; Error: LINE 1: select quote_nullable(to_date('09-02-2014 ','dd-MM-...
3
votes
2answers
9k views

How to completely remove EnterpriseDB Installation of Postgresql on Ubuntu?

All, I'm trying to install/run PostgreSQL 9.3, but am receiving a multitude of errors which seem to point to a failed installation of postgresql from the enterpriseDB package. For example, trying to ...
3
votes
1answer
373 views

Postgres Plus Cloud Database on AWS for write heavy social game?

I'm one of four founders of a big social gaming iPhone app in Sweden. We now suffer from severe database server issues so I'm turning to you guys to get some help. First of all, let me get this out ...