pg_dumpall - Need advice

Поиск
Список
Период
Сортировка
От J French
Тема pg_dumpall - Need advice
Дата
Msg-id 35b7725f050916113056ade940@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dumpall - Need advice
Список 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 по дате отправления:

Предыдущее
От: "Lane Van Ingen"
Дата:
Сообщение: Re: silent installation
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: pg_dumpall - Need advice