submitted 1 week ago by First_Thunder@lemmy.zip to c/selfhost@lemmy.ml

3 comments fedilink hide all child comments

So, I had to shutdown my mini pc home server (on NIXOS) so that it could be used for something else. Most of my data is in a pair of external hdds in a RAID configuration. However the Postgres database was in the boot drive. I still have it, but it refuses to boot anywhere else (tried some old spare laptops). How can I recover it?

top 3 comments

sorted by: hot top controversial new old

[-] 2xsaiko@discuss.tchncs.de 4 points 1 week ago

The database store is in /var/lib/postgres. You can just connect that disk somewhere else and start the database using the same (important!) major release of Postgres. I think the major version number is in the folder name. Then do whatever from there.

[-] just_another_person@lemmy.world 3 points 1 week ago

Plug it into a machine, mount the drive, then copy the data off of it. You can get an external USB drive adapter for cheap if needed.

[-] SheeEttin@lemmy.zip 1 points 1 week ago

Boot live media, mount the drive, copy it off.

this post was submitted on 29 Jun 2025

6 points (100.0% liked)

Self Hosted - Self-hosting your services.

14706 readers

2 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.

Rules

No harassment
crossposts from c/Open Source & c/docker & related may be allowed, depending on context
Video Promoting is allowed if is within the topic.
No spamming.
Stay friendly.
Follow the lemmy.ml instance rules.
Tag your post. (Read under)

Important

Lemmy doesn't have tags yet, so mark it with [Question], [Help], [Project], [Other], [Promoting] or other you may think is appropriate. This is strongly encouraged!

Cross-posting

!everything_git@lemmy.ml is allowed!
!docker@lemmy.ml is allowed!
!portainer@lemmy.ml is allowed!
!fediverse@lemmy.ml is allowed if topic has to do with selfhosting.
!selfhosted@lemmy.ml is allowed!

If you see a rule-breaker please DM the mods!

founded 4 years ago

MODERATORS

Zoe8338@lemmy.ml

dogmuffins@lemmy.ml

testman@lemmy.ml