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
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
I think the doc should mention "drop tables" and not "drop DB"