From: | Josh <jtnews(at)exciteworks(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | running pg_dumpall as superuser fails |
Date: | 2004-03-07 19:46:02 |
Message-ID: | 404B7BFA.8030605@exciteworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ruprecht | 2004-03-07 19:47:17 | Re: How to do fast, reliable backups? |
Previous Message | Joe Conway | 2004-03-07 18:19:50 | Re: pgcrypto and database encryption |