Skip to Content
This question has been flagged
communitymodulesappspostgresqlgeospatial
1 Reply
8363 Views
Avatar
usernamev

Hi, im running odoo 10 at linux.

Im trying to install the Geospatial Support module, already installed all depencies, but when click on installing this message pops up:

"Error, can not automatically initialize spatial postgis support. Database user may have to be superuser and postgres/postgis extentions with their devel header have to be installed. If you do not want Odoo to connect with a super user you can manually prepare your database. To do thisopen a client to your database using a super user and run:
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;"

What can i do?

Thanks for reading.

Avatar
Discard
Ermin Trevisan

You do exactly what is written in the error message.

Avatar
CHAREF Abdelmoula
Best Answer

HI!

First of all You have to install Postgis as mentioned in geospatial module description

so run the command:sudo apt-get install postgis
But postgis depends on some other libraries like:

so you may encounter some problems during the installation 

so I recommend u this tutorial on how to install PostGIS and choose the right version you might need:

https://computingforgeeks.com/how-to-install-postgis-on-ubuntu-debian/

after the installation you are now able to create the two extensions needed to initiate this module on your database manually

these are some easy steps to  follow

1- connect as user postgres :sudo su postgres 

2-Switch to psql  by running:psql

3-Connect to your database:\c database_name ;

4-Run :

       CREATE EXTENSION postgis;

       CREATE EXTENSION postgis_topology;

   hope this helps someone,        

Avatar
Discard
Related Posts Replies Views Activity
How to create a basic module Solved
community modules models postgresql Odoo13.0
Avatar
Avatar
2
Nov 20
5082
Not showing all modules
modules apps
Avatar
Avatar
Avatar
2
Mar 15
6397
Where can I post a review and a rating for an app or module?
modules apps
Avatar
0
Mar 15
5116
how-to clone and use Modules of the OCA (an others maybe)?
community modules
Avatar
Avatar
Avatar
2
Mar 15
19610
Odoo Apps, Modules & Licensing FAQ Solved
modules apps license
Avatar
3
Apr 23
47054