De CidesaWiki
(Diferencias entre revisiones)
|
|
| (7 ediciones intermedias no se muestran.) |
| Línea 1: |
Línea 1: |
| | <pre> | | <pre> |
| - | /home/usuario/pg_restore.exe -i -h 10.1.21.128 -p 5432 -U wiki -d "SIMA" -v "C:\Documents and Settings\fonden\Escritorio\BD\de.sima.latin8.backup"
| + | $ sudo wiki |
| - | | + | $ pg_restore -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/basedatos.backup" |
| - | pg_restore.exe -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup" | + | </pre> |
| | | | |
| | + | <pre> |
| | + | $ sudo bash |
| | + | $ sudo wiki |
| | + | $ psql -U wiki -d SIMA -f basedatos.sql |
| | </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;
| |
Última versión de 21:03 25 jun 2008
$ sudo wiki
$ pg_restore -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/basedatos.backup"
$ sudo bash
$ sudo wiki
$ psql -U wiki -d SIMA -f basedatos.sql
