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
1866 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
1771 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
2294 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
4877 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
2046 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
2592 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
1828 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
2184 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
3948 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
13128 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
2150 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
3743 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
2300 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
2545 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
2478 views
after running # apt-get install nuxeo I'm getting this error: [....] Starting: Nuxeo\norg.postgresql.util.PSQLException: FATAL: Passwort-Authentifizierung f?r Benutzer >>nuxeo<< fehlgeschlagen
Could not run configuration: Failed to ...
 |
byT3b0N3
Member (15) 1 1 0 |
10/17/2013 |
0 votes
2 answers
0 comments
3959 views
Hi All, I'm attempting to configure a Nuxeo 5.6 VM to access an external PostgreSQL 9.1 database over SSL. Non-encrypted connections work fine, but I'm stumped as to how to tell Nuxeo to use SSL. First, in my PostgreSQL database, I've generated an ...
 |
davenz
Member (309) 2 3 2 |
09/09/2013 |
0 votes
3 answers
1 comments
16761 views
Our PostgreSQL instance runs on a different host than the Nuxeo server. Is there a best way to avoid installing/starting PostgreSQL on the Nuxeo server when installing from the Linux package? I can shut it down after installation but that seems like ...
|
Steven Huwig
Member (2.3K) 3 5 6 |
05/29/2013 |
Answer: The PostgreSQL package itself is a dependency of the Nuxeo package, so it will be installed with its default cluster if you use the nuxeo deb package. However, if you select “Configure database in wizard”, it will not add the nuxeodb cluster (which ...
0 votes
1 answers
1 comments
2393 views
First installation failed to install JDK 7. I downloaded/installed the latest version manually from the Java.com website. Second install returned an error while configuring the PostgreSQL database, but the error message popped up and out too quickly ...
0 votes
1 answers
9 comments
4961 views
On an instance of 5.6 (running PostgreSQL 9.1) when I perform an advanced search using a phrase, I see the following error message in the server log… Caused by: org.nuxeo.ecm.core.storage.sql.jdbc.QueryMaker$QueryMakerException: Cannot use phrase ...
 |
bruce Grant
Member (7.6K) 2 7 6 |
02/14/2013 |
Answer: The fulltext storage model in postgresql has changed in 5.5. So, I think you're migrating a nuxeo instance from version prior to 5.5 and you didn't upgraded the indexes. The administration document is giving you the information about that point. ...
0 votes
1 answers
3 comments
2028 views
I have a new clean 5.5 install running against a PostgreSQL 9.1 and phrase-based searching is not working. For example if I enter “data migration” (with the double-quotes) I get documents with the words data AND migration no matter where in the ...
 |
sradford
Member (96) 1 2 2 |
11/14/2012 |
1 votes
0 answers
3 comments
1974 views
Hi, I configured a directory with property autoincrementIdField set to true : <directory name="category"> <schema>schemacategory</schema> <dataSource>java:/nxsqldirectory</dataSource> ...
 |
Vincent Dutat
Member (505) 1 3 2 |
08/02/2012 |
Answer: Autoincremented values are designed to be generated by the database and our CSV loading code doesn't expect someone to fill them by hand. I understand your need but it's unsupported at the moment. Also you would need some logic to tell the database ...
0 votes
1 answers
3 comments
2989 views
OS: Ubuntu Server 12.04 LTS PostgreSQL 9.1 I've logged in via SSH. login user: nuxeo Nuxeo: 5.5 ( installed via apt-get ) I've tried several commands and/or psql but can't find and dump the nuxeo db. $ sudo su - postgres $ psql # SELECT * FROM ...
 |
Alessandro Raffa
Member (26) 1 1 1 |
05/17/2012 |
Answer: Hi! If you are running a default installation, it's probably because the nuxeodb postgres server is listening on port 5433. If you connect with : psql -p 5433 then you should see more infos :) And a command like : pg_dump -p 5433 -f ...
0 votes
1 answers
1 comments
3589 views
Hi all, We are using Nuxeo DM 5.5 with PostgreSQL 8.4.and we have a singular (almost for us) behavior of the system. For long period of time Nuxeo works well, we are able to insert, upload delete document and so on. Then after a several operation ...
 |
gianclo Lori
Member (72) 1 2 2 |
05/10/2012 |
0 votes
1 answers
13 comments
2198 views
Hi My name is Giancarlo. Me and some other collegues are working with Nuxeo DM 5.5. in order to implement / evaluate a solution for one of our client. We have installed PostgreSql 9.1 on one machine, and Nuxeo DM on another machine under Linux / ...
|
gianclo Lori
Member (72) 1 2 2 |
04/24/2012 |
1 votes
0 answers
0 comments
2335 views
Why is PostgreSQL 8.3 not supported anymore in Nuxeo 5.5?
 |
Florent Guillaume
Member (36K) 6 8 8 |
12/21/2011 |
Answer: PostgreSQL 8.3 is not supported anymore for two reasons: we have stored procedures that use a function ( unnest ) that was added in PostgreSQL 8.4. the new fulltext prefixed search ( foo* ) works thanks to new features of the GIN index type that ...
1 votes
1 answers
1 comments
2647 views
Hello, I installed my instance of Nuxeo with PostgreSQL by default. But I can't connect to the Nuxeo database through the PGAdmin with data from the tab Admin Center. What should I do to connect to the Nuxeo database and run an sql dump? Thks.
0 votes
2 answers
2 comments
2986 views
I have been attempting to point v5.5 to my existing PGSQL database. I have defined NUXEO_HOME, NUXEO_CONF and I have moved the blob data, logs and nuxeo.conf file out of the Nuxeo_HOME directory. All of this works on v5.4.2. I've unzipped a version ...
 |
karl_harris
Member (3.4K) 3 6 6 |
12/06/2011 |
Answer: Ok, I reproduced this problem and this is a bug on this SNAPSHOT you downloaded yesterday. Thank you for this feedback. This problem has been fixed now and you can download the next SNAPSHOT that will be published tonight, or you can download that ...
0 votes
2 answers
1 comments
1900 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)