Re: pg_dump vs pg_dumpall - small database cluster,

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump vs pg_dumpall - small database cluster,
Date: 2003-12-20 06:18:46
Message-ID: 1071901126.1381.62.camel@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kopra 2003-12-20 14:03:54 Re2: Problm Drop Table :: 748580
Previous Message A.Bhuvaneswaran 2003-12-20 06:12:27 Re: Index is not used