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: (view raw, whole thread or download thread mbox)
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:~# 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
postgres(at)debian:~$ pg_dumpall > testdump
/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: 
No such file or directory
  Contents of /etc/postgresql:
# 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 <><>ident sameuser
host all all <> <> md5
# All IPv6 localhost connections
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser
host all all ::ffff: <> ident sameuser
# reject all other connection attempts
host all all <> <> reject


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-2017 The PostgreSQL Global Development Group