Re: Backup ?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Wilton Wonrath <wrwonrath(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup ?
Date: 2007-02-02 13:21:01
Message-ID: 45C33ABD.4080406@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wilton Wonrath wrote:
>
> Is it possible to do a backup only with index ?

You could backup the whole schema and then restore only the schema. See
the --use-list option on pg_restore.

> Is it possible to do a backup only with users, login roles or group roles ?

You can backup the roles with "pg_dumpall -g"

--
Richard Huxton
Archonet Ltd

In response to

  • Backup ? at 2007-02-02 12:19:58 from Wilton Wonrath

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-02-02 13:22:29 Re: Query optimization problem
Previous Message Peter 2007-02-02 13:10:10 Query optimization problem