From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: create schedule job
Date: Tue, 30 Aug 2011 16:38:46 +0300
User-Agent: KMail/1.9.7
References: 
 <CAC-Lqbrty-6zsvcUoF69mVa_FucRVRBNxGQYOw23bUi+QLg+Kw@mail.gmail.com>
In-Reply-To: 
 <CAC-Lqbrty-6zsvcUoF69mVa_FucRVRBNxGQYOw23bUi+QLg+Kw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201108301638.46538.achill@matrix.gatewaynet.com>

1st run the script by hand  (maybe with -v) to see what is going wrong.
2nd use cron

=CE=A3=CF=84=CE=B9=CF=82 Tuesday 30 August 2011 16:29:32 =CE=BF/=CE=B7 Karu=
na Karpe =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello,
>=20
> I am create one job using pgAgent in postgres studio.  In that job i want=
 to
> backup whole database every day.  But when i check the backup location, t=
hen
> there is no any backup file created. I create on script and I give this
> script location in the definition tab of step window.  My script is
> following :
>=20
> #!/bin/bash
> #backup directory can be file server share that the PgAgent daemon account
> has access to
> BACKUPDIR=3D"/opt/dailybackup"
> PGHOST=3D"localhost"
> PGUSER=3D"enterprisedb"
> PGBIN=3D"/opt/PostgresPlus/9.0AS/bin"
> thedate=3D$(date +%Y-%m-%d-%H)
> themonth=3D$(date +%Y-%m)
>=20
> #Create a full backup of the server database
> $PGBIN/pg_dumpall -h $PGHOST -U $PGUSER | gzip >
> $BACKUPDIR/fullbackup-$themonth.sql.gz
>=20
> #put the names of the database you want to create an individual backup be=
low
> dbs=3D(edb bench_replication bench_parallel pgpool)
>=20
> #iterate thru dbs in dbs array and backup each one
> for db  in ${dbs[@]}
> do
>         $PGBIN/pg_dump -i -h $PGHOST -U $PGUSER -F c -b -v -f
> $BACKUPDIR/$db-$thedate.compressed $db
> done
>=20
> But this is not create backup file.
>=20
> So please give a solution for that.
>=20
> Regards,
> karuna karpe.
>=20


=2D-=20
Achilleas Mantzios