postgress import db command


Import DB command:

psql -U <username> -d <dbname> -1 -f <filename>.sql -h localhost -p 5432

OR

 pg_restore --verbose --clean --no-acl --no-owner -h localhost -U 

Export DB command:

 postgres -d database_name pgfile_name.extension

https://devcenter.heroku.com/articles/heroku-postgres-import-export

stackoverflow accepted answer

Advertisements

I am Senior Software Engineer. I love reading, writing, sharing,developing, hiking, movies, trips, mountains, brooks, hills etc.

Tagged with:
Posted in postgres

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

StackOverFlow
Categories
Archives
%d bloggers like this: