Dirk Groenen dirkgroenen

## postgres-dump-restore.markdown

      
              1 file
            
          
              8 forks
            
          
              3 comments
            
          
              18 stars
            
          
                jeremykendall
                / postgres-dump-restore.markdown
            
            
              Last active
              April 27, 2021 20:27
            
              
                PostgreSQL: dump and restore (to db with different name and roles even)
              
          
    Postgres Export and Import

Export

pg_dump -U [superuser] -Fc [dbname] > db.dump
Import


## post-merge
#!/usr/bin/env bash
# MIT © Sindre Sorhus - sindresorhus.com

# git hook to run a command after `git pull` if a specified file was changed
# Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`.

changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)"

check_run() {
	echo "$changed_files" | grep --quiet "$1" && eval "$2"
	#!/usr/bin/env bash
	# MIT © Sindre Sorhus - sindresorhus.com

	# git hook to run a command after `git pull` if a specified file was changed
	# Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`.

	changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)"

	check_run() {
	echo "$changed_files" \| grep --quiet "$1" && eval "$2"