Received: from mx2.comcen.com.au (unknown [202.172.101.2]) by postgresql.org (Postfix) with ESMTP id 90B5A4759B3 for ; Thu, 28 Feb 2002 20:44:02 -0500 (EST) Received: from there (IDENT:V1MjCnExKy0c46rw0nMK0iKrthgxGPnX@dialup35.morpheus.dragon.net.au [203.56.245.35]) by mx2.comcen.com.au (8.11.6/8.11.6) with SMTP id g211hwD40103 for ; Fri, 1 Mar 2002 12:43:59 +1100 (EST) (envelope-from mail@okstudio.com.au) Message-Id: <200203010143.g211hwD40103@mx2.comcen.com.au> Content-Type: text/plain; charset="iso-8859-1" X-KMail-Redirect-From: George Osvald Subject: Replication From: George Osvald (by way of George Osvald ) Date: Fri, 1 Mar 2002 12:55:13 +1100 To: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/1396 X-Sequence-Number: 21386 I am running Postgresql at my office and I am considering running it on the net as well. My ISP only has MYSQL so I would have to set up my own postgresql server on my user account. I have a few questions: -Can I use replication over ADSL connection? -Do I have to replicate the whole database or can I replicate only certain tables? -Can I use something like rsync to do that for me? -Would it be possible to replicate tables from MYSQL database to my Postgresql? Thank you very much for any advise. Regards, George Osvald OK STUDIO mail@okstudio.com.au http://www.okstudio.com.au