Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A4FA22E0046; Thu, 22 Nov 2007 10:01:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 18874-03; Thu, 22 Nov 2007 10:01:51 -0400 (AST) Received: from smtp.weisshuhn.net (snat.weisshuhn.net [87.193.194.94]) by postgresql.org (Postfix) with ESMTP id 197002E004F; Thu, 22 Nov 2007 10:00:45 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp.weisshuhn.net (Postfix) with ESMTP id 31E9D6C3C9; Thu, 22 Nov 2007 14:00:43 +0000 (UTC) X-Virus-Scanned: amavisd-new at weisshuhn.de Received: from smtp.weisshuhn.net ([127.0.0.1]) by localhost (nazgul.intranet.weisshuhn.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RGK59KWBU6JA; Thu, 22 Nov 2007 15:00:42 +0100 (CET) Received: from chuckie.intranet.weisshuhn.de (chuckie.intranet.weisshuhn.de [192.168.17.167]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.weisshuhn.net (Postfix) with ESMTP id 2940F1634; Thu, 22 Nov 2007 15:00:42 +0100 (CET) Message-ID: <47458B84.7000503@weisshuhn.de> Date: Thu, 22 Nov 2007 15:00:36 +0100 From: Frank Wittig Organization: =?ISO-8859-1?Q?Wei=DFhuhn_=26_Wei=DFhuhn_Kommunikatio?= =?ISO-8859-1?Q?nsmanagement_GmbH?= User-Agent: Thunderbird 2.0.0.9 (X11/20071115) MIME-Version: 1.0 To: "Sorin N. Ciolofan" CC: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] backup of postgres scheduled with cron References: <20071122131908.F1D0F8E40FC@mailhost.ics.forth.gr> In-Reply-To: <20071122131908.F1D0F8E40FC@mailhost.ics.forth.gr> X-Enigmail-Version: 0.95.5 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigDA4208E6AF9E000F129DA0CE" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/197 X-Sequence-Number: 27440 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigDA4208E6AF9E000F129DA0CE Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello Sorin! Sorin N. Ciolofan wrote: > #!/bin/bash > time=3D`date '+%d'-'%m'-'%y'` > cd /home/swkm/services/test > pg_dump mydb > mydb_dump_$time.out You should output STDERR to some error logfile or set MAILTO in your crontab. I guess you then would have seen an error message saying that pg_dump was not found because cron doesn't load the users environment and therefore PATH variable isn't set. I suggest you call pg_dump in your script by absolute path. Greetings, Frank Wittig --------------enigDA4208E6AF9E000F129DA0CE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFHRYuJx6tzaD9P7mkRAvgPAJ4+DuQzXRK/H26j2xepp4OlGYzHLQCfTS8L zbZlt7ZoOW1OG2y7FyMTnjM= =ei9s -----END PGP SIGNATURE----- --------------enigDA4208E6AF9E000F129DA0CE--