From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: aangelj@hotmail.com
To: pgsql-admin@postgresql.org
Subject: Re: FW: Restore pg_dumpall
Date: Sat, 29 May 2010 09:48:11 -0500
Message-ID: <4C00E2DB0200002500031BF3@gw.wicourts.gov> (raw)
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-dumpall.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.
1234567890123456789012345678901234567890123456789012345678901234567890
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-dumpall.html
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, aangelj@hotmail.com
Subject: Re: FW: Restore pg_dumpall
In-Reply-To: <4C00E2DB0200002500031BF3@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox