From kurumella@yahoo.com Wed Dec 1 12:46:46 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 ED7D63A461F for ; Wed, 1 Dec 2004 12:46:46 +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 96179-03 for ; Wed, 1 Dec 2004 12:46:38 +0000 (GMT) Received: from web60401.mail.yahoo.com (web60401.mail.yahoo.com [216.109.118.184]) by svr1.postgresql.org (Postfix) with SMTP id 588263A55AB for ; Wed, 1 Dec 2004 12:46:39 +0000 (GMT) Received: (qmail 53774 invoked by uid 60001); 1 Dec 2004 12:46:39 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=13qR3mKqNYcUEtRRmJJsRtrnPVUHgQ01cOVSBfT7psGNcX64yoGAMqouYusXl8J4EYzMKKYquMIt1bj15tmVrniZglc8nDzFAxFuuFkuoqmuJfMxvINKMU4Qo3m7UmdZ5bYTvcYryBVWpkUflkMvUO2V8Kj1z3A9GvRqzBMObFA= ; Message-ID: <20041201124639.53772.qmail@web60401.mail.yahoo.com> Received: from [212.161.107.197] by web60401.mail.yahoo.com via HTTP; Wed, 01 Dec 2004 04:46:39 PST Date: Wed, 1 Dec 2004 04:46:39 -0800 (PST) From: Sudhakar Kurumella Subject: Linux PostgreSQL to Windows PostgreSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1892030232-1101905199=:51316" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.431 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/7 X-Sequence-Number: 15593 --0-1892030232-1101905199=:51316 Content-Type: text/plain; charset=us-ascii Hello, We have to move from Linux based PostgreSQL to Windows based PostgreSQL. Highly appreciated for Any ideas of smooth export/import options. thanks, kuru --------------------------------- Do you Yahoo!? Meet the all-new My Yahoo! – Try it today! --0-1892030232-1101905199=:51316 Content-Type: text/html; charset=us-ascii
Hello,
 
We have to move from Linux based PostgreSQL to Windows based PostgreSQL. Highly appreciated for Any ideas of smooth export/import options.
 
thanks,
kuru



