Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4F73C9FB21B for ; Fri, 2 Feb 2007 09:21:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 91050-02 for ; Fri, 2 Feb 2007 09:21:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 6DF599FA6B5 for ; Fri, 2 Feb 2007 09:21:03 -0400 (AST) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 050207558C; Fri, 2 Feb 2007 13:21:02 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id D5620274053; Fri, 2 Feb 2007 13:21:01 +0000 (GMT) Message-ID: <45C33ABD.4080406@archonet.com> Date: Fri, 02 Feb 2007 13:21:01 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: Wilton Wonrath Cc: pgsql-general@postgresql.org Subject: Re: Backup ? References: <8727.8691.qm@web34310.mail.mud.yahoo.com> In-Reply-To: <8727.8691.qm@web34310.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/99 X-Sequence-Number: 108589 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