PDA

View Full Version : Error backing up database in PGAdmin



Superbibi
04-22-2010, 12:19 PM
Hi,

I get the following error when trying to back up my HEM DB in PGAdmin.
I know it's a PostgreSQL error and not an HEM one but could you help me finding what line I need to add in the pg_hba.conf file for the backup to work ?


C:/Program Files (x86)/PostgreSQL/8.4/bin\pg_dump.exe --host localhost --port 5432 --username postgres --format custom --blobs --verbose --file "D:\HEM.backup" "DBSelf"
pg_dump: [programme d'archivage (db)] la connexion à la base de données « DBSelf » a échoué : FATAL: aucune entrée dans pg_hba.conf pour l'hôte « ::1 », utilisateur « postgres »,
base de données « DBSelf », SSL inactif
pg_dump: *** interrompu du fait d'erreurs

Le process a retourné le code de sortie 1.

morny
04-22-2010, 08:52 PM
Not too sure attach your pg_hba.conf file and ill compare it to mine

Superbibi
04-23-2010, 09:42 AM
I changed the extension to .txt as .conf is not valid for attachments.

morny
04-23-2010, 08:48 PM
Add this at the bottom of the file and save it and try restarting postgreSQL then and see if theres any errors

host all all ::1/128 md5

Superbibi
04-24-2010, 08:03 AM
It worked, thanks a lot.

fozzy71
04-24-2010, 12:41 PM
I changed the extension to .txt as .conf is not valid for attachments.

You should be able to attach the .conf files in the future. I just added support to the forums.