Installing database on PostgreSQL 9 fails
Bug #928754 reported by
Morten Brekkevold
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Network Administration Visualized |
Fix Released
|
Medium
|
Morten Brekkevold | ||
Bug Description
When attempting to run syncdb.py to create the NAV database on a PostgreSQL 9 server, it fails with the following error:
> Creating database user nav
> Creating database nav owned by nav
> createlang: language "plpgsql" is already installed in database "nav"
> Failed installing PL/pgSQL language in database nav
From PostgreSQL 9, PL/pgSQL is installed by default in new databases. syncdb.py should verify that PL/pgSQL is not installed before trying to install it.
Revision history for this message
| Morten Brekkevold (mbrekkevold) wrote | #1 |
Revision history for this message
| Morten Brekkevold (mbrekkevold) wrote | #2 |
| Changed in nav: | |
| status: | Confirmed → Fix Committed |
| milestone: | none → 3.10.2 |
| Changed in nav: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Also, it appears that we're unable to set the search path before the namespaces have actually been created in PostgreSQL 9, so we should create missing namespaces before modifying the search path.