From: | fernando villarroel <bbddlinux(at)yahoo(dot)es> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Ayuda con Backup y Restores |
Date: | 2005-08-28 04:54:27 |
Message-ID: | 20050828045427.34115.qmail@web26003.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola me baje el script para respaldar que aparece en
el sitio www.postgresql.cl:
http://www.postgresql.cl/colabora/script_respaldo.htm
Bueno modifique algunos parametro, los siguientes:
USER=operador #Decia Postgres
BACKUP_DIR="/home/operador/resp/" #Decia
"/data/web/internal_app/pg_backups/"
TMP_DIR="/home/operador/tmp/"# Decia "/tmp/"
Bueno el respaldo funciono bien.
Pero el Restore me tira lo siguientes errores:
ERROR: relation "cltescred" does not exist
ERROR: relation "cltescred" does not exist
ERROR: relation "cltescred" does not exist
ERROR: relation "cltescred" does not exist
ERROR: relation "cltescred" does not exist
ERROR: relation "cltescred" does not exist
ERROR: relation "tipotransac" does not exist
ERROR: relation "tipotransac" does not exist
ERROR: relation "tipotransac" does not exist
ERROR: relation "tipotransac" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "camrepar" does not exist
ERROR: relation "umedida_cmedida_seq" does not exist
ERROR: relation "sucursal_csucursal_seq" does not
exist
ERROR: relation "giros_cgiro_seq" does not exist
ERROR: relation "comunas_ccomuna_seq" does not exist
ERROR: relation "motivos_cmotivo_seq" does not exist
ERROR: relation "tarifas_codtar_seq" does not exist
Lo que ocurre es que tengo una base de datos corriendo
en una maquina A y necesito llevar ese respaldo a otra
maquina B que esta en otro lugar, es decir desde el
respaldo necesito cargar la base de datos en la nueva
maquina, estructuras, tablas, datos, usuarios, etc, me
sirve el script anterior?
Fernando Villarroel N.
______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-08-28 04:55:46 | Re: Rarirsimo-Backup |
Previous Message | Alvaro Herrera | 2005-08-28 04:50:46 | Re: Arrays Multidimensionales |