Tag: postgresql

when you are using mac with postgresapp, there is a chance of this error [code language=”ruby”]…

[code language=”language="ruby”] /Applications/Postgres.app/Contents/Versions/9.6/bin/pg_dump -Fc -v -h 100.12.12.110 -p 5432 -U db_admin -d mysite_prod_v1 > mysite_oct.dump [/code]

[code language=”shell”] $ psql postgres psql (9.6.5) Type "help" for help. postgres=# ALTER DATABASE mydb_test RENAME…