Conversation

Notices

1. Embed this notice
   brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 15:38:15 JST brigrammer

   restoring a postgres db to new dev machine, it has been 30 minutes, still not done

   why can't clients just sqlite?

   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:38:14 JST Tyler

     in reply to
     Why didn't you just copy over the existing database with rsync and then pg_upgradecluster if you're migrating to a newer runtime?
     
     A restore literally inserts every single row and does operations on them. It's horrible.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:38:48 JST Tyler

     in reply to

     • Tyler
     https://www.postgresql.org/docs/current/backup-file.html
     
     RTFM my beloved nigger
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:39:15 JST Tyler

     in reply to

     • WilhelmIII
     Rsync is a general purpose local and network file transfer tool that's been around since the mid 90s.
     
     I just throught everyone who worked on a comptuer more than an excel spreadsheet would know about it that's all man
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 15:39:16 JST brigrammer

     in reply to

     • Tyler
     • WilhelmIII
     @tyler @WilhelmIII

     You SURELY know what rsync is.

     I am a programmer, not a DBA, I have zero idea what any of the settings on the database do and just follow the notes I made from watching somebody do the task once years ago

     I write code and I sift through decompiled Java bytecode and typescript source maps, I don't got time to know what the database does (and nobody pays me to know that)

   • Embed this notice
     brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 15:39:17 JST brigrammer

     in reply to

     • Tyler

     @tyler I know almost nothing about postgres (other than standard sql knowledge) other than for local dev it seems ponderously slow and a giant pain in the ass

     I am restoring my db from one machine, which people are bitching at me because they want to shut it down, to a laptop where it doesn't exist - and there is no documentation of anything, so I am doing a restore

     I do not know what rsync and pg_upgradecluster do, but I miss hard deleting the sqlite folder, copying the backup folder, and repointing my local at the "new" db

   • Embed this notice
     WilhelmIII (wilhelmiii@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:39:17 JST WilhelmIII

     in reply to

     • Tyler

     Doing an internal restore is having postgresql up and running and then inserting all the records.

     An external restore is with the db offline and then everything is just a file.

     and for that you can use rsync or tar or whatever floats your boat. As long as the db is cold.

   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:39:17 JST Tyler

     in reply to

     • WilhelmIII
     :weep: :weep: :weep: :weep: :weep: :weep: :weep: :weep: :weep:
     
     
     Brigrammer BETTER not be MESSIN with me right now
     
     You SURELY know what rsync is.
   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:39:22 JST Tyler

     in reply to
     Are you doing a pgdump right now or what and how are you doing your backup/restore? Online or offline? Like I want to help you it just seems like you're underequipped for the task
   • Embed this notice
     brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 15:39:22 JST brigrammer

     in reply to

     • Tyler

     @tyler On my old remote dev tower, I dumped a backup, sent it to myself with teams because outlook wouldn't let me, then made a new db on the laptop, added the sole read/write system user for the db, then restored the database backup (dba folks have tended to freak out when they learn the app is designed around a single db user)

     this is the most I will ever touch the db, it is purely for dev and thankfully/unfortunately, the vendor owns the cloud version of the software we work on so we cannot touch any of the databases

     for my own local stuff, I never touch postgres - but I don't really have a choice for this because they have so screwed up their production code that it no longer starts with a clean database

     once that works (or doesn't), and people stop hounding me for stuff, I will try the approach you described in hopes it is quicker - the databases occasionally get locked into a corrupted state so backups needs to be restored, but otherwise I don't touch it

     this is all local only

   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 15:39:22 JST Tyler

     in reply to
     That is so scary to be reminded of frankly, the sheer delicateness of much of our nation's data infrastrucutre.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 15:39:23 JST brigrammer

     in reply to

     • Tyler

     @tyler I will try that after it copies over, it sounds faster

   • Embed this notice
     brigrammer (brigrammer@poa.st)'s status on Wednesday, 05-Feb-2025 16:23:34 JST brigrammer

     in reply to

     • Tyler
     • WilhelmIII

     @tyler @WilhelmIII rsync sounds like linux stuff, I work in corpo-world on Bill's operating system

   • Embed this notice
     Tyler (tyler@nicecrew.digital)'s status on Wednesday, 05-Feb-2025 16:23:34 JST Tyler

     in reply to

     • WilhelmIII
     You have an equivalent on that hellscape my niggy
     
     https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/robocopy
     ✙ dcc :pedomustdie: :phear_slackware: likes this.