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
