| From: | Pedro França <pedro(dot)franca(at)golsat(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Offline Tablespaces and Partial Restore |
| Date: | 2016-01-11 13:41:26 |
| Message-ID: | CAGWJvi2jTW4G-byjja=7TaSAY+wp82pSWSXL0Q67O0W7M1ZdFA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm evaluating the use of PostgreSQL to our production mission-critical
application that currently runs on SQL Server 2012.
There is a huge partitioned table of archived information that is
occasionally queried (+5TB) and are not required to be 24/7 online. An
eventual failure on the filesystem that stores these tables must not
compromise the whole cluster.
Another concern is on an eventual restore of the database, as I havent
found a way to start the cluster without some of its tablespaces.
I've tried to put the data on another database but it didn't help as
tablespaces are required cluster-wide on startup.
Is there a way to take these tablespaces offline so I could do some
maintenace work or startup the database with the archived data offline?
Thanks in advance,
Pedro Ivo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Tiffin | 2016-01-11 14:00:01 | Re: Code of Conduct: Is it time? |
| Previous Message | Henning Hoefer | 2016-01-11 13:27:47 | Re: Packages for Ubuntu Wily |