PDA

View Full Version : Posgressql backup don't work



herosista
07-24-2009, 03:55 AM
Hi,

I have problem with making backup of holdemmanger database.

this is error masage when i tring to make backup (pgadmin III)

C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h localhost -p 5432 -U elephant -F c -b -v -f "D:\23lipcaholdemmangerhbackup.backup" "HoldemManager"
pg_dump: [archiver (db)] connection to database "HoldemManager" failed: FATAL: no pg_hba.conf entry for host "::1", user "elephant", database "HoldemManager", SSL off
pg_dump: *** aborted because of error

Proces zwrócił kod wyjściowy 1.


pg_hba.conf



# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 trust

netsrak
07-24-2009, 05:47 AM
Remove the # at the beginning of this line: "#host all all ::1/128 trust "

and save the file