Importing dump file from pgAdmin III's "restore" option is not intuitive. It can be done easily from console, however. Just call psql from postgres bin directory located in your installation folder.
c:\Program Files\PostgreSQL\9.1\bin\psql --username=your_username --file=your_dump_file.txt --dbname=your_database
On Ubuntu try:
ReplyDeletesudo -u postgres psql --dbname=your_db_name --file=your_script_file_name
this helped my co-worker solve his problem. thanks in behalf of him :)
ReplyDeleteThat's good to hear :)
Delete