Importar una Base de Datos por Consola

De CidesaWiki

Revisión de 14:09 27 sep 2007 (ver código fuente) Jlobaton (Discusión | contribuciones) ← Edición más antigua		Revisión de 21:06 27 sep 2007 (ver código fuente) Jlobaton (Discusión | contribuciones) Edición más nueva →
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 bash
-		+	$ sudo wiki
-	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>

---

Revisión de 21:06 27 sep 2007

 $ sudo bash
 $ sudo wiki
 $pg_restore.exe -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup"

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;