FW: Restore pg_dumpall

--_d2456054-2e01-4e4f-a457-389a0e4e2952_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Perform a backup
with the following command=3B
pg_dumpall-Upostgres
and record it in a file called respaldo.sql

postgres in my instance I have 22 databases=2C I wondered if the
above command I have supported all my databases and I use another
command.



Atentamente

Alexander Angel
Venezuela

____________________________________________________________ _____
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=3D7+wonders+world&mkt=3 Den-US&form=3DQ=
BRE=

--_d2456054-2e01-4e4f-a457-389a0e4e2952_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
<span id=3D"result_box" class=3D"long_text"><span title=3D"">Perform a back=
up
with the following command=3B<br></span><span title=3D"">pg_dumpall-Upostgr=
es
and record it in a file called respaldo.sql<br><br></span><span title=3D""=
>postgres in my instance I have 22 databases=2C I wondered if the
above command I have supported all my databases and I use another
command.<br><br><br><br>Atentamente<br><br>Alexander Angel<br>Venezuela<br>=
</span></span>
<hr />Explore the seven wonders of the worl=
d <a href=3D'http://search.msn.com/results.aspx?q=3D7+wonders+world&mkt=3De=
n-US&form=3DQBRE' target=3D'_new'>Learn more!</a></body>
</html>=

--_d2456054-2e01-4e4f-a457-389a0e4e2952_--
ALEXANDER JOSE [ Fr, 28 Mai 2010 18:48 ] [ ID #2042199 ]

Re: FW: Restore pg_dumpall

ALEXANDER JOSE wrote:

Perform a backup
with the following command;
pg_dumpall-Upostgres
and record it in a file called respaldo.sql

postgres in my instance I have 22 databases, I wondered if the
above command I have supported all my databases and I use another
command.

http://www.postgresql.org/docs/8.4/interactive/app-pg-dumpal l.html

ALEXANDER JOSE wrote:

> Perform a backup
> with the following command;
> pg_dumpall-Upostgres
> and record it in a file called respaldo.sql

> postgres in my instance I have 22 databases, I wondered if the
> above command I have supported all my databases and I use another
> command.

123456789012345678901234567890123456789012345678901234567890 1234567890
If that runs without error the output will contain the information
necessary to re-create all of your databases and their schema as
well as all data. It will also create roles, etc., which apply to
all databases.

http://www.postgresql.org/docs/8.4/interactive/app-pg-dumpal l.html

-Kevin


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Sa, 29 Mai 2010 16:48 ] [ ID #2042265 ]
Datenbanken » gmane.comp.db.postgresql.admin » FW: Restore pg_dumpall

Vorheriges Thema: Transaction with in function
Nächstes Thema: Relation between RAM / shmmax / shmall / shared_buffers