CODEWITHSUNDEEP
sqlpostgresql
akalthubaity
akalthubaity

Reputation: 31

Uploading dump file to PostgreSQL

i am totally new to postgresql and i have database as dump file on postgresql which i need to restore/upload it back.. i didnt dumped the file its already available online. I read the documentation of restore command on postgresql but it didnt work w me and i am not sure from the steps that I should follow to successfully upload it!! Please if anyone has an idea or could at least refer me to a really good resources for how to do it I will really appreciate it

Upvotes: 1

Views: 2015

Answers (1)

Jim Archer
Jim Archer

Reputation: 1417

Usually its as simple as:

psql dbname < infile

or if it's a custom-format dump:

pg_restore --dbname mydb infile

Upvotes: 1

Related Questions