Re: Automated Backup Script Help (Linux)

From: Andrew Gould <andrewlylegould(at)gmail(dot)com>
To: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
Cc: "PostgreSQL (General)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Automated Backup Script Help (Linux)
Date: 2012-03-07 18:58:24
Message-ID: CAFKhKgr5BR=hWrv8MiuVbSGTHyHafcy8xaK7k8SJt+pux7xVFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Grilly 2012-03-07 19:05:54 Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Previous Message Nicolas Grilly 2012-03-07 18:51:55 Re: ts_rank seems very slow (140 ranked documents / second on my machine)