PostgreSQL


Related Questions
For LTS 2019 (Platform 10.10), it is specified in the documentation that the suggested database is versions 9.6 and 11 for PostgreSQL. We plan to upgrade our PostgreSQL database to version 12 (or higher). We would like to know if this version of ...
  0 votes
  1 answers
  0 comments
  504 views

Hello, How I can execute query in a template report xls for get all record from Document for example. I try jx:each(items=“coreSession.query('select * from Document', 2000)” var=“docg”) But not working :'(
  0 votes
  1 answers
  0 comments
  622 views

I am using Nuxeo rest APIs to upload images and some APIs are taking too much time on less tps (tested for 4 and 6 tps). After monitoring, I found that there is an update query for kv_transient_batchmanagercache table which is taking too much time ...
  0 votes
  0 answers
  2 comments
  677 views

Hello, Florent Guillaume Kevin Leturc I try to add / remove some acls on somes documents in our nuxeo WS but getting always exceptions in logs. I have PostgreSQL as database and I tried https://doc.nuxeo.com/nxdoc/read-acls/, but it changes nothing ...
  0 votes
  0 answers
  5 comments
  1267 views

Hello, we are using a docker image for Nuxeo 10.10 with a postgresql database. we have disabled the elasticsearch by adding this option elasticsearch.enabled=false in nuxeo.conf file. Nuxeo works fine with this configuration, but while navigating ...
  0 votes
  1 answers
  1 comments
  922 views

I doing performance testing of Nuxeo instance but I am sometime getting BatchUpdateException. I am uploading same file repeatedly with different metadata. I am using Postgres as backend DB. Failed to save session, java.sql.BatchUpdateException: ...
  0 votes
  1 answers
  0 comments
  1234 views

Hi, It seems that there is a way to create default users and groups creating the files users.csv and groups.csv respectably but we couldn't find how to create subgroups.. we tried by creating a file with the name group2group.csv hoping that it ...
  0 votes
  0 answers
  0 comments
  749 views

Hi guys, I decided to change the database type for some performance issues. I am using mssql for the database. Now, I want to use postgresql. This is a test environment but I have to change the production environment at the end. I can see a lot of ...
  0 votes
  2 answers
  0 comments
  996 views

I have configured PostgreSQL DB in nuxeo.conf using below configurations. Nuxeo is using public schema of Postgres. nuxeo.db.name=sample nuxeo.db.user=admin nuxeo.db.password=password nuxeo.db.host=localhost nuxeo.db.port=5432 How can I configure ...
  0 votes
  1 answers
  1 comments
  1097 views

Hi, I'm trying to migrate 250 million rows from audit postgresql database to elasticsearch. This processing time is very long ? (~ 500 entries / s) Currently, I am running one server that is only doing this data migration. Is there a command line ...
  0 votes
  0 answers
  0 comments
  1116 views

Hello, since the next official release of Nuexo (LTS 2018) should include support for version 10 of the PostgreSQL database, can we estimate the release date of Nuxeo LTS 2018?
  0 votes
  1 answers
  0 comments
  1616 views

Hello, I try hardly to install Nuxeo 9.3, but something is broken in the installation pack. While running : sudo apt install nuxeo it always exiting with the same error code. Something about Postgresql I've tried differents versions (9.6 and 10) ...
  0 votes
  1 answers
  0 comments
  2419 views

When load testing my (LTS2015 HF27 + PosgreSQL 9.6 + ElasticSearch 1.x) platform with Tsung , i get a (very) slow query as shown below . Even if create the index as suggested by PoWa : CREATE INDEX hierarchy_mixintypes_idx ON public.hierarchy USING ...
  0 votes
  2 answers
  2 comments
  2709 views

Greetings- I'm exploring deploying Nuxeo Platform v 8.10 in AWS. I've recently set it up using a shared RDS Postgres Instance in AWS amongst other nodes in AWS. Anytime it Nuxeo boots according ...
  0 votes
  1 answers
  1 comments
  2275 views