Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 8E28FDDBC2A for ; Fri, 2 Dec 2011 11:46:42 -0400 (AST) 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 1RWVJw-0006eh-CZ for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 15:46:42 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Fri, 02 Dec 2011 09:46:25 -0600 Message-Id: <4ED89E6F0200002500043766@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Fri, 02 Dec 2011 09:46:23 -0600 From: "Kevin Grittner" To: "Karuna Karpe" , Subject: Re: backup non-built-in tablespace 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: -5.4 (-----) X-Archive-Number: 201112/10 X-Sequence-Number: 38768 Karuna Karpe wrote: > I want get cold backup of database cluster, but in database > cluster there are four non-built-in tablespaces. So, when get the > cold backup of database cluster and restore on another machine and > I check tablespaces for that there is no any non-built-in > tablespace is available. > > So,Please can any one let me know that, how to get non-built-in > tablespace backup? From this page: http://www.postgresql.org/docs/current/interactive/continuous-archiving.html There is this: | Be certain that your backup dump includes all of the files under | the database cluster directory (e.g., /usr/local/pgsql/data). If | you are using tablespaces that do not reside underneath this | directory, be careful to include them as well (and be sure that | your backup dump archives symbolic links as links, otherwise the | restore will corrupt your tablespaces). You might want to search that page for the other mentions of "tablespace" to find the descriptions of when to make a backup, how to restore, and caveats. -Kevin