Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
회계
재고 관리
PoS
프로젝트
MRP

All apps

모든 게시물 사용자 배지

태그 (모두 보기)

odoo accounting v14 pos v15

게시판 정보

도움말

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

windows install v7

6 답글

31200 화면

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)

Cyril Gaspard (GEM)

베스트 답변

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

Umair Fayyaz

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.

Andreas Brueckl

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:

Download from http://www.enterprisedb.com/products-services-training/pgdownload#windows (version 9.1 or 9.2, I used 9.2)
Install
Download and install pgAdmin3 (http://www.pgadmin.org/download/windows.php)
Open pgAdmin and connect to PostreSQL-Server
Create new Login role 'openerp'
Instead of pgAdmin you can also create the new role from the command line (see http://stackoverflow.com/questions/5189026/how-to-add-a-user-to-postgresql-in-windows)
Setup the DB-Connection in openerp-server.conf file
Restart OpenERP-Server

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

Olivier Dony (odo)

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)

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

토론이 재미있으신가요? 직접 참여해보세요!

지금 바로 가입하여 독점 서비스를 이용해보고 특별한 커뮤니티와 소통하세요!

가입

관련 게시물	답글	화면
How to Install from source in windows? 해결 완료 windows install v7	1 1월 24	14735
All in one v7 windows install one click apps windows install v7 app	2 3월 15	8767
XmlHttpRequestError in web-client when connecting via IP 해결 완료 windows v7	7 12월 23	32261
How is the All-in-one Windows installer built from source? windows v7	1 3월 15	6549
don't see all the modules in addons only the web modules in v7 windows windows v7	1 3월 15	5378

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!