On Thu, Aug 18, 2022 at 08:39:27AM +0200, W.P. wrote:
> Is it possible to move DB tables etc to this internal storage (sure
> connection) and put only indexes on USB HDD?
Sure. There is a thing called tablespace, which is basically, directory
where files for db objects reside.
You can specify it both when making new objects
(https://www.postgresql.org/docs/current/sql-createtable.html,
https://www.postgresql.org/docs/current/sql-createtable.html) and you
can also move object between tablespaces (
(https://www.postgresql.org/docs/current/sql-altertable.html,
https://www.postgresql.org/docs/current/sql-altertable.html).
Just keep in mind that moving object means that it will get locked, data
copied to new device, and then removed from old, and unlocked.
> And will it help in case of losing connection to USB disk? (DB recoverable
> instead of total crash)?
Well, you need *all* data from all tablespaces to have fully working db.
Best regards,
depesz