#pg dump

http://postgresql.nabble.com/Failure-loading-materialized-view-with-pg-restore-td5838393.html

pg_restore --verbose -a --no-acl --no-owner -h localhost -d libval_development ~/Desktop/20150311.dump

the -a means only restore data

used pg_dumpall -s to see log of the process

on mbp:

pg_dump -Fc --no-acl --no-owner -h localhost -p 5432 libval_development > sc_dump_20150304.dump

note absence of -U postgres

this worked on my imac:

pg_dump -Fc --no-acl --no-owner -h localhost -p 5432 libval_development> ~/Documents/20150309.dump

specific tables:

pg_dump -D -a -t zones_seq - t interway -t table_3 ... > /tmp/zones_seq.sql pg_dump -D -a --no-owner -h localhost -p 5432 libval_development > ~/Documents/20150707_employees.dump

http://stackoverflow.com/questions/7359827/creating-a-database-dump-for-specific-tables-and-entries-postgres

UPDATE 20150707: ran this on imac

pg_dump -Fc --verbose --no-acl --no-owner -c -h localhost -p 5432 libval_development > ~/Documents/20150707_all.dump

on my PC, this shit took me all day to figure out. on my mac, it's trivial.