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