[postgis-users] COPIAS DE SEGURIDAD EN Postgres - Postgis

Antonio Garcia angarben at hotmail.com
Tue Nov 13 08:34:38 PST 2007


Hello, I would like help about how I can do a copy of my database Posgres sistem
 
I found a a web page: 
http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas
there speaks about it but I don't know execute it.
 
I would like execute the next script.  
 
Help please. Thank you.
 
 
Hola al final de la página:
http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas
 
está este comentario el comentario que adjunto, sirve para hacer copias de suguridad de un servidor entero con varias bases de datos. Estoy empezando y no se como hacer  copias de todo el servidor para en un momento dado restablecer el sistema.
 
 
 #!/bin/bash## BEGIN CONFIG ##HOST=localhostBACKUP_DIR=tmp## END CONFIG ##if [ ! -d $BACKUP_DIR ]; then   mkdir -p $BACKUP_DIRfiPOSTGRE_DBS=$(psql -h $HOST -U postgres -l | awk ' (NR > 2) && (/[a-zA-Z0-9]+[ ]+[|]/) && ( $0 !~ /template[0-9]/) { print $1 }');for DB in $POSTGRE_DBS ; do    echo "* Backuping PostgreSQL data from $DB@$HOST..."   pg_dump -h $HOST -U postgres $DB > $BACKUP_DIR/pg_$DB.sqldone
 
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071113/3e000ac7/attachment.html>


More information about the postgis-users mailing list