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: | Raw Message | Whole Thread | 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 |