Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WwqFq-00067B-R0 for pgadmin-support@arkaria.postgresql.org; Tue, 17 Jun 2014 10:04:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WwqFq-00085Y-3Y for pgadmin-support@arkaria.postgresql.org; Tue, 17 Jun 2014 10:04:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WwqFo-000858-9T for pgadmin-support@postgresql.org; Tue, 17 Jun 2014 10:04:36 +0000 Received: from teladesign.vm.bytemark.co.uk ([89.16.172.204]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WwqFl-0003pi-00 for pgadmin-support@postgresql.org; Tue, 17 Jun 2014 10:04:35 +0000 Received: from [109.76.121.44] (helo=[127.0.0.1]) by teladesign.vm.bytemark.co.uk with esmtpsa (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16) (Exim 4.72) (envelope-from ) id 1WwqFh-0002sd-K2; Tue, 17 Jun 2014 11:04:29 +0100 Message-ID: <53A012A5.50900@iol.ie> Date: Tue, 17 Jun 2014 11:04:21 +0100 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Oliver , pgadmin-support@postgresql.org Subject: Re: Best backup strategy for production systems References: In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 140617-0, 17/06/2014), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-support Precedence: bulk Sender: pgadmin-support-owner@postgresql.org On 17/06/2014 10:51, Oliver wrote: > Hi, > I'm a newbie in postgresql. I've mounted my first postgresql instance, > it is empty now, only with default postgres DB. > It is under Linux, with 2 filesystems, one for data and another for > archiving (I've enabled archiving as it will be for production). > Could someone recommend me a strategy for backups, scripts and so on? Hi there, You should post to the pgsql-general mailing list; this one is specifically for PgAdmin, the administration GUI for PostgreSQL. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support