Re: Is it possible to keep indexes on different disk location?

From: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is it possible to keep indexes on different disk location?
Date: 2022-08-18 19:54:08
Message-ID: bdabb74f-dea1-4311-5832-c3e92f0c818a@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

W dniu 18.08.2022 o 16:46, Laurenz Albe pisze:
> 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.
So do You see any (chaeper) solution for using 40GB DB having only 32
(max) GB of storage I can trust? (uSD card)
> Get a real computer. Take backups regularly.

Main DB is on "real" i7 8GB / 500 SSD.

But You are right, I am taking backups  irregular. It is not critical,
but loosing "main" would not be nice...

W.P.

> Yours,
> Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2022-08-18 20:28:25 SIReadLock vs hot_standby_feedback
Previous Message Adrian Klaver 2022-08-18 19:49:47 Re: Fwd: Data caching