Skip site navigation (1) Skip section navigation (2)

pg_dumpall in crontab

From: Werner Modenbach <modenbach(at)alc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dumpall in crontab
Date: 2002-06-21 06:35:37
Message-ID: 200206210835.41137.modenbach@alc.de (view raw or flat)
Thread:
Lists: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

I have a stange problem when executing pg_dumpall as a cron job.

The crontab entry looks like:
05 22 *  *  1-5 postgres /usr/bin/pg_dumpall -D > 
/disks/postgres/db.pg_dumpall

On stderr I get the message
connected to template1...
/usr/bin/pg_dumpall: 0: Bad file descriptor

The createt dumpfile looks like:
- --
- -- pg_dumpall (7.2)   -D
- --
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database 
WHERE datname = 'template0');

CREATE USER "werner" WITH SYSID 100 CREATEDB CREATEUSER;
CREATE USER ....                // more users

DELETE FROM pg_group;

There are no further lines in here.

When calling 
# /disks/postgres/db.pg_dumpall -D > /disks/postgres/db.pg_dumpall'
manually as user postgres the dumpfile continues like:

- --
- -- Database alc
- --
\connect template1 werner
CREATE DATABASE "alc" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';
etc. 
etc.

What is the reason for this strange behaviour?
I'm running PostgreSQL 7.2 on SuSE 7.2

- -- 
- --------------------------------------------------------------
	ALC Computertechnik GmbH
Kaiserstr. 100, D-52134 Herzogenrath, GERMANY
Fon +49 2407 95810
Fax +49 2407 958139
http://www.alc.de
- --------------------------------------------------------------
Werner Modenbach	   modenbach(at)alc(dot)de
- --------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9Esk83dsyHy9PfoYRAvSYAKCZIRJmGz6WGEQCJk6CO7FwS8IqlQCffbbt
OR2Z/TK6RkNbs6cb+nakt/A=
=H67X
-----END PGP SIGNATURE-----


pgsql-admin by date

Next:From: Davide BozzelliDate: 2002-06-21 09:00:39
Subject: lost superuser perms
Previous:From: Mark TessierDate: 2002-06-21 01:37:23
Subject: to reinstall or not reinstall postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group