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

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

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

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

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"?

SEARCHING USING AJAX IN RAILS

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

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension.

HOW TO CALL RAILS API FROM SIMPLE HTML PAGE.