Hi

I had the same problem that trying to backup the db on v5 would give a "could 
not connect to server" error. 

The problem was resolved by following patdec's instructions above (thanks!).

Here are some clarifications in case anyone is having problems:

1. The file pg_hba.conf is located in the data directory of the posgreSQL 
instalation, which is located in the "OpenERP All-in-one" directory for the 
all-in-one windows installation. From the standard file, you just need to 
change the word "md5" to "trust" (there are probably security issues here but I 
am ignorant of them)

2. You need to create a file called pgpass.conf (in fact you can probably call 
it anything). Copy the text line patdec suggests and store the file anywhere.

3. In Control Panel | System, find the "Environment Variables" button. Create a 
new _system_ environment variable called PGPASSFILE. The value is the full path 
of the pgpass file you created, eg. "c:\program files\OpenERP 
all-in-one\pgpass.conf"  (if your path has spaces in it you probably NEED the 
quotes)

4. I found it necessary to restart my entire machine after making the changes 
(I tried just stopping and starting the posgreSQL and OpenERP services but this 
didn't work)

That's it.

When you restore the database created, it gives you the option to restore the 
database to a new name (i.e. create a copy)




-------------------- m2f --------------------

--
http://www.openobject.com/forum/viewtopic.php?p=42853#42853

-------------------- m2f --------------------


_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman2/listinfo/tinyerp-users

Reply via email to