Automated Backup Script Help (Linux)

Поиск
Список
Период
Сортировка
От Carlos Mennens
Тема Automated Backup Script Help (Linux)
Дата
Msg-id CAAQLLO7iqwS5qeovRgS4fGgwxU+WCQCULiTUBtQ8f4QaTx2eWA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Automated Backup Script Help (Linux)  (Andrew Gould <andrewlylegould@gmail.com>)
Re: Automated Backup Script Help (Linux)  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
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@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@db1:~/postgresql$ pwd
/home/carlos/postgresql

carlos@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@db1:~/postgresql$ sh pg_backup.sh
pg_backup.sh: 7: cd: can't cd to pg_backup.sh
pg_backup.sh: 8: pg_backup.sh: source: not found
pg_backup.sh: 16: [: !=: unexpected operator
Making backup directory in 2012-03-07/
pg_backup.sh: 54: pg_backup.sh: Bad substitution

So the only thing this script is doing for me is creating an empty
folder with the date as the name. Any idea what I'm doing wrong? I've
attached the configuration file since this is the only thing I was
told that needs to be modified. The contents are exactly as they are
on my server.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Matteo Sgalaberni
Дата:
Сообщение: Re: corrupted table postgresql 8.3
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Advisory transaction lock for 128-bit space