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--