postgresql
Currently, our system & database uses varchar for the UUIDs. I suspect performance can be greatly improved by changing this type to the PG's uuid type. Is it possible to convert the existing table/schema to the uuid type? Would the ancestors ...
 |
otheus uibk
Member (184) 2 2 2 |
11/02/2016 |
0 votes
1 answers
2 comments
1781 views
The nuxeo documentation on postgresql says something about adding CAST functions to template0 before creating the database. As far as I can tell, with PG version 9.1.8 and later, these functions have a null effect – the builtin casts already do ...
|
otheus uibk
Member (184) 2 2 2 |
11/02/2016 |
0 votes
1 answers
2 comments
1686 views
Hi everyone! I'm troubling with error mentioned in subject. I want to migrate data from repository(oracle) to another repository which use (postgresql). What I did is use ora2pg to dump data from oracle. It worked good I think, the data commited ...
 |
wochnik.michal@gmail.com
Member (538) 1 3 6 |
07/06/2016 |
0 votes
0 answers
2 comments
2203 views
Hi, I can't delete my PostgreSQL Database, can you tell the steps to follow to do so? Thanks,
 |
Manon Lumeau
Lead Technical Writer - Product team (3.6K) 3 4 5 |
03/23/2016 |
Answer: Hi Manon, When you try to delete your PostgreSQL database you may get an error: postgres=# DROP DATABASE nuxeo;
ERROR: database "nuxeo" is being accessed by other users If you're sure there's no other user connected, then it may be because ...
0 votes
1 answers
0 comments
4782 views
Hi all we are performing a migration from 5.4.2 to 5.5 and following the steps here https://doc.nuxeo.com/display/ADMINDOC/Upgrade+from+5.4.2+to+5.5 we've found that to activate phrase search, we have to follow the steps here ...
 |
Paco Alías
Member (699) 1 3 4 |
02/22/2016 |
0 votes
1 answers
0 comments
1963 views
I've added some vocabulary ( city ) using a CSV file , those values are the content of a drop down list. Now i want to update the city table using the CSV file but the update is not taking effect. I'm using PostgreSQL. Do you have some idea on how ...
0 votes
1 answers
1 comments
2486 views
Hi I will soon have to upgrade our Nuxeo server to 6.0. Our users and groups are stored in an LDAP repository (dedicated LDAP replication). Willing to use ElasticSearch, I ll have to setup a dedicated server … or rather a dedicated cluster at least ...
 |
pibou Bouvret
Member (8.9K) 4 7 10 |
08/27/2015 |
0 votes
0 answers
0 comments
1759 views
Hi I have a problem with the growing size of some tables : relation | size
-----------------------------+--------- aclr_user_map_acl_id_idx | 15 GB aclr_user_map | 12 GB aclr_user_map_user_id_idx | 8482 MB The total size of the /var/lib/psql is ...
|
pibou Bouvret
Member (8.9K) 4 7 10 |
01/30/2015 |
Answer: The table aclr_user_map , as described in the doc contains the necessary info to be able to do efficient searches. It's a relationship table between the identity of the user (all his groups) and the synthetic ACLs applying to sets of documents. It ...
0 votes
1 answers
2 comments
2108 views
Hi, I installed Nuxeo using apt-get on Ubuntu. After changing my structure template I dropped my DB as mentioned here: http://doc.nuxeo.com/display/Studio/Structure+Templates However I have hard time recreating it. I thought nuxeoctl would do it for ...
 |
koxon
Member (578) 1 3 2 |
11/09/2014 |
0 votes
1 answers
1 comments
3854 views
Hi, I just configured nuxeo 5.9.5 in cluster. I applied the /opt/nuxeo-dm/templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql to my postgresql database Members of the cluster registered (I see them in “select * from cluster_nodes;“), ...
 |
nicolas
Member (100) 2 2 1 |
10/06/2014 |
0 votes
1 answers
5 comments
12966 views
Hello, I have an instance Nuxeo 5.8 + PostgreSQL. I need to migrate the database from PostgreSQL to SQL Server. It's possible? Also.. It's possible create a empty instance with SQL Server and then, migrate all documents? Thanks in advance. Kind ...
 |
