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:

Example :  pg_dump -Fc -v -h [endpoint of instance] -U [master username] [database] > [database].dump

pg_dump -Fc -v -h example-database.ctctk95487r5.us-east-1.rds.amazonaws.com -U rohit Blogger > blogger.dump

password:  rohit

Or

pg_restore -U username -d dbname -1 filename.dump

Or

pg_restore -h localhost -U root -W -F t -d dbname db_dump_file.tar 

Or

pg_restore -h localhost -p 5432 -U postgres -d databasename -v "pro.dump"

Comments

Popular posts from this blog

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

SEARCHING USING AJAX IN RAILS

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

UNINITIALIZED CONSTANT PAPERCLIP::STORAGE::S3::AWS

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH