-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Peder Magne Sefland wrote:

Har flyttet databasen over til den nye maskinen, men er usikker p? hvordan jeg skal importere databasen, siden det sikker er gjort endringer i skjemaene fra beta7 til beta8.

Men jeg finner ingen /usr/share/doc/nav/sql/upgrades/3.0_beta8.sql i beta8 pakken (debian)

Har noen noe tips?

Det er bare ? rulle inn dump-filen i en tom PostgreSQL p? beta8-maskinen, og deretter kj?re oppgraderingsscriptet f?r du starter NAV. Skriv:

su - postgres psql -f navdb.sql template1

Jeg vet ikke hvorfor du ikke finner oppgraderingsscriptet i Debian-pakken (du m? nesten sp?rre Morten Werner Olsen om dette), men du kan alltids finne det her: https://svn.nav.ntnu.no/nav/navme/trunk/doc/sql/upgrades/3.0_beta8.sql

- -- Morten Vold NTNU ITEA Nettgruppen

From werner at skolelinux.no Tue Dec 21 10:25:56 2004

From: werner at skolelinux.no (Morten Werner Olsen) Date: Tue Dec 21 10:35:42 2004 Subject: [Nav-users] database export/import fra beta7 til beta8 In-Reply-To: 41C7DE9B.2080304@ntnu.no References: s1c6ee81.034@HVO-3.hivolda.no 41C7DE9B.2080304@ntnu.no Message-ID: 20041221092556.GA17793@debra.uio.no

On Tue, Dec 21, 2004 at 09:28:11AM +0100, Morten Vold wrote:

Jeg vet ikke hvorfor du ikke finner oppgraderingsscriptet i Debian-pakken (du m? nesten sp?rre Morten Werner Olsen om dette), men du kan alltids finne det her: https://svn.nav.ntnu.no/nav/navme/trunk/doc/sql/upgrades/3.0_beta8.sql

Som https://svn.nav.ntnu.no/nav/navme/trunk/doc/Makefile.in bekrefter, blir ikke 3.0_beta8.sql installert. Kanskje en mer generisk m?te ? finne ut 'docfiles' hadde v?rt en ide? :)

- Werner

From peder.sefland at hivolda.no Tue Dec 21 11:52:30 2004

From: peder.sefland at hivolda.no (Peder Magne Sefland) Date: Tue Dec 21 11:52:41 2004 Subject: SV: Re: [Nav-users] database export/import fra beta7 til beta8 Message-ID: s1c80e85.045@HVO-3.hivolda.no

Det er bare ? rulle inn dump-filen i en tom PostgreSQL p? beta8-maskinen, og deretter kj?re oppgraderingsscriptet f?r du starter NAV. Skriv:

su - postgres psql -f navdb.sql template1

Jeg har pr?vd ? gj?re database importen/exporten riktig etter alle kunstens regler. Stoppet nav,tomcat, apache og restartet postgresql f?r export og f?r import.

F?r jeg starter nav p? beta8 med importert database, kj?rte jeg

psql -f 3.0_beta8.sql manage post gres BEGIN Finding duplicate device references in netbox SELECT Creating new devices INSERT 0 0 Reassigning the netboxes to the new devices and adding the UNIQUE(deviceid) cons traint to the netbox table UPDATE 0 psql:3.0_beta8.sql:52: NOTICE: ALTER TABLE / ADD UNIQUE will create implicit in dex "netbox_deviceid_key" for table "netbox" psql:3.0_beta8.sql:52: ERROR: relation "netbox_deviceid_key" already exists Finding duplicate device references in module psql:3.0_beta8.sql:61: ERROR: current transaction is aborted, commands ignored until end of transaction block Creating new devices psql:3.0_beta8.sql:63: ERROR: current transaction is aborted, commands ignored until end of transaction block Reassigning the modules to the new devices and adding the UNIQUE(deviceid) const raint to the module table psql:3.0_beta8.sql:66: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:67: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:71: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:74: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:75: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:76: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:77: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:79: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:80: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:81: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:82: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:84: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:85: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:86: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:87: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:91: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:107: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:108: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:112: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:113: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:116: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:3.0_beta8.sql:117: ERROR: current transaction is aborted, commands ignored until end of transaction block COMMIT

Etter ? starte nav, tok jeg en nav status. Denne viste at servicemonitor ikke kj?rer etter importen. Den kj?rte f?r.

Peder