During upgrade I get "The automatic update script failed to update database"
This is not the first time that happen. Upgrading to the latest 5.11 (from 5.9) I get error at the end. Inspecting nav DB it seems that DB has been updated. To check that DB has been updated I read the content of file cat sc.05.11.0001.sql, cat sc.05.11.0002.sql and check the DB for the presence of the table "manage.oui" and of the new records in the table "altertype". Below the error that I get: ===================== Automatic database update failed The automatic update script failed to update the database. Script output: could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
On Sun 10 Nov 2024 at 20:10, Davide Miccone <davide@wpweb.com> wrote:
Automatic database update failed The automatic update script failed to update the database.
The error messages you posted indicate that PostgreSQL wasn't even running during the attempt to upgrade (were you doing a full system upgrade of the Debian server, or just the nav package itself?). What happens if you run the `navsyncdb` command manually? -- Sincerely, Morten Brekkevold Sikt – Norwegian Agency for Shared Services in Education and Research
participants (2)
-
Davide Miccone -
Morten Brekkevold