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 6030552856 for ; Mon, 11 Jul 2005 03:58:37 -0300 (ADT) 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 47245-03 for ; Mon, 11 Jul 2005 06:58:33 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id 10F8A52849 for ; Mon, 11 Jul 2005 03:58:30 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 69so786167wra for ; Sun, 10 Jul 2005 23:58:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=sJC3fcLgQSUxbR4oNSrq73VxswqyM9XQa/35i1546B2eRNKmeIOgYsrLlZvz05I+OquBVZgDxcTG/7jSon01k49DRS0x9cYOGg4MKdnwp73mn/0zFL/Gl2aTQMD1Bz7+Yjue/bIwFbGb4Mwga+SnsLVwRO0sd3oMoutb0fE1Qug= Received: by 10.54.26.70 with SMTP id 70mr370488wrz; Sun, 10 Jul 2005 23:58:31 -0700 (PDT) Received: by 10.54.140.12 with HTTP; Sun, 10 Jul 2005 23:58:31 -0700 (PDT) Message-ID: <5a33a33a050710235811a5d401@mail.gmail.com> Date: Mon, 11 Jul 2005 12:28:31 +0530 From: nandan bsd Reply-To: nandan bsd To: pgsql-admin@postgresql.org Subject: Regarding a backup scenario Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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: 200507/65 X-Sequence-Number: 18121 Hi all, I want some information regarding backups. The scenario is=20 I have got a master server which has Linux as OS and postgres as Database Other than this server i have got 5 client servers(same configuration as=20 All the transactions are done at different client locations and the data is inserted into respective client servers. I would like to maintain a backup of all client servers at 1 place ie at master location. My Idea: I am thinking to take incremental backup for every 30 min and send the .bak file to master server place so that the file is inserted into database like the same i want to do the same at every client place for 30 min send the backup to master server. but, as from the documentation there are no incremental backups at database level. I cant go for replication because the distance between each client and master server is in order of around 60 Kilometer and there is problem with network connectivity. Please give me some idea so that this setting can be done Thanks in Advance Nandan