X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6CAB9D1DB51 for ; Sun, 7 Mar 2004 19:46:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92709-10 for ; Sun, 7 Mar 2004 15:46:06 -0400 (AST) Received: from osiris.exciteworks.com (unknown [69.10.145.194]) by svr1.postgresql.org (Postfix) with ESMTP id B8B3DD1DB5B for ; Sun, 7 Mar 2004 15:46:03 -0400 (AST) Received: (qmail 15757 invoked from network); 7 Mar 2004 19:46:53 -0000 Received: from 44b92819.knnwck.wa.charter.com (HELO exciteworks.com) (68.185.40.19) by cf61.exciteworks.com with SMTP; 7 Mar 2004 19:46:53 -0000 Message-ID: <404B7BFA.8030605@exciteworks.com> Date: Sun, 07 Mar 2004 11:46:02 -0800 From: Josh User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: running pg_dumpall as superuser fails Content-Type: multipart/alternative; boundary="------------080205040302010002050601" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/110 X-Sequence-Number: 12679 This is a multi-part message in MIME format. --------------080205040302010002050601 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hello, I am trying to figure out how to get pg_dumpall to work. My ultimate goal is to get this running as a cron to backup the DBs nightly. By the way, I am running PostgreSQL 7.2.4 on redhat 7.3. My problem is with authentication. I think it ultimately has to do with my pg_hba.conf file. I am doing this in my shell script: export PGUSER=superuser export PGPASSWORD=passwd (with the real user and passwd of a super user of course) and the script always bombs saying that the password authentication fails for the user on the database. I am using plesk 6.0.2 as my contorl panel for hosting, and it creates entries in my pg_hba.conf file like so: local mydb1 password usrs_mydb1 local mydb2 password usrs_mydb2 local mydb3 password usrs_mydb3 I think this conflicts with running pg_dumpall as a super user. What can I do to allow the superuser to run pg_dumpall? Any help is greatly appreciated! --Josh --------------080205040302010002050601 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
Hello,

I am trying to figure out how to get pg_dumpall to work.  My ultimate goal is to get this running as a cron to backup the DBs nightly.

By the way, I am running PostgreSQL 7.2.4 on redhat 7.3.

My problem is with authentication. I think it ultimately has to do with my pg_hba.conf file.

I am doing this in my shell script:

export PGUSER=superuser
export PGPASSWORD=passwd

(with the real user and passwd of a super user of course)

and the script always bombs saying that the password authentication fails for the user on the database.

I am using plesk 6.0.2 as my contorl panel for hosting, and it creates entries in my pg_hba.conf file like so:

local   mydb1        password        usrs_mydb1
local   mydb2        password        usrs_mydb2
local   mydb3        password        usrs_mydb3

I think this conflicts with running pg_dumpall as a super user.

What can I do to allow the superuser to run pg_dumpall?

Any help is greatly appreciated!

--Josh




--------------080205040302010002050601--