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

Filter by
Sorted by
Tagged with
-1 votes
0 answers
13 views

Detailed steps for taking backup from Enterprisedb and restore to Community version Postgresql [closed]

Could you please provide detailed steps for taking a backup from EnterpriseDB(V 11.13.23) and restoring to the Community version (V 12.18) Postgresql
Cassandra Thrift's user avatar
0 votes
1 answer
41 views

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 ...
Tamer Mukayev's user avatar
0 votes
1 answer
34 views

Should i enable synchronous_commit option on single node master database server?

I have an EnterpriseDB 11 database server and not clustered. It's a single master database server with no replica. I see an option named synchronous_commit option on the postgres.conf file. It has ...
MD Nasirul Islam's user avatar
0 votes
1 answer
692 views

problem on replication EFM (WAL LSN not match)

I have a postgres cluster (edb) , when i check the status i have this output : Cluster Status: efm Agent Type Address Agent DB VIP ------------------------------------------------...
Hackim_ft's user avatar
1 vote
1 answer
90 views

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 - ...
user263316's user avatar
0 votes
0 answers
579 views

How can Postgres clusters be managed on a Windows EnterpriseDB of Postgres?

To clarify, I am using plain Postgres as packaged by EnterpriseDB (with StackBuilder), not EDB Postgres Advanced Server. I'm familiar with using pg_lsclusters, pg_dropcluster, and pg_createcluster on ...
Lee Hachadoorian's user avatar
2 votes
1 answer
822 views

Unused Indexes - PostgreSQL Database [closed]

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 ...
NEI's user avatar
  • 31
2 votes
1 answer
3k views

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 ...
Freemium's user avatar
  • 131
0 votes
0 answers
505 views

Import table data using multiple sql file in psql

Local Machine(l1): Windows 10 psql Remote Machine(R1): linux EDB(postgres) On my local I have 1000+ sql script containing insert statement . psql is also installed locally . I need to run this sql ...
user236778's user avatar
0 votes
0 answers
98 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 ...
Evan Carroll's user avatar
  • 62.7k
0 votes
1 answer
474 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 ...
prakash ramakrishnan's user avatar
0 votes
2 answers
633 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).
user28688's user avatar
4 votes
2 answers
6k 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 ...
Dr.YSG's user avatar
  • 399
1 vote
1 answer
4k 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 ...
Juan Carlos Oropeza's user avatar
0 votes
1 answer
228 views

Does EnterpriseDB support Oracle RAC to Postgres replication?

Does EnterpriseDB support Oracle RAC to Postgres replication?
user109306's user avatar
0 votes
1 answer
52 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 ...
asalthangam's user avatar
-1 votes
1 answer
234 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 ...
Adam Matan's user avatar
  • 11.6k
2 votes
0 answers
146 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 ...
faulty's user avatar
  • 153
2 votes
1 answer
353 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/ ...
Luan Huynh's user avatar
  • 1,952
1 vote
2 answers
11k 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 ...
Luan Huynh's user avatar
  • 1,952
0 votes
1 answer
668 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 ...
Luan Huynh's user avatar
  • 1,952
4 votes
1 answer
8k 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-...
Luan Huynh's user avatar
  • 1,952
3 votes
1 answer
4k 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 ...
Luan Huynh's user avatar
  • 1,952
1 vote
2 answers
833 views

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 ...
user37651's user avatar
1 vote
1 answer
1k 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-...
Luan Huynh's user avatar
  • 1,952
3 votes
2 answers
11k 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 ...
DPSSpatial's user avatar
3 votes
1 answer
394 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 ...
henwil's user avatar
  • 31