IMPORT AND EXPORT DATABASE IN POSTGRES
Create postgres database using command line:-
createdb -h localhost -p 5432 -U postgres dbname
Import database
psql -h localhost -U username -d dbname -f /filepath/filename.sql
Import AWS RDS dump file in local database:
Example : pg_restore -v -h [endpoint of instance] -U [master username] -d [new database name] [database].dump
pg_restore -v -h localhost -U postgres -d Blogger blogger.dump
Export database
pg_dump -U postgres databasename > filename.sql
Export or Take a AWS RDS dump file:
Comments