From: J French <hikenboots@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_dumpall - Need advice
Date: Fri, 16 Sep 2005 13:30:26 -0500
Message-ID: <35b7725f050916113056ade940@mail.gmail.com> (raw)
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 <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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: hikenboots@gmail.com
Subject: Re: pg_dumpall - Need advice
In-Reply-To: <35b7725f050916113056ade940@mail.gmail.com>
References: <35b7725f050916113056ade940@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox