Re: pg_dump vs pg_dumpall - small database cluster,

Поиск
Список
Период
Сортировка
От A.Bhuvaneswaran
Тема Re: pg_dump vs pg_dumpall - small database cluster,
Дата
Msg-id 1071901126.1381.62.camel@Bhuvan.bksys.co.in
обсуждение исходный текст
Ответ на pg_dump vs pg_dumpall - small database cluster, complete recovery method needed  ("C. Bensend" <benny@bennyvision.com>)
Ответы Re: pg_dump vs pg_dumpall - small database cluster,  ("C. Bensend" <benny@bennyvision.com>)
Список 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


Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: Index is not used
Следующее
От: "kopra"
Дата:
Сообщение: Re2: Problm Drop Table :: 748580