Skip to content

Instantly share code, notes, and snippets.

View erikgall's full-sized avatar
🏠
Working from home

Erik Galloway erikgall

🏠
Working from home
View GitHub Profile

PostgreSQL Restore using Parallel Jobs

pg_restore -a -e -v --jobs=8 --use-list=toc.dat -d db_name -h 127.0.0.1
  • -a, --data-only - restore only the data, no schema
  • -e, --exit-on-error - exit on error, default is to continue
  • -v, --verbose - verbose mode
  • -j, --jobs=NUM - use this many parallel jobs to restore
@erikgall
erikgall / pg_restore-one-table-form-dump.sh
Created April 9, 2021 05:34
Restore a single table's data from a PostgreSQL dump file
pg_restore -t {table_name} -d {database_name} --data-only -e -v path/to/dump/file.dump
@erikgall
erikgall / History|-10692b42|entries.json
Last active April 16, 2024 19:33
Visual Studio Code Settings Sync Gist
{"version":1,"resource":"file:///Users/erikgall/Code/bolt/bolt-ux/src/app/Helpers/env.js","entries":[{"id":"FM0G.js","timestamp":1700205770371}]}
#!/bin/bash
echo "\n\n--- Killing Stupid Adobe Auto Load Crap ---\n\n"
launchctl unload -w /Library/LaunchAgents/com.adobe.AdobeCreativeCloud.plist
launchctl unload -w ~/Library/LaunchAgents/com.adobe.AAM.Updater-1.0.plist
echo "\n\n--- Done! ---\n\n"
@erikgall
erikgall / rsync.md
Last active June 29, 2024 18:46
Sync a local folder with a remote folder over SSH using rsync

The command -- rsync

rsync

rsync **source/** **destination
@erikgall
erikgall / keyboard-shortcuts.md
Created January 27, 2016 17:17
IDE Keyboard Shortcuts

IDE Keyboard Shortcuts

Text/Line Manipulation

  • cmd-f Search & Find Text (in file)
  • cmd-shift-f Search & Find Text (project wide)
  • cmd-d Duplicate Current Line
  • cmd-x Cut Current Line

Rubymine/PHPStorm Custom Shortcuts

  • cmd-1 Project Directory Treeview