Do you Yahoo!?
Meet the all-new My Yahoo! – Try it today! --0-1892030232-1101905199=:51316-- From vishalonlist@gmail.com Wed Dec 1 13:02:42 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 5FBB43A559B for ; Wed, 1 Dec 2004 13:02:42 +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 01148-06 for ; Wed, 1 Dec 2004 13:02:32 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by svr1.postgresql.org (Postfix) with ESMTP id 4D41D3A553F for ; Wed, 1 Dec 2004 13:02:34 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 68so184285wri for ; Wed, 01 Dec 2004 05:02:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=e//3e8Yj+XrAUQBDDBN+BMnx5HxqiLnO/VoD+Lz7NGOtcFLuMDTCxacsJp3ByOjY4JQMBzYplygjMHi/h1siNvE5bZByIY+WW48i91+PNgQWdqs3AnSThV4JiQjcsIkCE8PjHy57kS5KniDzDphfDK+ylGOUpVsyyWYO0x6fHaI= Received: by 10.54.31.7 with SMTP id e7mr652674wre; Wed, 01 Dec 2004 05:02:34 -0800 (PST) Received: by 10.54.50.31 with HTTP; Wed, 1 Dec 2004 05:02:34 -0800 (PST) Message-ID: <77b69d210412010502478dfe04@mail.gmail.com> Date: Wed, 1 Dec 2004 18:32:34 +0530 From: "Vishal Kashyap @ [SaiHertz]" Reply-To: "Vishal Kashyap @ [SaiHertz]" To: Sudhakar Kurumella Subject: Re: Linux PostgreSQL to Windows PostgreSQL Cc: pgsql-admin@postgresql.org In-Reply-To: <20041201124639.53772.qmail@web60401.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20041201124639.53772.qmail@web60401.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/10 X-Sequence-Number: 15596 Hi , > > We have to move from Linux based PostgreSQL to Windows based PostgreSQL. > Highly appreciated for Any ideas of smooth export/import On Linux 1. Backup everything make a file system bacup of the PostgreSQL database (plz make sutre to shut down PostgreSQL before doing this) 2. Backup data. 3. Backup Schema Windows Install PostgreSQL 1. Restore schema in new system from the backup 2. Restore database from backup 3. Run PostgreSQL. Note: Your both post must have gone to Novice list -- With Best Regards, Vishal Kashyap. Lead Software Developer, http://saihertz.com, http://vishalkashyap.tk From col@mportal.hu Wed Dec 1 13:23:26 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 6C40C3A55D1 for ; Wed, 1 Dec 2004 13:23:26 +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 07734-08 for ; Wed, 1 Dec 2004 13:23:14 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 729CC3A55A1 for ; Wed, 1 Dec 2004 13:23:16 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id iB1DNCZs009904 for ; Wed, 1 Dec 2004 13:23:12 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id iB1D517O004014 for pgsql-admin@postgresql.org; Wed, 1 Dec 2004 13:05:01 GMT (envelope-from news) From: CoL X-Newsgroups: pgsql.admin Subject: Re: Linux PostgreSQL to Windows PostgreSQL Date: Wed, 01 Dec 2004 14:05:11 +0100 Organization: Hub.Org Networking Services Lines: 12 Message-ID: References: <20041201124639.53772.qmail@web60401.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird CoL X-Accept-Language: en-us, en In-Reply-To: <20041201124639.53772.qmail@web60401.mail.yahoo.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200412/28 X-Sequence-Number: 15614 hi, Sudhakar Kurumella wrote: > Hello, > > We have to move from Linux based PostgreSQL to Windows based PostgreSQL. > Highly appreciated for Any ideas of smooth export/import options. http://www.postgresql.org/docs/7.4/interactive/migration.html http://www.postgresql.org/docs/7.4/interactive/backup.html C. From gfnobrega@planae.com.br Wed Dec 1 18:51:58 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 A10013A5441 for ; Wed, 1 Dec 2004 18:51:58 +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 23631-06 for ; Wed, 1 Dec 2004 18:51:54 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id B345D3A5419 for ; Wed, 1 Dec 2004 18:51:52 +0000 (GMT) Received: (qmail 43457 invoked by uid 1004); 1 Dec 2004 18:52:44 -0000 Received: from 192.168.0.215 by mercurio.planae.com.br (envelope-from , uid 0) with qmail-scanner-1.23 (clamdscan: 0.75. uvscan: v4.3.20/v4411. Clear:RC:1(192.168.0.215):. Processed in 0.678854 secs); 01 Dec 2004 18:52:43 -0000 Received: from unknown (HELO ?192.168.0.215?) (gfnobrega@192.168.0.215) by 192.168.0.3 with SMTP; 1 Dec 2004 18:52:43 -0000 Message-ID: <41AE12D2.5040300@planae.com.br> Date: Wed, 01 Dec 2004 16:52:02 -0200 From: =?windows-1252?Q?Gustavo_Franklin_N=F3brega_-_PLANAE?= 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: Sudhakar Kurumella Cc: pgsql-admin@postgresql.org Subject: Re: Linux PostgreSQL to Windows PostgreSQL References: <20041201124639.53772.qmail@web60401.mail.yahoo.com> In-Reply-To: <20041201124639.53772.qmail@web60401.mail.yahoo.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/26 X-Sequence-Number: 15612 Bad bad idea.. Sudhakar Kurumella wrote: > Hello, > We have to move from Linux based PostgreSQL to Windows based > PostgreSQL. Highly appreciated for Any ideas of smooth export/import > options. > thanks, > kuru > > > ------------------------------------------------------------------------ > Do you Yahoo!? > Meet the all-new My Yahoo! – Try it today! -- Atenciosamente, Gustavo Franklin Nóbrega Infraestrutura e Banco de Dados Planae Tecnologia da Informação (+55) 14 3224-3066 Ramal 209 www.planae.com.br From matthew@zeut.net Wed Dec 1 19:22:17 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 9F9823A53A8 for ; Wed, 1 Dec 2004 19:22:17 +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 34582-01 for ; Wed, 1 Dec 2004 19:22:14 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id EEA6F3A5235 for ; Wed, 1 Dec 2004 19:22:14 +0000 (GMT) Received: from ool-4350c7ad.dyn.optonline.net ([67.80.199.173] helo=[192.168.0.66]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.42) id 1CZa3J-0000QD-I7; Wed, 01 Dec 2004 14:22:13 -0500 Message-ID: <41AE197E.3030201@zeut.net> Date: Wed, 01 Dec 2004 14:20:30 -0500 From: "Matthew T. O'Connor" Organization: Terrie O'Connor Realtors User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Sudhakar Kurumella Cc: pgsql-admin@postgresql.org Subject: Re: Linux PostgreSQL to Windows PostgreSQL References: <20041201124639.53772.qmail@web60401.mail.yahoo.com> In-Reply-To: <20041201124639.53772.qmail@web60401.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 67.80.199.173 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/27 X-Sequence-Number: 15613 Sudhakar Kurumella wrote: > We have to move from Linux based PostgreSQL to Windows based > PostgreSQL. Highly appreciated for Any ideas of smooth export/import > options. You do know that the native windows version of PostgreSQL is still only in Beta. The cygwin port has never really been considered production quality. There are a few commercial vendors that offer windows versions, you could give them a try.