Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

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

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

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

Naroči se

Get notified when there's activity on this post

This question has been flagged
windowsinstallv7
6 Odgovori
31183 Prikazi
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)

4
Avatar
Opusti
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

1
Avatar
Opusti
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.

0
Avatar
Opusti
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:

  • 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
0
Avatar
Opusti
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)

0
Avatar
Opusti
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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
How to Install from source in windows? Solved
windows install v7
Avatar
Avatar
1
jan. 24
14718
All in one v7 windows install one click apps
windows install v7 app
Avatar
Avatar
2
mar. 15
8749
XmlHttpRequestError in web-client when connecting via IP Solved
windows v7
Avatar
Avatar
Avatar
Avatar
Avatar
7
dec. 23
32238
How is the All-in-one Windows installer built from source?
windows v7
Avatar
Avatar
1
mar. 15
6536
don't see all the modules in addons only the web modules in v7 windows
windows v7
Avatar
Avatar
1
mar. 15
5373
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now