| 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: | Whole Thread | Raw Message | 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 |