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
27 questions
0
votes
0
answers
91
views
VACUUM: ERROR: invalid memory alloc request size postgresql
I am getting
ERROR: invalid memory alloc request size 2727388320
after I tried vacuuming in EnterpriseDB. It is getting bigger and bigger. How to solve this issue now ?
0
votes
1
answer
184
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 ...
0
votes
1
answer
76
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 ...
0
votes
2
answers
2k
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
------------------------------------------------...
1
vote
1
answer
184
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 - ...
0
votes
0
answers
783
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 ...
2
votes
1
answer
1k
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 ...
2
votes
1
answer
4k
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
0
answers
591
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
0
answers
138
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
1
answer
530
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
2
answers
769
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
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 ...
1
vote
1
answer
5k
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
1
answer
269
views
Does EnterpriseDB support Oracle RAC to Postgres replication?
Does EnterpriseDB support Oracle RAC to Postgres replication?