Another issue with pg_hba.conf file & dumpall
От | April Carvalho |
---|---|
Тема | Another issue with pg_hba.conf file & dumpall |
Дата | |
Msg-id | Pine.LNX.4.44.0401261657150.26251-100000@brave.cs.uml.edu обсуждение исходный текст |
Ответ на | Re: Problem with pg_hba.conf file in Postgres 7.3 (Oliver Elphick <olly@lfix.co.uk>) |
Список | pgsql-novice |
Can't thank you all enough for the help. :-) Here's another problem I'm having. I'm using pg_dumpall in a micro sized perl script to dump the entire db cluster. (All it did was save the password to an environment variable, and modified the backup file's name to include the date.) This script has been working on our old server for over a year. We're trying to get it to work with our new one, but with stricter security measures. (Our older one used ident, which our boss has now banned for the new one.) Unfortunately, I'm getting the following message back when trying to run it manually: pg_dump: [archiver (db)] connection to database "db1" failed: FATAL: No pg_hba.conf entry for host localhost, user postgres, database db1 and dies on the first database: pg_dumpall: pg_dump failed on db1, exiting The script is owned by postgres, pg_dumpall is owned by postgres, and is being run as user postgres with postgres' environment variables (i.e., su - postgres before execution.). So if it is a permissions issue with a file, it isn't obvious. Here's part of my pg_hba.conf file: local template1 postgres md5 local template1 all reject host all postgres 127.0.0.1 255.0.0.0 md5 hostssl template1 all 0.0.0.0 0.0.0.0 reject line #3 should be the one that pg_dumpall should be using. What am I doing wrong? The docs give examples, but not enough to get a handle on this problem. Again, any help would be greatly appreciated. April Carvalho
В списке pgsql-novice по дате отправления: