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
  1408 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
  1380 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
  1759 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
  4024 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
  1685 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
  2027 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
  1431 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
  1722 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
  3399 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
  9506 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
  1734 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
  3127 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
  1757 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
  2043 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
  1911 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
  3434 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
  15021 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
  1804 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
  4213 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
  1560 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
  1444 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
  2465 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
  2981 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
  1770 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
  1843 views

Why is PostgreSQL 8.3 not supported anymore in Nuxeo 5.5?
  1 votes
  1 answers
  1 comments
  2069 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
  2528 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
  1527 views