BUG #4142: pg_dump will not work

Поиск
Список
Период
Сортировка
От Lee Ottaway
Тема BUG #4142: pg_dump will not work
Дата
Msg-id 200805041204.m44C4F2x091550@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4142: pg_dump will not work  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4142
Logged by:          Lee Ottaway
Email address:      lee@fusionsoftwareuk.co.uk
PostgreSQL version: 8.3.1
Operating system:   Vista
Description:        pg_dump will not work
Details:

I activate pg_dump from my application and pass it the following
parameters:

pg_dump --host="NameofPC" --port=5432 -U "admin" --compress=3 --format=c
--verbose --file="C:\ProgramData\Bridge-IT\backup.sql" "nameofdatabase"

This works perfectly on any Windows XP machine, however when I try it on a
Vista machine I get the following error:

Connection to database "nameofdatabase" failed: FATAL:  no_hba.conf entry
for host "fe80::e11a:753d:9916:1a28%8", user "admin", database
"nameofdatabase", SSL off

Now I know this related to IP addresses in some way, however I can connect
to the database perfectly on the Vista machine and from client machines
looking over the network, so how come everything can connect but pg_dump
can't??

I am using the following pg_hba.conf entries:

# IPv6 local connections:
host    all         all         ::1/128               md5
host    all         all         192.168.0.0      255.255.0.0      md5

Any ideas??

Thanks


Lee Ottaway
Fusion Software (UK) Ltd

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4141: Aliases in rules vanished, but they work
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #4142: pg_dump will not work