This question has been flagged
6 Replies
27644 Views
windowsinstallv7
Avatar
juliejul

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)

Avatar
Discard
Avatar
Cyril Gaspard (GEM)
Best Answer

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

Avatar
Discard
Avatar
Umair Fayyaz
Best Answer

If you want to reinstall odoo and postgresql please do follow those step which mention on this link.

https://itdip.com/how-to-reinstall-odoo-11-and-postgresql-in-windows/


Hope your issue will be solved.

Avatar
Discard
Avatar
Andreas Brueckl
Best Answer

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:

Avatar
Discard
Olivier Dony (odo)

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

Avatar
Olivier Dony (odo)
Best Answer

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)

Avatar
Discard
Cyril Gaspard (GEM)

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