Hello, I created the extension you gave me previously to test with create extension file_fdw; on a new database but no result. Via Pgadmin you can add manually extension by clicking right on the database then choose extension and create the one you want from a list. Each one I tried rendered me the same issue.
> On Mar 25, 2019, at 4:08 PM, zakaria mouqcit <[email protected]> > wrote: > > Actually, I’ve just started working on this server and I was told that they > used to work with the 9.x version of postgresql then they decided to upgrade > it to 10.5. > > I don’t know how the upgrade was executed but I suspect it to be done in the > wrong way so that postgis is not working anymore. > > Most of databases on this server are not using Postgis extension except one > and it’s working fine so you can manipulate geometric data as you like, but > when you try to create a new db and activate postgis, it renders you the > previous error. > > To overcome this, I made a duplicate to this database and work with it for my > special needs. I believe that this issue must be solved so at this level I > have no clue. Do I have to backup all the databases and uninstall completely > Postgres and postgis as well and redo the installation or is there any quick > and safe way to solve this issue? > > I’m pretty lost with this. > > Thanks for your assistance > > > MOUQCIT Zakaria - Ingénieur géomaticien > Sige | Mapping and Virtual reality > > www.sige.ma <http://www.sige.ma/> > Bureau + 212 5 37 65 91 09 <tel:+%20212%205%2037%2065%2091%2009> > Mobile Maroc: +212 6 32 60 78 55 <tel:+%20212%207%2071%2093%2057%2038> > 32 Rue Ouled Ziane, Aviation, Rabat, Maroc Plan OSM > <http://osm.org/go/b4oZYrEhv--?layers=N&m=>, Gmaps > <https://www.google.fr/maps/place/Sige,+Soci%C3%A9t%C3%A9+d'ing%C3%A9nierie+g%C3%A9omatique+et+environnementale/@33.992439,-6.8260357,17z/data=!3m1!4b1!4m5!3m4!1s0xda76b6f50462d31:0xbf5c0d2cc4e237bc!8m2!3d33.992439!4d-6.823847> > Pour plus d'efficacité, nous consultons généralement nos e-mails à 11H et > 16H. Pour les sujets urgents, merci de nous contacter par téléphone. > >> On Mar 25, 2019, at 3:33 PM, zakaria mouqcit <[email protected] >> <mailto:[email protected]>> wrote: >> >>> CREATE EXTENSION file_fdw; >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
