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

pg_dumpall - Need advice

From: J French <hikenboots(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dumpall - Need advice
Date: 2005-09-16 18:30:26
Message-ID: 35b7725f050916113056ade940@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(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

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2005-09-16 18:58:50
Subject: Re: pg_dumpall - Need advice
Previous:From: Lane Van IngenDate: 2005-09-16 17:23:40
Subject: Re: silent installation

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