Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9C1CC9FB39C for ; Tue, 31 Oct 2006 06:49:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 85387-03 for ; Tue, 31 Oct 2006 10:49:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 9E4889FB33F for ; Tue, 31 Oct 2006 06:49:06 -0400 (AST) Received: (qmail 18948 invoked by uid 540); 31 Oct 2006 10:37:58 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(153.19.179.26):SA:0(-2.6/8.0):. Processed in 3.926937 secs); 31 Oct 2006 10:37:58 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 31 Oct 2006 10:37:53 -0000 Message-ID: <45472A4E.8050206@informatyka.gdansk.pl> Date: Tue, 31 Oct 2006 11:49:50 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Antonios Katsikadamos CC: pgsql-admin@postgresql.org Subject: Re: postgres import References: <20061031083050.5241.qmail@web58105.mail.re3.yahoo.com> In-Reply-To: <20061031083050.5241.qmail@web58105.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/219 X-Sequence-Number: 23522 Achilleas informed You very good. But if Your SQL file comes from other DBMS, like MySQL, You have to a little bit to edit this file, becouse sometimes in those files are used "slangs" characteristical for specific DBMS. If You have SQL file genarated with "pg_dump", You have to be sure, that all needed roles (users, groups) are defined in Your destination database, when in SQL file You have GRANT or REVOKE. Greetings Adam Antonios Katsikadamos wrote: > Hi all, > > > sorry again for the trouble. I have a small problem in postgres, I > have a .sql file ( db dump ) and i want to import it in postgres on > linux. > > > does anyone know how to do it? > > Thnx a lot for your time > > Get your email and more, right on the new Yahoo.com >