Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C506A2E009A for ; Wed, 9 Jan 2008 14:43:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05180-03 for ; Wed, 9 Jan 2008 14:43:23 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by postgresql.org (Postfix) with ESMTP id D7F072E2DE8 for ; Wed, 9 Jan 2008 14:43:25 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so163519nzf.28 for ; Wed, 09 Jan 2008 10:43:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=nO/ClxyLFSyD4TFr1+KTsj5PBy4mgx8Qx6dA/ghqQZc=; b=YD/CaHrRSOgRSzZyzA4tvyPRPm3JF3AuKAP5FwUfRBEL7oHA3RxwHA/ssh8fMkh5ydSY3QbGUwsdr3TJ0PBu3CUM8Y/0s0ecZwlrmAHMHvbEVBp28YwEqLyQh7bLb7PYmAHu3bn6cUo2ZHbFBS4T+0OgMSACHKFvD1N924bbPag= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PjOxIPzQo8or/oODwSY74dpqdI5RUoUrMuigqp0JrA9Z+12t7jnossn6ezR7FWeITKK1MPv6k+c3ioN8RZM3n/aaN7Ov7xpE2iAIZBVz/XQY9bx0khU8NxYL24jt4vO5Rs/0wf6+kznd8gfvecuveE4DmTM2jhQ8BmRsYhzVuJw= Received: by 10.114.106.1 with SMTP id e1mr1166244wac.95.1199904204461; Wed, 09 Jan 2008 10:43:24 -0800 (PST) Received: by 10.114.199.20 with HTTP; Wed, 9 Jan 2008 10:43:24 -0800 (PST) Message-ID: <4544e0330801091043q2cf62c79qaec163e4e5f1698c@mail.gmail.com> Date: Wed, 9 Jan 2008 12:43:24 -0600 From: "Peter Koczan" To: "=?ISO-8859-1?Q?Antonio_Mu=F1oz?=" Subject: Re: data transfer/migrate from win to linux Cc: pgsql-admin@postgresql.org In-Reply-To: <9da429290801090201v5527d672tf1ac63c8fd04b324@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9da429290801090201v5527d672tf1ac63c8fd04b324@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/95 X-Sequence-Number: 27869 > After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP > to linux (Ubuntu 7.10), I did not find it. > Please, does anyone know an easy way or free tool for it. Are pg_dump/pg_restore somehow insufficient for your needs? (http://www.postgresql.org/docs/current/interactive/backup.html) You'll have to dump your database to a file, transfer said file to your linux server, and then restore the database (I don't think you can directly pipe the output, but I could be wrong). You'll also have to make sure that PostGIS is installed on the linux side, but this should work modulo any major version discrepancies. If you run into an error while doing this, let us know. Peter