From: Josh <jtnews@exciteworks.com>
To: pgsql-admin@postgresql.org
Subject: running pg_dumpall as superuser fails
Date: Sun, 07 Mar 2004 11:46:02 -0800
Message-ID: <404B7BFA.8030605@exciteworks.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jtnews@exciteworks.com
Subject: Re: running pg_dumpall as superuser fails
In-Reply-To: <404B7BFA.8030605@exciteworks.com>
References: <404B7BFA.8030605@exciteworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox