Password for user "openpg" is "openpgpwd".

I have the same issue with this backup - restore in OpenERP 5.0 and this is the only way to work around it. It has something to do with the rights-management on the server though.

jlproductions
Password for user "openpg" is "openpgpwd".


Thank you very much. At least now I can back up even if it is not by the "proper" route.

You need to edit this file:

pg_hba.conf
http://www.postgresql.org/docs/8.3/stat ... -conf.html
ie:


and add this:
pgpass.conf
http://www.postgresql.org/docs/8.3/stat ... gpass.html
ie:

Don't forget to add the environment variable:
variable: PGPASSFILE
value: path to pgpass.conf
[/quote]

Could you be more specific for the non-technical - where exactly does this go? Windows? postgresql? OpenERP?

For the record I am having the same problem and I am also unable to get the database backed up via pgadmin - it exits complaining of version mismatch or something.

Hi.

On linux version mismatch occurs when you upgrade (esp. on rpm-based distributions) and PG_VERSION links to old version. On windows it occurs if pg_dump you are using does not match Postgres version (check if you have two installations of postgres). From pgadmin go to File > Options and verify PG bin path. However, you can instruct pg_dump to ignore version mismatch (using -i or --ignore-version) if running from command line.

Cheers.

Mugoma,
Yengas.



forum-user@tinyerp.org wrote:

@ Strannik

My post is related to Windows.

http://vlaurie.com/computers2/Articles/environment.htm

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)

On Ubuntu (Hardy) the pgpass.conf file is called .pgpass and is located in the root of the user that openerp is running under (normally, openerp)



and add



(the 5432 is the port where postgres is listening. 5432 is the standard port.)

The change to pg_hba.conf is the same on Windows & Linux.

You dont have to set an environment variable on Ubuntu.

Hello,

I had the problem with the database backup on Ubuntu 9.10 I becam a backup file with size 0, but as described I created a .pgpass file on /home/openerp and not on my user account and now it works.

The next problem is after restore this database under another new database name, I receive the error message:



In the postgres log file there are following error entries:



All tables are succesfully created, I see this on the postgres log file and with the tool pgadmin3.

Somebody has an idea how can I restablish a restore database?

Regards
red

create the new DB name first, then restore into it?

I am having the same trouble and



does not work (displays a "Impossible to create database" message). Is there anyone who got into the same situation and managed to solve it without going into pgadmin ?