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

Rohan Arya said…
Nice reading, I love your content. This is really a fantastic and informative post. Keep it up and if you are looking for Top cyber security companies in delhi ncr then visit cybersecknights.com.

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

E: Package 'aptitude' has no installation candidate

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

SEARCHING USING AJAX 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)

CHECK PASSENGER RUBY PATH

CURL COMMAND ON RUBY ON RAILS

SHOW LINE NUMBER OF TEXT AREA