Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41940=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VlLwq-0003gv-Je
 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Nov 2013 16:57:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41940=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VlLwq-0003uw-30
 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Nov 2013 16:57:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scott_ribe@elevated-dev.com>) id 1VlLwp-0003uq-C4
 for pgsql-admin@postgresql.org; Tue, 26 Nov 2013 16:57:15 +0000
Received: from mail223c25.carrierzone.com ([64.29.147.237]
 helo=mail24c25-2209.carrierzone.com)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scott_ribe@elevated-dev.com>) id 1VlLwl-0003Lc-RB
 for pgsql-admin@postgresql.org; Tue, 26 Nov 2013 16:57:15 +0000
X-Authenticated-User: sribe.elevated-dev.com
Received: from [192.168.4.16] ([205.170.118.135]) (authenticated bits=0)
 by mail24c25-2209.carrierzone.com (8.13.6/8.13.1) with ESMTP id
 rAQGv7gk026711
 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO);
 Tue, 26 Nov 2013 16:57:08 +0000
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\))
Subject: Re: Backup of database
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CANGhxCgYrQbvegp1MbjbQ0SLpoVOC1TSqZYBObgE9pO4_N+Dbw@mail.gmail.com>
Date: Tue, 26 Nov 2013 09:56:55 -0700
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <B00D83F7-38D0-4643-BE17-C8F8AB1DDB10@elevated-dev.com>
References: 
 <CANGhxCgYrQbvegp1MbjbQ0SLpoVOC1TSqZYBObgE9pO4_N+Dbw@mail.gmail.com>
To: joka veera Venkataramana <ramanajvv@gmail.com>
X-Mailer: Apple Mail (2.1822)
X-CSC: 0
X-CHA: v=2.1 cv=aKDJ99Nm c=1 sm=1 tr=0 a=hYCsVa6O+dny/aDYgEAfRA==:117
 a=hYCsVa6O+dny/aDYgEAfRA==:17 a=g0qM3YM6AAAA:8 a=YTaT0nJ_ZkcA:10
 a=8nJEP1OIZ-IA:10 a=YfQFs2c5AAAA:8 a=EDpmliPfj6gA:10 a=pGLkceISAAAA:8
 a=epTmVMiNAAAA:8 a=jqvht8OWcO7LNbXbGxAA:9 a=wPNLvfGTeEIA:10
 a=uN5EI_x0ke8A:10 a=sx6hCiKP-x8A:10 a=_lAbqqU3_9wA:10 a=MSl-tDqOz04A:10
 a=p4YQ7U2Pg4IA:10 a=ShYGT-nwPNAA:10 a=zxdzyh_RRpcA:10
X-CTCH-RefID: str=0001.0A020204.5294D2E5.002B, ss=1, re=0.100, recu=0.000,
 reip=0.000, cl=1, cld=1, fgs=0
X-CTCH-VOD: Unknown
X-CTCH-Spam: Unknown
X-CTCH-Score: 0.100
X-CTCH-Rules: 
X-CTCH-Flags: 0
X-CTCH-ScoreCust: 0.000
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana <ramanajvv@gmail.com>=
 wrote:

> I know all my questions are basic, why we are asking here is  previously =
we were in DB2 now we moved our database to Postgre (Its new for us). Pleas=
e help us.

<http://www.postgresql.org/docs/9.3/interactive/backup.html>

Personally, for daily backups, I like pg_dumpall | bzip2.

--=20
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin