Re: pg_dump vs pg_dumpall - small database cluster, - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: pg_dump vs pg_dumpall - small database cluster,
Date
Msg-id 1071901126.1381.62.camel@Bhuvan.bksys.co.in
Whole thread Raw
In response to pg_dump vs pg_dumpall - small database cluster, complete recovery method needed  ("C. Bensend" <benny@bennyvision.com>)
Responses Re: pg_dump vs pg_dumpall - small database cluster,  ("C. Bensend" <benny@bennyvision.com>)
List pgsql-admin
> databases, and pg_dumpall is suited to dumping a database _system_ (ie,
> multiple databases on one host).
>

Right.

>   pg_dumpall seems to do this for me, without any command-line args
> needed.  Am I correct in saying that 'pg_dumpall > filename' will produce
> a PostgreSQL dump that includes _everything_ I need to go from a clean
> PG install to accepting connections again with data intact?  Users,
> passwords, etc?
>

and the owner of pg_dumpall process must be a database superuser.

regards,
bhuvaneswaran


Attachment

pgsql-admin by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Index is not used
Next
From: "kopra"
Date:
Subject: Re2: Problm Drop Table :: 748580