Re: FW: Restore pg_dumpall - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: FW: Restore pg_dumpall
Date
Msg-id 4C00E2DB0200002500031BF3@gw.wicourts.gov
Whole thread Raw
In response to FW: Restore pg_dumpall  (ALEXANDER JOSE <aangelj@hotmail.com>)
List 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


pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: Relation between RAM / shmmax / shmall / shared_buffers
Next
From: "Igor Neyman"
Date:
Subject: Re: Oracle's Long data type equivalent data type in Postgresql ?