From nitin.jawarkar@skypakindia.com Mon Nov 8 07:48:02 2004 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 2E77F3A3B81 for ; Mon, 8 Nov 2004 07:48:02 +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 68333-02 for ; Mon, 8 Nov 2004 07:47:55 +0000 (GMT) Received: from ho.skypakindia.com (unknown [202.87.32.21]) by svr1.postgresql.org (Postfix) with SMTP id 0893C3A2B4A for ; Mon, 8 Nov 2004 07:47:39 +0000 (GMT) Received: (qmail 15809 invoked from network); 8 Nov 2004 06:28:45 -0000 Received: from unknown (HELO nitin) (192.168.42.225) by 0 with SMTP; 8 Nov 2004 06:28:45 -0000 Message-ID: <001901c4c568$f6405b60$e12aa8c0@nitin> Reply-To: "Nitin Jawarkar" From: "Nitin Jawarkar" To: Subject: How to run pg_restore Date: Mon, 8 Nov 2004 13:30:06 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C4C597.0FC63CC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_FONTCOLOR_BLUE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/58 X-Sequence-Number: 15443 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C4C597.0FC63CC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0016_01C4C597.0FC63CC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hello,
 
    =    =20     I have create database and run "psql -d databasename = -f=20 filename(.out)" so according to this it restores all data but not = create users,=20 i want to create users so how it can be done plz tell me. I should run = .sql file=20 in or create it.
 
 
With Regard
Nitin=20 Jawarkar
------=_NextPart_000_0016_01C4C597.0FC63CC0-- From dilipan.sebastiampillai@framestore-cfc.com Mon Nov 8 10:08:55 2004 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