postgresql - Permission denied when I try to restore postgres backup -

recently used command make backup of postgres databases

pg_dumpall > bkpoldpg.sql 

after removing old version of postgres downloaded last version 9.4 , have tried restore old data using :

mody@debian:~$ su postgres password:  postgres@debian:/home/mody$ postgres@debian:/home/mody$ /usr/lib/postgresql/9.4/bin/psql -d postgres -f documents/bkp01dpg.sql  documents/bkp01dpg.sql: permission denied 

as can see permission denied tried using sudo doesn't work :

postgres@debian:/home/mody$ sudo /usr/lib/postgresql/9.4/bin/psql -d postgres -f documents/bkp01dpg.sql  [sudo] password postgres:  postgres not in sudoers file.  incident reported. 

any please ?

thanks!

your backup file, or documents folder within, have permissions not permit access postgres user.

you can give postgres user (and other users on system) right read them with:

chmod a+x documents chmod a+r documents/bkp01dpg.sql 

alternately, copy bkp01dpg.sql location postgres user has access to, give postgres user ownership of it, e.g.

sudo cp documents/bkp01dpg.sql ~postgres/ sudo chown postgres ~postgres/bkp01dpg.sql 

or run restore under normal user account, connecting postgresql superuser:

psql -u postgres -f documents/bkp01dpg.sql 

... though might need modify pg_hba.conf or pg_ident.conf allow user connect postgres if way. (or temporary alter user give normal user superuser rights).

by way, don't need su postgres. in habit of using sudo -u postgres run commands, , sudo -u postgres -i if want interactive command line.