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(at)debian:/root$ cd
postgres(at)debian:~$ pwd
/var/lib/postgres
postgres(at)debian:~$ pg_dumpall > testdump
/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env:
No such file or directory
postgres(at)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 <http://127.0.0.1>
255.255.255.255<http://255.255.255.255>ident sameuser
host all all 0.0.0.0 <http://0.0.0.0> 0.0.0.0 <http://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 <http://127.0.0.1/128> ident sameuser
#
# reject all other connection attempts
host all all 0.0.0.0 <http://0.0.0.0> 0.0.0.0 <http://0.0.0.0> reject