Questions tagged [enterprisedb]
The enterprisedb tag has no usage guidance.
25
questions
0
votes
0answers
15 views
Why all instances of PostgreSQL are not listed in stackbuikder (enterpriseDB)?
On a windows server 2012, There are two instances of PostgreSQL 11.5.
The first in running on port 5432 and was created with EnterpriseDB installer.
The second was created manualy with initdb then ...
0
votes
1answer
83 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 ...
1
vote
1answer
840 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 ...
0
votes
0answers
196 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 ...
0
votes
0answers
36 views
Same name for a view and synonym in same schema
Scenario:
In a schema (sc1), there is a synonym with name syn1 for table t1. I created a view with name as sc1.syn1.
And it got created successfully without any conflict with synonym.
Synonymn (syn1) ...
0
votes
0answers
164 views
Migrating sequences from postgres to EDB database
Scenario :
We are migrating data from a postgres DB to new EDB database .
We have migrated the sequence and all table data also .
Both DB is installed on a remote unix server and on diffrent machines....
0
votes
0answers
58 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
388 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
416 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).
4
votes
2answers
5k 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
3k 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
163 views
Does EnterpriseDB support Oracle RAC to Postgres replication?
Does EnterpriseDB support Oracle RAC to Postgres replication?
0
votes
1answer
41 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
222 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
130 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
194 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
6k 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
549 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
...
4
votes
1answer
7k 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-...
3
votes
1answer
3k 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
363 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 ...
0
votes
0answers
111 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
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-...
3
votes
2answers
10k 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
380 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 ...
