Permission denied error, how to import *.sql database to 'postgres' user

Question

I want to import 'prod.sql' file to database 'd_p_d' for 'postgres' user

postgres=# \l
 d_p_d                 | postgres | UTF8     | en_IN   | en_IN | 
 postgres              | postgres | UTF8     | en_IN   | en_IN | 
 template0             | postgres | UTF8     | en_IN   | en_IN | =c/postgres          +
                       |          |          |         |       | postgres=CTc/postgres
 template1             | postgres | UTF8     | en_IN   | en_IN | =c/postgres          +
                       |          |          |         |       | postgres=CTc/postgres


postgres=# \du
 postgres  | Superuser, Create role, Create DB, Replication | {}

The error:

postgres=# \i /home/pallavsharma/prod.sql
/home/pallavsharma/prod.sql: Permission denied

also

postgres=# \i /var/dump/prod.sql
/var/dump/prod.sql: Permission denied

PallavSharma · Accepted Answer · 2014-05-09 13:28:35Z

3

The solution is simple CHANGE OWNER of the file prod.sql by following command :

pallavsharma@smartbuzz-G41M-Combo:/var/dump$ sudo chown postgres prod.sql
[sudo] password for pallavsharma:

Then simply import the db :

postgres=# \i /var/dump/prod.sql

Thats it, it worked.

answered May 9, 2014 at 13:28

PallavSharma

4392 gold badges13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Permission denied error, how to import *.sql database to 'postgres' user

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related