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
