this post was submitted on 22 Nov 2023
1 points (100.0% liked)

Self-Hosted Main

589 readers
1 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

For Example

We welcome posts that include suggestions for good self-hosted alternatives to popular online services, how they are better, or how they give back control of your data. Also include hints and tips for less technical readers.

Useful Lists

founded 2 years ago
MODERATORS
communick@selfhosted.forum
1
Setting Up Local PostgreSQL - Amidst OS and Hardware Concerns (alien.top)
submitted 2 years ago by BlazingBane007@alien.top to c/main@selfhosted.forum
1 comments fedilink hide all child comments
 

Worried about Losing Data on my Local Database? Considering a Realtime Database on my Laptop with Cloud Backups for Extra Safety. Need Guidance on Ensuring Reliability Amidst OS or Hardware Concerns.

Thing I'm worried of

  • Data loss due to OS or hardware failure.
  • Exceeding clouds free tier quota, as I can't afford to spend money as of now

what I planned to do

  • To have a local database on the laptop which will act as a primary database.
  • Also run the free tier database in the cloud which will act as a backup database.
  • I don't have to worry about the size of the database as of now. I just have to focus on Cloud database up time. and request response quota.
  • Still, there is a window open for losing my data in this case.
top 1 comments
sorted by: hot top controversial new old
[–] ElevenNotes@alien.top 1 points 2 years ago

Why not run Postgre as a cluster? Or simply dumb the database every n-interval and save that dump to as many storage endpoints as you can afford and need? Why do you run a production database on your personal device and not on a server?