From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Karuna Karpe <karuna.karpe@os3infotech.com>
To: pgsql-admin@postgresql.org
Subject: Re: backup non-built-in tablespace
Date: Fri, 02 Dec 2011 09:46:23 -0600
Message-ID: <4ED89E6F0200002500043766@gw.wicourts.gov> (raw)
In-Reply-To: <CAC-Lqbq4BKrUddmroC6K+c-gnLhz2GCVXNAqi4FCLC_YKimLSw@mail.gmail.com>
References: <CAC-Lqbq4BKrUddmroC6K+c-gnLhz2GCVXNAqi4FCLC_YKimLSw@mail.gmail.com>
Karuna Karpe <karuna.karpe@os3infotech.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, karuna.karpe@os3infotech.com
Subject: Re: backup non-built-in tablespace
In-Reply-To: <4ED89E6F0200002500043766@gw.wicourts.gov>
References: <CAC-Lqbq4BKrUddmroC6K+c-gnLhz2GCVXNAqi4FCLC_YKimLSw@mail.gmail.com> <4ED89E6F0200002500043766@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox