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