Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #708

Re: problem with pg_dumpall

Show all headers | View raw

On 31.03.2016 03:43, Magnus Warker wrote:
> Hi,
>
> my user "warker" has a script in /home/warker/scr/bak with the following
> content:
>
>      #!/bin/sh
>      echo Database Backup
>      pg_dumpall -Uwww > /home/wagner/bak/dbs.sql
>
> When I call this script as user warker, it works fine.
>
> However, there is a system-wide backup script /root/scr/bak with the
> following contents:
>
>      #!/bin/sh
>      echo "User Backup"
>      ...
>      su -c /home/warker/scr/bak warker
>      ...
>
> When I call this script as root, I get the following error:
>
>      could not change directory to "/root": Permission denied
>
> I found that this error is caused by pg_dumpall, which is a script.
>
> What's the problem here?

Your environment most likely carries around the original value of HOME. 
  I'd try sudo for a change.

Kind regards

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

problem with pg_dumpall Magnus Warker <warker@mailinator.com> - 2016-03-31 03:43 +0200
  Re: problem with pg_dumpall Robert Klemme <shortcutter@googlemail.com> - 2016-03-31 11:15 +0200
    Re: problem with pg_dumpall Magnus Warker <warker@mailinator.com> - 2016-04-01 18:53 +0200

csiph-web