Database "nuxeo" does not exist

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 me but it doesn't.

So I went into postgres, and recreated the nuxeo role and database following this: http://doc.nuxeo.com/display/ADMINDOC/Configuring+PostgreSQL

The DB is created:

postgres=# \list
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 nuxeo     | nuxeo    | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres

The role too:

postgres=# SELECT rolname FROM pg_roles;
 rolname  
----------
 postgres
 nuxeo
(2 rows)

However when I restart the server it tells me it doesn't exists:

FATAL: database "nuxeo" does not exist
Could not run configuration: Failed to connect on database: FATAL: database "nuxeo" does not exist

When I try connecting with psql I get the same thing:

$> sudo -u nuxeo psql -h localhost -p 5433
Password: 
psql: FATAL:  database "nuxeo" does not exist

I don't get it. What am I missing here? I could reinstall the whole package but I'd like to understand.

Thank you

0 votes

1 answers

3856 views

ANSWER

I re-installed everything. Deleted all config files, postgres. Cleaned up my packages. Then it worked.

I think the doc should mention "drop tables" and not "drop DB"

11/11/2014



When I install Nuxeo using apt-get it's installing Postgres so I presume it's using it? However Nuxeo in Eclipse is using H2.

Is it still the case for the 6.0 release? If yes, where is the H2 DB file?

I think the documentation about changing the Structure Template should be saying “drop tables” and not “drop DB”.

If so could we get a little guidance on what to drop and where, if I want to change the default structure at start time.

Thanks

0 votes