<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hello, I would like help about how I can do a copy of my database Posgres sistem<BR>
<BR>
I found a a web page: <BR>
<A href="http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas">http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas</A><BR>
there speaks about it but I don't know execute it.<BR>
<BR>
I would like execute the next script. <BR>
<BR>
Help please. Thank you.<BR>
<BR>
<BR>
Hola al final de la página:<BR>
<A href="http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas">http://www.guia-ubuntu.org/index.php?title=PostgreSQL#Permitir_conexiones_remotas</A><BR>
<BR>
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.<BR>
<BR>
<BR>
<SPAN style="COLOR: #808080; FONT-STYLE: italic">#!/bin/bash</SPAN><BR><BR><SPAN style="COLOR: #808080; FONT-STYLE: italic">## BEGIN CONFIG ##</SPAN><BR><SPAN style="COLOR: #0000ff">HOST=</SPAN>localhost<BR><SPAN style="COLOR: #0000ff">BACKUP_DIR=</SPAN>tmp<BR><SPAN style="COLOR: #808080; FONT-STYLE: italic">## END CONFIG ##</SPAN><BR><BR><SPAN style="COLOR: #b1b100">if</SPAN> <SPAN style="COLOR: #66cc66">[</SPAN> ! -d <SPAN style="COLOR: #0000ff">$BACKUP_DIR</SPAN> <SPAN style="COLOR: #66cc66">]</SPAN>; <SPAN style="COLOR: #b1b100">then</SPAN><BR> mkdir -p <SPAN style="COLOR: #0000ff">$BACKUP_DIR</SPAN><BR><SPAN style="COLOR: #b1b100">fi</SPAN><BR><BR><SPAN style="COLOR: #0000ff">POSTGRE_DBS=</SPAN>$<SPAN style="COLOR: #66cc66">(</SPAN>psql -h <SPAN style="COLOR: #0000ff">$HOST</SPAN> -U postgres -l | awk <SPAN style="COLOR: #ff0000">' (NR > 2) && (/[a-zA-Z0-9]+[ ]+[|]/) && ( $0 !~ /template[0-9]/) { print $1 }'</SPAN><SPAN style="COLOR: #66cc66">)</SPAN>;<BR><BR><SPAN style="COLOR: #b1b100">for</SPAN> DB <SPAN style="COLOR: #b1b100">in</SPAN> <SPAN style="COLOR: #0000ff">$POSTGRE_DBS</SPAN> ; <SPAN style="COLOR: #b1b100">do</SPAN> <BR> <SPAN style="COLOR: #000066">echo</SPAN> <SPAN style="COLOR: #ff0000">"* Backuping PostgreSQL data from $DB@$HOST..."</SPAN><BR> pg_dump -h <SPAN style="COLOR: #0000ff">$HOST</SPAN> -U postgres <SPAN style="COLOR: #0000ff">$DB</SPAN> > <SPAN style="COLOR: #0000ff">$BACKUP_DIR</SPAN>/pg_<SPAN style="COLOR: #0000ff">$DB</SPAN>.sql<BR><SPAN style="COLOR: #b1b100">done</SPAN><BR>
<SPAN style="COLOR: #b1b100"></SPAN> <BR><br /><hr />Express yourself instantly with MSN Messenger! <a href='http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/' target='_new'>MSN Messenger</a></body>
</html>