Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

4

PostgreSQL is not running after installing OpenERP 7 All-in-One on Windows

By
juliejul
on 2/21/13, 10:18 AM 12,877 views

I installed openerp7.0 with postgresql all in one but no error during installation then when I run the openerp this message is displayed:

"operational error: could not connect to server connection refused (0x000027 \ 10061) the server running on host "localhost" and 127.0.0.1 is not accepting tcp \ ip connection on port 5432)

1

Cyril Gaspard (GEM)

--Cyril Gaspard (GEM)--
4136
| 5 6 8
Paris, France
--Cyril Gaspard (GEM)--

Forum contributor since 2008

Cyril Gaspard (GEM)
On 3/2/13, 5:11 PM

Hi, I done a script clean_openerp_uninstall.cmd which clean by cicking on the file, all files folders and registry key to clean uninstall of openerp allinone with postgresql uninstall too.

It was for version 6.0 and for my user windows Administrateur for uninstalled postgresql 8.4 and 9.0 ... but you can adapt it for niew versions, see the code in my file clean_openerp_uninstal.cmd :

:: begin

:: Disabled/Enable echoing

@echo off

@rmdir /S /Q C:\Users\openpgsvc

@rmdir /S /Q C:\Users\Administrateur\AppData\Roaming\postgresql

@rmdir /S /Q "C:\program files\openerp 6.0"

@rmdir /S /Q "D:\openerp 6.0"

@del /F C:\Users\Administrateur.openerprc

@del /F C:\Users\Administrateur.openerprc-6.0

@del /F C:\Users\Administrateur\openerp-client.log

@del /F C:\Users\Administrateur\openerp-client-6.0.log

@reg delete "HKLM\SOFTWARE\OpenERP All In One" /f

@reg delete "HKLM\SOFTWARE\PostgreSQL Global Development Group" /f

@reg delete "HKLM\SOFTWARE\PostgreSQL" /f

@reg delete "HKLM\SYSTEM\ControlSet001\Services\postgresql-8.4" /f

@reg delete "HKLM\SOFTWARE\SOFTWARE\PostgreSQL\Installations" /f

@reg delete "HKLM\SOFTWARE\SOFTWARE\PostgreSQL\Services" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\openerp-service" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\openerp-web" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\openerp-service" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\openerp-web" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\pgAgent" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\PostgreSQL" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\pgsql-8.3" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\openerp-server-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\Eventlog\Application\openerp-web-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\openerp-server-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet011\Services\openerp-web-6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP Client" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP Server" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP Web" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\App Management\ARPCache\OpenERP 6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\PostgreSQL 8.4" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\PostgreSQL 9.0" /f

@reg delete "HKLM\SOFTWARE\OpenERP GTK Client 6.0" /f

@reg delete "HKLM\SOFTWARE\OpenERP Server 6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet001\Services\postgresql-9.0" /f

@reg delete "HKLM\SOFTWARE\OpenERP Web Client 6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet003\Services\PostgreSQL-For-OpenERP" /f

@reg delete "HKLM\SYSTEM\ControlSet003\Services\postgresql-9.0" /f

@reg delete "HKLM\SYSTEM\ControlSet003\Services\Eventlog\Application\PostgreSQL" /f

@reg delete "HKCR.openerprc" /f

@reg delete "HKCR.openerprc-6.0" /f

@reg delete "HKCR\openerprc_auto_file" /f

@reg delete "HKCR\Applications\pgAdmin3.exe" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\App Management\ARPCache\PostgreSQL 9.0" /f

@reg delete "HKCU\Software\Classes\openerprc_auto_file" /f

@reg delete "HKCU\Software\pgAdmin III" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\PostgreSQL 8.3" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts.openerprc" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts.openerprc-6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP GTK Client 6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP Web Client 6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs\OpenERP Server 6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\openerp-server-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\openerp-service" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\openerp-web" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\openerp-web-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\openerp-server-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\openerp-service" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\openerp-web" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\openerp-web-6.0" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\pgAgent" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\Eventlog\Application\PostgreSQL" /f

@reg delete "HKLM\SYSTEM\ControlSet010\Services\pgsql-8.3" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\App Management\ARPCache\OpenERP Server 6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\App Management\ARPCache\OpenERP Web Client 6.0" /f

@reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\App Management\ARPCache\OpenERP GTK Client 6.0" /f

pause

::end

you can also use software like ccleanr or glary utilities, but just delete before manually :

@rmdir /S /Q C:\Users\openpgsvc

@rmdir /S /Q C:\Users\Administrateur\AppData\Roaming\postgresql

@rmdir /S /Q "C:\program files\openerp 6.0"

@rmdir /S /Q "D:\openerp 6.0"

C:\Users\Administrateur.openerprc

C:\Users\Administrateur.openerprc-6.0

C:\Users\Administrateur\openerp-client.log

C:\Users\Administrateur\openerp-client-6.0.log

Bye

0

Andreas Brueckl

--Andreas Brueckl--
5056
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 3/1/13, 6:00 AM

I had the same problem.

If you have installed PostgreSQL before (I do not know how the OpenERP-Installer detects this), then the OpenERP-Installer does not allow to install PostgreSQL.

You have download and install PostgreSQL manually:

How the OpenERP installer detects this is explained in the bug report I mentioned in my answer. If you want more information have a look at https://bugs.launchpad.net/openobject-server/+bug/1115119

Olivier Dony (odo)
on 3/1/13, 6:56 AM
0

Olivier Dony (odo)

--Olivier Dony (odo)--
2112
| 7 6 7
--Olivier Dony (odo)--

 

Olivier Dony (odo)
On 2/22/13, 8:12 AM

PostgreSQL does not seem to be running on your computer. You should check the Windows services and verify that no previous version of PostgreSQL was uninstalled. If you uninstalled an older version of PostgreSQL, please install a new one by downloading the installer from www.PostgreSQL.org directly. OpenERP's all-in-one installer will not reinstall PostgreSQL in that case (this is a known bug for v7)

Hi, it possible that postgresql is uninstalled but installer doesn't install postgresql, because the user postgres is not deleted, some files are not deleted in roaming folder and it subsist a lot of keys in registry. Clean all that and postgresql will be installed with openerp installer. Bye

Cyril Gaspard (GEM)
on 2/28/13, 9:17 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 2/21/13, 10:18 AM
Seen: 12877 times
Last updated: 3/16/15, 8:10 AM