Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [enterprisedb]

EnterpriseDB, or EDB, is a company that offers commercial products based on (EDB Postgres Advanced Server, BigAnimal managed Postgres service) and complementary to (Postgres-BDR, Postgres Enterprise Manager) the open source DBMS PostgreSQL.

This tag should always be used in combination with the specific product (and version, if applicable) tag

26 questions
4
votes
1 answer

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-II successfully started. version 3.4. 0…
Luan Huynh
  • 2,010
  • 7
  • 27
  • 37
4
votes
2 answers

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 the environment variables HTTP_PROXY or…
Dr.YSG
  • 409
  • 1
  • 4
  • 15
3
votes
1 answer

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 (master) are in a cluster (streaming…
Luan Huynh
  • 2,010
  • 7
  • 27
  • 37
3
votes
2 answers

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 start the server with this command: sudo…
Inactivated Account
  • 303
  • 2
  • 3
  • 12
3
votes
1 answer

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 there: I'm not the tech guy in charge of the…
henwil
  • 31
  • 1
2
votes
1 answer

Unused Indexes - PostgreSQL Database

I have used attached query to check unused indexes in my EDB9.5 DB. It's showing attached indexes are the unused indexes. Is it safe to drop below unused indexes? SELECT idstat.relname AS TABLE_NAME, indexrelname AS index_name, …
NEI
  • 31
  • 2
2
votes
1 answer

How to start PostgreSQL 12.4 [OSX]

I am not from a PostgreSQL background and wanted to use it for a project I am currently working on as it was the recommended DB for what I am using. I use PgAdmin 4 to visualise the database, and my literal understanding of "shut down server" on…
Freemium
  • 131
  • 1
  • 5
2
votes
0 answers

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 the quote we got from various vendors around our…
faulty
  • 153
  • 1
  • 7
2
votes
1 answer

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/ SELECT date ( '2015-11-13 00:00:00' ) ; 3/ SELECT cast (…
Luan Huynh
  • 2,010
  • 7
  • 27
  • 37
1
vote
2 answers

What is the use case for Cascading Replication in PostgreSQL?

What are the advantages of cascading replication in PostgreSQL? I have done testing with three nodes. M1 ----> S1 -----> S2 What is the use if my primary server (M1) goes down (failover)? Where is the secondary standby server (S2) useful for us in…
user37651
  • 31
  • 1
  • 3
1
vote
1 answer

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-yyyy'))::... ^ HINT: Could not…
Luan Huynh
  • 2,010
  • 7
  • 27
  • 37
1
vote
1 answer

Update log_statement value from all to none in EDB postgres

I want to change log_statement value from all to none on EDB 13 postgresql.conf file. Is the below command is sufficient to reflect above change that are updated in postgresql.conf file? # su - enterprisedb # psql # postgres> SELECT…
user263316
  • 13
  • 2
1
vote
1 answer

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 postgres user and return same error. I dont have the…
Juan Carlos Oropeza
  • 427
  • 2
  • 8
  • 20
1
vote
2 answers

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 maintenance_work_mem = 128MB effective_cache_size…
Luan Huynh
  • 2,010
  • 7
  • 27
  • 37
0
votes
1 answer

is it safe to have an unlogged table on the ram disk?

I need to create a table for caching in the postgresql database. Transactions should be as fast as possible, so i thought of creating unlogged table and have a RAM disk as it's tablespace. There is a warning in the official postgresql…
Tamer Mukayev
  • 5
  • 1
  • 3
1
2