FW: Restore pg_dumpall

FW: Restore pg_dumpall

am 28.05.2010 18:48:20 von ALEXANDER JOSE

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


Perform a backup=20
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=20
above command I have supported all my databases and I use another=20
command.



Atentamente

Alexander Angel
Venezuela
=20
____________________________________________________________ _____
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






Perform a back=
up=20
with the following command=3B
pg_dumpall-Upostgr=
es
and record it in a file called respaldo.sql

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



Atentamente

Alexander Angel
Venezuela
=


Explore the seven wonders of the worl=
d n-US&form=3DQBRE' target=3D'_new'>Learn more!
=

--_d2456054-2e01-4e4f-a457-389a0e4e2952_--

Re: FW: Restore pg_dumpall

am 29.05.2010 16:48:11 von Kevin Grittner

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin