| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "W(dot)P(dot)" <laurentp(at)wp(dot)pl>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Is it possible to keep indexes on different disk location? |
| Date: | 2022-08-18 14:46:27 |
| Message-ID: | 5f4e76c742f8fb81ef01abe3b8f51a1219a431a5.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2022-08-18 at 08:39 +0200, W.P. wrote:
> I have a PostgreSQL 11 server on OrangePi3 (ARM 64 bit, Armbian, PG from
> distro).
>
> Database (all cluster) is located on USB disk. This approach give me
> already 2 times loosing DB contents (it is a replica of DB on i7).
>
> But the whole thing (mainly indexes) is about 50G, and internal storage
> is only 32GB.
>
> Is it possible to move DB tables etc to this internal storage (sure
> connection) and put only indexes on USB HDD?
>
> And will it help in case of losing connection to USB disk? (DB
> recoverable instead of total crash)?
I'd say that that is a bad idea. It would not be easy to recover from
losing a tablespace, even if it contains only indexes.
Get a real computer. Take backups regularly.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-08-18 14:53:46 | Re: Different execution plan between PostgreSQL 8.2 and 12.5 |
| Previous Message | Bruce Momjian | 2022-08-18 13:57:55 | Re: Data caching |