ERROR: GetProj4StringSPI: Cannot find SRID (4326) in spatial_ref_sys

If you are using postgis and a cleaner in your database, maybe you could have this error:

ERROR:  GetProj4StringSPI: Cannot find SRID (4326) in spatial_ref_sys
SQL state: XX000

This error means that your spatial_ref_sys table is empty
To fix it, just restore the information that postgis generate when you create this extension in your database.
To do it execute the following sentence:

psql -d $database_name -f $PATH/spatial_ref_sys.sql

where the PATH is the path to spatial_ref_sys.sql
For postgres 11 and postgis 2.5 the PATH is /usr/share/postgresql/11/contrib/postgis-2.5/

Other way to execute the same command is:

PGPASSWORD=postgres psql "host=localhost dbname=$database_name user=postgres" -f /usr/share/postgresql/11/contrib/postgis-2.5/spatial_ref_sys.sql

Enjoy it!

Comments

Post a Comment

Popular posts from this blog

How to fix Android when developer options are not available for this user

Image
I have an Android One with Oreo version and suddenly my Android rebooted and after that it started to behave strangely: 1) Notification section doesn't work. I can't see notifications from my apps and the arrow and the screw icon to settings access don't work. 2) As I can't access to the notification area, I can't enable Use USB to Transfer Files to access to my phone memory. 3) I can't access to developer mode (I before active it with a lot of taps over Build number). Clicking on developer options just shows developer options are not available to this user. 4) I can't update or install the apps on google play. They freeze on Download pending... message 5) Home and Switch buttons don't work. They light up and vibrate when I tap them but they do nothing. This issue is apparently related to a deconfiguration of user accounts. To fix it, you need re-setup the users. As you can't access to the user manager (you are in guest mode ...
Read more

How to install Matlab without GUI

If you want to install Matlab in a server, probably you don't have a GUI. To run the installer you need previosly configurate silent mode: ./install -mode silent Preparing installation files ... Installing ... (Nov 03, 2016 10:53:02) ################################################################## (Nov 03, 2016 10:53:02) (Nov 03, 2016 10:53:03) When running the installer with an input file, you must accept the license agreement by setting the agreeToLicense option to yes. (Nov 03, 2016 10:53:03) Exiting with status -2 (Nov 03, 2016 10:53:07) End - Unsuccessful. The previous error is because we need configurate all options, like if you are agree with the license agreement, enter the licence key, etc. To do this, you need to edit  installer_input.txt and  activate.ini files: In activate.ini these are the lines that you need configurate: isSilent=true activateCommand=activateOffline licenseFile=/root/Matlab_R2016a_glnxa64.lic In installer_input.txt these ...
Read more

Contiki 3.0 on XM1000

Image
In other post, I installer contiki 3.x on xm1000. Now, we going to install contiki 3.0 (the lastest version). First, you need to dowload the lastest code from github: git clone https://github.com/contiki-os/contiki.git Now we need to add xm1000 compatibility to our contiki. Thanks to DMI   for the xm1000 patch. Without it, you will see the following error: make: *** No rule to make target 'obj_xm1000/cc2420.o', needed by 'contiki-xm1000.a'.  Stop. I upgrade his patch with an app to access to the xm1000 sensors. Download it from https://drive.google.com/file/d/0B7NXiwmWq7jCb3ROSFZZSWliMnc/view?usp=sharing Now, extract it into contiki folder: tar xzvf xm1000.tar.gz cd xm1000 cp -R * $YOUR_CONTIKI_PATH Go to the apps folder and execute an script that I create to automate the process: cd $YOUR_CONTIKI_PATH/platform/xm1000/apps/sensors ./install.sh Enjoy it!
Read more