From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | <aangelj(at)hotmail(dot)com>,<pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: FW: Restore pg_dumpall |
Date: | 2010-05-29 14:48:11 |
Message-ID: | 4C00E2DB0200002500031BF3@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2010-05-29 19:56:40 | Re: Oracle's Long data type equivalent data type in Postgresql ? |
Previous Message | Jaime Casanova | 2010-05-28 21:22:37 | Re: List traffic |