Importar una Base de Datos por Consola

De CidesaWiki

(Diferencias entre revisiones)
Saltar a navegación, buscar
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"
Herramientas personales
Espacios de nombres
Variantes
Acciones
Navegación
Herramientas