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
  88 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
  98 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
  255 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
  372 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
  322 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
  326 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
  361 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
  397 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
  689 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
  790 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
  318 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
  744 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
  375 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
  332 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
  293 views