I ssh to my server and used sudo su – postgres and become postgres and taken backup of db using pg_dump. Now how can i send that file to my local machine. I’m not able to scp as my file is in postgres user
Can some one suggest me how to get the backedup file to my local machine.
Advertisement
Answer
In your server, change the ownership of the file to the user which you use to login. Then you will be able to scp it to local machine. Please refer this for chown