How does one import a postgis database in the ubuntu/osgeo live environment? In windows I would copy the backed up database file into the postgres bin folder and then use cmd to restore the databse. As I am new to the ubuntu/osge live environment I am not sure how to go about restoring a postgis database.

1 Answer 1


I would back the database up in the windows environment using the PGAdmin tool

Install PGAdmin then "Right click" the database, select "Backup" and choose custom format

Move this file to the ubuntu environment and the commands:-

createdb mydb
pg_restore -Fc -d mydb <filename>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.