X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39885D9189 for ; Fri, 16 Sep 2005 15:30:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34631-04 for ; Fri, 16 Sep 2005 18:30:30 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by svr1.postgresql.org (Postfix) with ESMTP id BDAF8D916C for ; Fri, 16 Sep 2005 15:30:27 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id j2so267230nzf for ; Fri, 16 Sep 2005 11:30:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=sOvuD1YIx/r0t64fTeyXk+PrJQrUF20iFS9if/smYC27/riFg/ziYXWLfvGjWIvsEa16itOaSJlMo7bt5xKu0G0W6dZDBGd7TWPPw2w29RJyOW16pFJoYuFdHedYmK8TmyJsuNMI2GZ1UNMRfvD0qYeSo6GKFh440NzZm/AGJEo= Received: by 10.36.96.3 with SMTP id t3mr551825nzb; Fri, 16 Sep 2005 11:30:26 -0700 (PDT) Received: by 10.36.34.9 with HTTP; Fri, 16 Sep 2005 11:30:26 -0700 (PDT) Message-ID: <35b7725f050916113056ade940@mail.gmail.com> Date: Fri, 16 Sep 2005 13:30:26 -0500 From: J French Reply-To: hikenboots@gmail.com To: pgsql-admin@postgresql.org Subject: pg_dumpall - Need advice Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33953_28299011.1126895426373" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.132 required=5 tests=[HTML_60_70=0.027, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.08, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/190 X-Sequence-Number: 18927 ------=_Part_33953_28299011.1126895426373 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I need to write a database dump/backup shell script to cron but I can't see= m=20 to get pg_dumpall working. Could someone who has this working take a look a= t=20 my configuration below and give me some pointers? It would appear that=20 "/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env:= =20 No such file or directory " would be a big tip off except I can't find that= =20 file on my system and have no idea what it is/does. I'm new to postgresql= =20 (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:= =20 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.255ident 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 ------=_Part_33953_28299011.1126895426373 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 w= ould appear that "/usr/lib/postgresql/bin/readpgenv: line 2: /etc/post= gresql/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 i= t is/does.  I'm new to postgresql (obviously).  Thanks for your t= ime. -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 Po= stgreSQL
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/p= ostgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such fi= le or directory
postgres@debian:~$
 
 
Contents of /etc/postgresql:
# TYPE  DATABASE    USER    &n= bsp;   IP-ADDRESS        IP-MA= SK           METHOD
# = Database administrative login by UNIX sockets
local   all = ;        postgres    = ;            &n= bsp;            = ;           ident sameuse= r
#
# All other connections by UNIX sockets
local   all =         all     = ;            &n= bsp;            = ;            &n= bsp;  ident sameuser
#
# All IPv4 connections from localhost
= host    all         = all         127.0.0.1         255.255.255.255   ident sameuser
hos= t    all         all=          0.0.0.0           0.0.0.0      &nb= sp;    md5
#
# All IPv6 localhost connections
host    all&nbs= p;        all    &nb= sp;    ::1        &n= bsp;      ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff&= nbsp;       ident sameuser
host  = ;  all         all  =        ::ffff: 127.0.0.1/128         &nbs= p;      ident sameuser
#
# reject all other = connection attempts
host    all    &n= bsp;    all         = 0.0.0.0      &= nbsp;    0.0.0.0  &= nbsp;        reject
 
------=_Part_33953_28299011.1126895426373--