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