<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi everybody,<div><br></div><div>Sorry for asking about postgresql here. Maybe is not adequate at all but since I want it for spatial uses I thought it could be relevant. I've been researching a lot on the internet but I couldn't solve the issue. </div><div><br></div><div>I've installed the postgres.app and pgadmin III on my computer and I'm trying to create a database on the terminal (I know I can do it on pgAdmin III but I would like to learn the terminal way as well) and every attempt looks unsuccessful.</div><div><br></div><div>I have change my path to use the postgress.app instead the built one through: </div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> PATH="/Applications/Postgres.app/Contents/MacOS/bin:$PATH"</span></div><div><br></div><div>First, when I enter <span class="Apple-tab-span" style="white-space:pre"> </span>$ psql<span class="Apple-tab-span" style="white-space:pre"> </span>in the terminal it returns:<span class="Apple-tab-span" style="white-space:pre"> </span></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> psql: FATAL: role "</span>xusto<span class="Apple-tab-span" style="white-space:pre">" does not exist</span> (where xusto is my system username)</div><div><br></div><div>Researching on the web I found that is due to conflict between both copies of postgresql and that I have to connect via:</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-style-span" style="font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; white-space: pre; "><code style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; background-position: initial initial; background-repeat: initial initial; "><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 0); background-position: initial initial; background-repeat: initial initial; ">psql </span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 0); background-position: initial initial; background-repeat: initial initial; ">-</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 0); background-position: initial initial; background-repeat: initial initial; ">h localhost </span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 0); background-position: initial initial; background-repeat: initial initial; ">-</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 0); background-position: initial initial; background-repeat: initial initial; ">U postgres</span></code></span></div><div><font class="Apple-style-span" face="Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif" size="4"><span class="Apple-style-span" style="line-height: 18px; white-space: pre;"><br></span></font></div><div>So far so good. When I enter this command it returns me the following:</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> psql (9.0.10, server 9.1.8)
WARNING: psql version 9.0, server version 9.1.
Some psql features might not work.
Type "help" for help.
postgres=#</span></div><div><br></div><div>Even with the warning message I understand that I'm connected to postgresql. Nonetheless, when I enter <span class="Apple-tab-span" style="white-space:pre"> </span>"CREATE DATABASE mydb" it doesn't return anything. </div><div><br></div><div>Is there anything I am doing wrong?</div><div><br></div><div>Also I wanted to ask how can I do it to install the PostGIS?</div><div><br></div><div><br></div><div>Sorry again and thank you very much!</div><div><br></div><div>- jesus</div></body></html>