1

I am uncertain if its the permissions issue or something I am doing wrong and any help will be greatly appreciated. I have a dedicated Ubuntu server with Postgres DB installed on it. I want to backup the databases, but when I use pg_dump I get permission denied. Can some one help me out? Here are a few details about my set up.

On postgres: I have the following databases. 

postgres, 
template0, 
template1, 
mydb, 
mydb1

I have 2 PostgreSQL users 

postgres, 
mydb (There are no postgresql groups defined yet)

All the other settings for postgres are default values.

On my ubuntu itself, I have 2 users. 

user1,
mydb

I logged into the box as root/user1 using SSH, issued the following commands,

$ pg_dumpall > a.sql

I get, -bash: a.sql: Permission denied Same goes with pg_dump command.

I know I am missing something here. Can some one guide me to properly issue this command? TIA.

Angelo Fuchs
  • 9,825
  • 1
  • 35
  • 72
bcrawl
  • 85
  • 1
  • 3
  • 7

2 Answers2

3

I get, -bash: a.sql: Permission denied Same goes with pg_dump command.

This looks more like a file permission issue. Does the OS user have the right to write the dump file? Check file/directory permissions.

sleske
  • 81,358
  • 34
  • 189
  • 227
2

When you run the command

pg_dumpall > a.sql

then your shell will attempt to create the file a.sql in the current directory. If you (as "user1") do not have permission to create files in the current directory, then first use the cd command to change to a directory where you do have permission. You can use the pwd command to see what the current directory actually is.

Greg Hewgill
  • 951,095
  • 183
  • 1,149
  • 1,285