[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