Importar una Base de Datos por Consola - Historial de revisiones

Lhernandez en 21:03 25 jun 2008

2008-06-25T21:03:22Z

← Revisión anterior		Revisión de 21:03 25 jun 2008
Línea 1:		Línea 1:
	<pre>		<pre>
	$ sudo wiki		$ sudo wiki
-	$ pg_restore~~.exe~~ -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/basedatos.backup"	+	$ pg_restore -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/basedatos.backup"
	</pre>		</pre>

Lhernandez en 21:02 25 jun 2008

2008-06-25T21:02:38Z

← Revisión anterior		Revisión de 21:02 25 jun 2008
Línea 1:		Línea 1:
	<pre>		<pre>
-	~~$ sudo bash~~
	$ sudo wiki		$ sudo wiki
	$ pg_restore.exe -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/basedatos.backup"

Lhernandez en 16:09 29 may 2008

2008-05-29T16:09:03Z

← Revisión anterior		Revisión de 16:09 29 may 2008
Línea 1:		Línea 1:
	<pre>		<pre>
		+	$ sudo bash
	$ sudo wiki		$ sudo wiki
-	$ pg_restore -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/basedatos.backup"
	</pre>		</pre>

	<pre>		<pre>
		+	$ sudo bash
	$ sudo wiki		$ sudo wiki
-	$ psql -U wiki -d ~~tachira~~ -f ~~sima004~~.sql	+	$ psql -U wiki -d SIMA -f basedatos.sql
	</pre>		</pre>

Lhernandez en 16:07 29 may 2008

2008-05-29T16:07:56Z

← Revisión anterior		Revisión de 16:07 29 may 2008
Línea 1:		Línea 1:
	<pre>		<pre>
-	~~$ sudo bash~~
	$ sudo wiki		$ sudo wiki
-	$ pg_restore~~.exe~~ -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup"	+	$ pg_restore -i -h localhost -p 5432 -U wiki -d "SIMA" -v "/home/usuario/de.sima.latin8.backup"
	</pre>		</pre>

	<pre>		<pre>
-	~~$ sudo bash~~
	$ sudo wiki		$ sudo wiki
	$ psql -U wiki -d tachira -f sima004.sql		$ psql -U wiki -d tachira -f sima004.sql
	</pre>		</pre>

Jlobaton en 12:41 26 nov 2007

2007-11-26T12:41:39Z

← Revisión anterior		Revisión de 12:41 26 nov 2007
Línea 3:		Línea 3:
	$ sudo wiki		$ 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>
		+	$ sudo bash
		+	$ sudo wiki
		+	$ psql -U wiki -d tachira -f sima004.sql
	</pre>		</pre>

Jlobaton en 21:01 3 oct 2007

2007-10-03T21:01:01Z

← Revisión anterior		Revisión de 21:01 3 oct 2007
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;~~

Jlobaton en 21:06 27 sep 2007

2007-09-27T21:06:11Z

← Revisión anterior		Revisión de 21:06 27 sep 2007
Línea 2:		Línea 2:
	$ sudo bash		$ sudo bash
	$ sudo wiki		$ 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>

Jlobaton en 21:06 27 sep 2007

2007-09-27T21:06:03Z

← Revisión anterior		Revisión de 21:06 27 sep 2007
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>

Jlobaton en 14:09 27 sep 2007

2007-09-27T14:09:02Z

← Revisión anterior		Revisión de 14:09 27 sep 2007
Línea 5:		Línea 5:

	</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;

Jlobaton: New page:

 /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"  pg_restore.exe -i -h localhost...

2007-09-27T13:57:31Z

New page: <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" pg_restore.exe -i -h localhost...

Página nueva

<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"

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

</pre>