Browsed by
Month: July 2012

How to install pgRouting in Windows.

How to install pgRouting in Windows.

Assalamualaikum, I ran through a day trying to get everything works for PostgreSQL 9.1, PostGIS 2.0 & pgRouting 1.03. But so far, pgRouting not working when run in Windows, missing librouting.dll when execute the SQL file provided from pgRouting page, even thought the library is there…not sure why…so I skip the part investigating this issue. And for you Ubuntu, i’m pretty sure it’s working fine with PostgresSQL 9.1 version even thought am yet try to install it. 😉 For Windows,…

Read More Read More

How to reset user’s password in PostgreSQL using Terminal

How to reset user’s password in PostgreSQL using Terminal

Assalamualaikum, A quick solution to reset PostgreSQL user’s password. Just run following commands after open up the terminal window: sudo su – postgres psql -d template1 template1=# ALTER USER postgres WITH PASSWORD ‘some password’g template1=# q Then login as usual. 🙂 p/s: I’m using psql 9.1 & ubuntu 12.04 LTS. 🙂 Regards, Nas