De CidesaWiki
(Diferencias entre revisiones)
|
|
Línea 4: |
Línea 4: |
| $ pg_restore.exe -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup" | | $ pg_restore.exe -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup" |
| </pre> | | </pre> |
- |
| |
- |
| |
- | pg_restore: connecting to database for restore
| |
- | pg_restore: creating STDSTRINGS STDSTRINGS
| |
- | pg_restore: [archiver (db)] Error while PROCESSING TOC:
| |
- | pg_restore: [archiver (db)] Error from TOC entry 9152; 0 0 STDSTRINGS STDSTRINGS
| |
- | pg_restore: [archiver (db)] could not execute query: ERROR: parameter "standard_conforming_strings" cannot be changed
| |
- | Command was:
| |
- | SET standard_conforming_strings = 'off';
| |
- | pg_restore: creating SCHEMA SIMA055
| |
- | pg_restore: creating COMMENT SCHEMA "SIMA055"
| |
- | pg_restore: creating SCHEMA SIMA_USER
| |
- | pg_restore: creating SCHEMA public
| |
- | pg_restore: creating COMMENT SCHEMA public
| |
- | pg_restore: creating PROCEDURAL LANGUAGE plpgsql
| |
- | pg_restore: [archiver (db)] Error from TOC entry 2364; 2612 16387 PROCEDURAL LANGUAGE plpgsql wiki
| |
- | pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists
| |
- | Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
| |
- | pg_restore: creating FUNCTION act_cpasiini00()
| |
- |
| |
- |
| |
- |
| |
- | pg_restore: creating SEQUENCE OWNED BY acatencion_id_seq
| |
- | pg_restore: [archiver (db)] Error from TOC entry 9158; 0 0 SEQUENCE OWNED BY acatencion_id_seq wiki
| |
- | pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNED" at character 34
| |
- | Command was: ALTER SEQUENCE acatencion_id_seq OWNED BY acatencion.id;
| |
Revisión de 21:01 3 oct 2007
$ sudo bash
$ sudo wiki
$ pg_restore.exe -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup"