Rapidpro in ubuntu 14.04 server

[Schyns Bahati]

Hi guys, 

i have been trying to setup RapidPro for a week now on our ubuntu 14.04 server.

am stack at installing postgresql... 

below is the code.. someone help me

....

ubuntu@ubuntu:~$ ubuntu@ubuntu:~$ sudo service postgresql start

ubuntu@ubuntu:~$: command not found

ubuntu@ubuntu:~$  * Starting PostgreSQL 9.3 database server                                            [ OK ]

-: command not found

ubuntu@ubuntu:~$ ubuntu@ubuntu:~$ sudo -u postgres psql postgres

ubuntu@ubuntu:~$: command not found

ubuntu@ubuntu:~$ psql (9.3.10, server 9.3.11)

-bash: syntax error near unexpected token `9.3.10,'

ubuntu@ubuntu:~$ Type "help" for help.

No command 'Type' found, did you mean:

 Command 'pype' from package 'pype' (universe)

Type: command not found

ubuntu@ubuntu:~$

ubuntu@ubuntu:~$ postgres=# \c temba

c: command not found

ubuntu@ubuntu:~$ psql (9.3.10, server 9.3.11)

-bash: syntax error near unexpected token `9.3.10,'

ubuntu@ubuntu:~$ You are now connected to database "temba" as user "postgres".

You: command not found

ubuntu@ubuntu:~$ temba=# create extension postgis

No command 'create' found, did you mean:

 Command 'pcreate' from package 'python-pyramid' (universe)

 Command 'pcreate' from package 'pbuilder-scripts' (universe)

create: command not found

ubuntu@ubuntu:~$ temba-# create extension postgis;

temba-#: command not found

ubuntu@ubuntu:~$ ERROR:  syntax error at or near "create"

ERROR:: command not found

ubuntu@ubuntu:~$ LINE 2: create extension postgis;

LINE: command not found

ubuntu@ubuntu:~$         ^

^: command not found

ubuntu@ubuntu:~$ temba=# create extension postgis_topology;

No command 'create' found, did you mean:

 Command 'pcreate' from package 'pbuilder-scripts' (universe)

 Command 'pcreate' from package 'python-pyramid' (universe)

create: command not found

ubuntu@ubuntu:~$ ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/postgis_topology.control": No such file or directory

ERROR:: command not found

ubuntu@ubuntu:~$ temba=# create extension postgis;

No command 'create' found, did you mean:

 Command 'pcreate' from package 'pbuilder-scripts' (universe)

 Command 'pcreate' from package 'python-pyramid' (universe)

create: command not found

ubuntu@ubuntu:~$ ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/postgis.control": No such file or directory

ERROR:: command not found

ubuntu@ubuntu:~$ temba=# ^C

^C: command not found

ubuntu@ubuntu:~$ temba=# ^C

^C: command not found

ubuntu@ubuntu:~$ temba=# ^C

^C: command not found

ubuntu@ubuntu:~$ temba=#

ubuntu@ubuntu:~$ clear

ubuntu@ubuntu:~$ sudo service postgresql restart

 * Restarting PostgreSQL 9.3 database server                                          [ OK ]

ubuntu@ubuntu:~$ sudo -u postgres psql postgres

psql (9.3.10, server 9.3.11)

Type "help" for help.

postgres=# \c temba

psql (9.3.10, server 9.3.11)

You are now connected to database "temba" as user "postgres".

temba=# create extension postgis;

ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/postgis.control": No such file or directory

temba=# create extention postgis;

ERROR:  syntax error at or near "extention"

LINE 1: create extention postgis;

               ^

temba=# create extension postgis;

ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/postgis.control": No such file or directory

temba=#

[Norbert Kwizera]

Hey Bahati,

It seems you are missing PostGIS installation, Check http://postgis.net/install/

for more.

Norbert

[Haytham Amin]

so this might be helpful https://help.ubuntu.com/community/PostgreSQL. Also, to install postgis in command line type : sudo apt-get install postgis* this will make sure you install all its dependencies.