Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id AAA3B13FA3D7 for ; Mon, 18 Jun 2012 14:58:04 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SggDC-0001IC-9F for pgsql-admin@postgresql.org; Mon, 18 Jun 2012 17:58:03 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 18 Jun 2012 12:57:48 -0500 Message-Id: <4FDF25CA0200002500048637@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Mon, 18 Jun 2012 12:57:46 -0500 From: "Kevin Grittner" To: "lohita nama" , Subject: Re: backup References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201206/84 X-Sequence-Number: 39675 lohita nama wrote: > I am working as sql dba recently our team had oppurtunity to work > on postgres databases and i had experience on sql server and on > windows platform and now our company had postgres databases on > solaris platform > > can u please suggest how to take the back up of postgress > databases by step by step procudure As a new user of PostgreSQL you may not yet have noticed how good the manuals are. You should find what you need in this chapter: http://www.postgresql.org/docs/current/interactive/backup.html If you are on an older version of PostgreSQL, click the link at the top for the version you are using. If you still have questions after reading the manual, feel free to post with a more specific question. -Kevin