postgresql


Related Questions
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 ...
  0 votes
  1 answers
  2 comments
  829 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 ...
  0 votes
  1 answers
  2 comments
  861 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 ...
  0 votes
  0 answers
  2 comments
  1100 views

Hi, I can't delete my PostgreSQL Database, can you tell the steps to follow to do so? Thanks,
  0 votes
  1 answers
  0 comments
  2693 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 ...
  0 votes
  1 answers
  0 comments
  1206 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
  1301 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 ...
  0 votes
  0 answers
  0 comments
  988 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 ...
  0 votes
  1 answers
  2 comments
  1166 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 ...
  0 votes
  1 answers
  1 comments
  2356 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;“), ...
  0 votes
  1 answers
  5 comments
  3105 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 ...
  0 votes
  1 answers
  2 comments
  1050 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 ...
  0 votes
  3 answers
  1 comments
  2362 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 ...
  3 votes
  1 answers
  2 comments
  1172 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 * ...
  2 votes
  1 answers
  0 comments
  1416 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 ...
  0 votes
  1 answers
  0 comments
  1197 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 ...
  0 votes
  2 answers
  0 comments
  2666 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 ...
  0 votes
  3 answers
  1 comments
  10078 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 ...
  0 votes
  1 answers
  1 comments
  1125 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
  2998 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 ...
  0 votes
  1 answers
  3 comments
  1039 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 ...
  1 votes
  0 answers
  3 comments
  964 views

Hi, I configured a directory with property autoincrementIdField set to true : <directory name="category"> <schema>schemacategory</schema> <dataSource>java:/nxsqldirectory</dataSource> ...
  0 votes
  1 answers
  3 comments
  1814 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 ...
  0 votes
  1 answers
  1 comments
  2273 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 ...
  0 votes
  1 answers
  13 comments
  1164 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 / ...
  1 votes
  0 answers
  0 comments
  1278 views

Why is PostgreSQL 8.3 not supported anymore in Nuxeo 5.5?
  1 votes
  1 answers
  1 comments
  1522 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
  1503 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 ...
  0 votes
  2 answers
  1 comments
  1083 views