Re: backup non-built-in tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Karuna Karpe <karuna.karpe@xxxxxxxxxxxxxxx> 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

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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux