pg_dumpall - Need advice - Mailing list pgsql-admin

From J French
Subject pg_dumpall - Need advice
Date
Msg-id 35b7725f050916113056ade940@mail.gmail.com
Whole thread Raw
Responses Re: pg_dumpall - Need advice  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
I need to write a database dump/backup shell script to cron but I can't seem to get pg_dumpall working.  Could someone who has this working take a look at my configuration below and give me some pointers?  It would appear that "/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such file or directory " would be a big tip off except I can't find that file on my system and have no idea what it is/does.  I'm new to postgresql (obviously).  Thanks for your time. -John
 
 
debian:~# dpkg -l | grep postgresql
ii  postgresql     7.4.7-6sarge1  object-relational SQL database management sy
ii  postgresql-cli 7.4.7-6sarge1  front-end programs for PostgreSQL
debian:~#
 
 
debian:~# uname -a
Linux debian 2.4.27-2-386 #1 Mon May 16 16:47:51 JST 2005 i686 GNU/Linux
debian:~# su postgres
postgres@debian:/root$ cd
postgres@debian:~$ pwd
/var/lib/postgres
postgres@debian:~$ pg_dumpall > testdump
/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such file or directory
postgres@debian:~$
 
 
Contents of /etc/postgresql:
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
# Database administrative login by UNIX sockets
local   all         postgres                                        ident sameuser
#
# All other connections by UNIX sockets
local   all         all                                             ident sameuser
#
# All IPv4 connections from localhost
host    all         all         127.0.0.1         255.255.255.255   ident sameuser
host    all         all         0.0.0.0           0.0.0.0           md5
#
# All IPv6 localhost connections
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        ident sameuser
host    all         all         ::ffff: 127.0.0.1/128                ident sameuser
#
# reject all other connection attempts
host    all         all         0.0.0.0           0.0.0.0           reject
 

pgsql-admin by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: Re: silent installation
Next
From: Jeff Frost
Date:
Subject: Re: pg_dumpall - Need advice