跳至內容
選單
此問題已被標幟
6 回覆
29355 瀏覽次數

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)

頭像
捨棄
最佳答案

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

頭像
捨棄
最佳答案

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.

頭像
捨棄
最佳答案

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

最佳答案

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

相關帖文 回覆 瀏覽次數 活動
1
1月 24
13424
2
3月 15
7488
7
12月 23
30495
1
3月 15
5099
1
3月 15
4047