Skip to content

Instantly share code, notes, and snippets.

View alnpetil's full-sized avatar

Arvy Petil alnpetil

5 followers · 3 following
  • Ascenda
  • Manila, Philippines
  • 12:24 (UTC +08:00)
View GitHub Profile
@alnpetil
alnpetil / keybase.md
Created December 3, 2019 05:51

Keybase proof

I hereby claim:

  • I am alnpetil on github.
  • I am arubi (https://keybase.io/arubi) on keybase.
  • I have a public key ASCjialBEZPb134MpExa_Wl8DcETWnTMJDg0FzK1el3ITgo

To claim this, I am signing this object:

@alnpetil
alnpetil / restore_pg_dump.md
Created July 27, 2018 01:11 — forked from jmunts/restore_pg_dump.md
Restore a postgresql dump file

Dumping database

pg_dump -Fc --no-acl --no-owner -h <host> -U <db_username> <db_name> > <name>.dump

Restoring

dropdb <db_name>
createdb <db_name>
pg_restore --verbose --clean --no-acl --no-owner -U  -d  &lt;