X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 060523A3CA9 for ; Mon, 8 Nov 2004 10:08:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07481-06 for ; Mon, 8 Nov 2004 10:08:48 +0000 (GMT) Received: from gw.fs-cfc.co.uk (gw.fs-cfc.co.uk [193.203.83.22]) by svr1.postgresql.org (Postfix) with SMTP id E41693A3CA3 for ; Mon, 8 Nov 2004 10:08:48 +0000 (GMT) Received: (qmail 13107 invoked by uid 0); 8 Nov 2004 10:08:47 -0000 Received: from dilipan.sebastiampillai@framestore-cfc.com by proxy by uid 502 with qmail-scanner-1.14 ( Clear:. Processed in 0.030309 secs); 08 Nov 2004 10:08:47 -0000 Received: from unknown (HELO mail.admin.local) (192.168.2.15) by 0 with SMTP; 8 Nov 2004 10:08:46 -0000 Received: from localhost (localhost [127.0.0.1]) by mail.admin.local (Postfix) with ESMTP id 91B5BAB9F6A; Mon, 8 Nov 2004 10:07:26 +0000 (GMT) Received: from [172.18.10.132] (sys132.prod.local [172.18.10.132]) by mail.admin.local (Postfix) with ESMTP id 6ACB6AB9EB7; Mon, 8 Nov 2004 10:07:24 +0000 (GMT) Message-ID: <418F455C.9030705@framestore-cfc.com> Date: Mon, 08 Nov 2004 10:07:24 +0000 From: Dilipan Sebastiampillai User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Nitin Jawarkar Cc: pgsql-admin@postgresql.org Subject: Re: How to run pg_restore References: <001901c4c568$f6405b60$e12aa8c0@nitin> In-Reply-To: <001901c4c568$f6405b60$e12aa8c0@nitin> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/60 X-Sequence-Number: 15445 I know that pg_dumpall -g gives you user/groups only. Dilipan Nitin Jawarkar wrote: > hello, > > I have create database and run "psql -d databasename -f > filename(.out)" so according to this it restores all data but not > create users, i want to create users so how it can be done plz tell > me. I should run .sql file in or create it. > > > With Regard > Nitin Jawarkar