Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 442C29FA315 for ; Fri, 5 Jan 2007 15:03:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 32057-10 for ; Fri, 5 Jan 2007 15:02:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id AF17C9FA4B5 for ; Fri, 5 Jan 2007 15:02:48 -0400 (AST) Received: (from root@localhost) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) id l05J1E707395 for pgsql-admin@postgresql.org; Fri, 5 Jan 2007 13:01:14 -0600 (CST) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id l05IxpL07221 for ; Fri, 5 Jan 2007 12:59:51 -0600 (CST) Date: Fri, 5 Jan 2007 12:59:51 -0600 (CST) From: "Ben K." To: pgsql-admin@postgresql.org Subject: PITR recovery Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/43 X-Sequence-Number: 24199 Maybe this is answered somewhere or maybe self-evident, but I just wanted to make sure. I want to know if it's possible to do PITR between different platforms. I can try and learn, but if anyone knows, I'd appreciate it. 1. file formats What is the chance that the file format of files under "data" is platform independent? I.e. would it be possible to restore the file system backup and use the PITR method from a Solaris/SPARC main to a Linux backup, using their respective native file system? What are the minimal conditions to be met? 2. sql dump and PITR Is it possible to use the PITR method with SQL dump? (pg_start_backup -> sql dump -> pg_stop_backup) I guess not, but just want to make sure. Thanks. Ben K. Developer http://benix.tamu.edu