Re: Automated Backup Script Help (Linux)

On Wed, Mar 7, 2012 at 12:33 PM, Carlos Mennens
<carlos(dot)mennens(at)gmail(dot)com> wrote:
> I'm trying to get the automated backup scripts to work from:
>
> http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux
>
> Currently I'm using PostgreSQL 9.1.3 and have the following three files:
>
> carlos(at)db1:~/postgresql$ ls -l
> total 20
> drwxr-xr-x 2 carlos users 4096 Mar  7 13:13 backup
> -rw-r--r-- 1 carlos users 1434 Mar  7 13:19 pg_backup.config
> -rw-r--r-- 1 carlos users 4304 Mar  7 12:54 pg_backup_rotated.sh
> -rw-r--r-- 1 carlos users 3379 Mar  7 12:54 pg_backup.sh
>
> My Linux shell user 'carlos' has rwx to the entire directory as well
> as the database role 'carlos' is listed as a REPLICATION role:
>
> postgres=# \du
>                                     List of roles
>  Role name |                           Attributes
>     | Member of
> -----------+----------------------------------------------------------------+-----------
>  carlos    | Superuser, No inheritance, Create role, Create DB,
> Replication | {it}
>
> Now when I attempt to run the script for the 1st time, I get the
> following error:
>
> carlos(at)db1:~/postgresql$ pwd
> /home/carlos/postgresql
>
> carlos(at)db1:~/postgresql$ ls -l
> total 20
> drwxr-xr-x 2 carlos users 4096 Mar  7 13:13 backup
> -rw-r--r-- 1 carlos users 1435 Mar  7 13:25 pg_backup.config
> -rw-r--r-- 1 carlos users 4304 Mar  7 12:54 pg_backup_rotated.sh
> -rw-r--r-- 1 carlos users 3379 Mar  7 12:54 pg_backup.sh
>
> carlos(at)db1:~/postgresql$ sh pg_backup.sh
> pg_backup.sh: 7: cd: can't cd to pg_backup.sh

Doesn't this mean it's trying to cd to a file instead of a directory?

Andrew