jmnrk
Member (646) 2 3 5 |
09/29/2014 |
0 votes
1 answers
2 comments
2057 views
Hi, Currently, we use the Nuxeo Drive client in my company (about 140 users) For performance reasons, we separated the different flows between Nuxeo DM and Nuxeo Drive (see diagram) We have a problem of connections in our database PostgreSQL. Our ...
 |
Pierre Jenicot
Electronic document manager (1.1K) 2 5 6 |
06/16/2014 |
0 votes
3 answers
1 comments
3663 views
Hello, When I attempt to permanently delete (via the trash) a folder that has thousands of children, the deletion does not complete within the transaction timeout window. The system is waiting for the database to do some kind of work, but the only ...
 |
Steven Huwig
Member (2.3K) 3 5 6 |
05/30/2014 |
Answer: You may try to activate soft-delete. See Deleting Documents .
3 votes
1 answers
2 comments
2214 views
How do I implement weighting on fulltext search results ? I'm working on Nuxeo EP 5.6HF29 with Postgresql 9.1. I'm looking for a way to implement weighting on search results based on a multi criteria query. The NXQL query looks like this : Select * ...
 |
djoncour
Member (231) 1 3 2 |
02/26/2014 |
2 votes
1 answers
0 comments
2457 views
Hi, we want to run sql script when our nuxeo instance starts. This script should create tables in database if this not exists. We do not want to use schemas contributions because we do not want to manage those rows tables as documents types. We want ...
 |
murkein Rivas
Member (1.5K) 2 5 4 |
10/31/2013 |
Answer: Hello, You can configure VCS to do so. The documentation is here : http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration You have to specify a script in the sqlInitFile tag (See database creation option). This scripts holds some commands to pass ...
0 votes
1 answers
0 comments
2402 views
Follow
content-management-platform document-management database nuxeo-5.6 nuxeo-platform 5.5 5.4.2 ubuntu fulltext 8.4 migration cluster nuxeo-dm System-Environment vcs nuxeo-drive delete sqlserver search vocabulary upgrade HF-09 configuration nxql directory windows ssl jdbc test backup 7.10 redis linux quartz oracl xa 8.1 sql error
content-management-platform document-management database nuxeo-5.6 nuxeo-platform 5.5 5.4.2 ubuntu fulltext 8.4 migration cluster nuxeo-dm System-Environment vcs nuxeo-drive delete sqlserver search vocabulary upgrade HF-09 configuration nxql directory windows ssl jdbc test backup 7.10 redis linux quartz oracl xa 8.1 sql error
otheus uibk
Member (184)
Member (184)
gianclo Lori
Member (72)
Member (72)
Steven Huwig
Member (2.3K)
Member (2.3K)
pibou Bouvret
Member (8.9K)
Member (8.9K)
BW1982
Member (112)
Member (112)
Manon Lumeau
Lead Technical Writer - Product team (3.6K)
Lead Technical Writer - Product team (3.6K)
Vincent Dutat
Member (505)
Member (505)
ITShine
Member (1.8K)
Member (1.8K)
koxon
Member (578)
Member (578)
Pierre Jenicot
Electronic document manager (1.1K)
Electronic document manager (1.1K)
jmnrk
Member (646)
Member (646)
wochnik.michal@gmail.com
Member (538)
Member (538)
djoncour
Member (231)
Member (231)
davenz
Member (309)
Member (309)
bruce Grant
Member (7.6K)
Member (7.6K)
Paco Alías
Member (699)
Member (699)
karl_harris
Member (3.4K)
Member (3.4K)
nicolas
Member (100)
Member (100)
byT3b0N3
Member (15)
Member (15)
Florent Guillaume
Member (36K)
Member (36K)
Ecoged
Member (86)
Member (86)
murkein Rivas
Member (1.5K)
Member (1.5K)
sradford
Member (96)
Member (96)
Alessandro Raffa
Member (26)
Member (26)