15/02/2013

PgAdminIII-PostGIS connection

Yes, I got in!
See, I created a test database and test table.
Sambungan PgAdminIII-PostGIS

Pada bulan lepas, setelah melabur komputer baru lalu dipertingkatkan status komputer lama ke tahap server, saya berjaya memasang PostgreSQL-PostGIS tanpa bantuan. Hari ni merupakan hari bertuah   kerana ini kali pertama saya berjaya menyambung klien-server. Selepas mengodek-godek PgAdmin III,saya berjaya menymbungnya dengan PostGIS dan mewujudkan pelbagai jenis pengguna, pangkalan data dan jadual. Pada langkah kedua, semalam, saya juga berjaya menyambung QGIS dengan PostGIS dengan setup yang sama di pejabat menggunakan komputer-server yang betul tapi belum lagi dirumah kerana terlalu lewat. Bagaimana pun, saya amat gembira dengan hasil cubaan ni.

PgAdminIII-PostGIS connection

Last month, having invested a new computer then upgrading my old computer to the status of a server, I successfully installed PostgreSQL-PostGIS on my own. Today is a great day for me because it is the first time I managed to secure a client-server connection. After tinkering with PgAdmin III, I managed to connect it to PostGIS then created different types of users, a database and table. In the next step, yesterday, I managed to link QGIS to PostGIS at the office equivalent setup but with a real client-server hardware though I haven't managed it yet at home because it's too late. Still, I'm very happy with myself.

Update:

I haven't got much further than this link for further reference.

4 comments:

  1. salam.. yes akhirnya... sifu.. sila tunjuk ajar ku sifu..... hehehehe

    ReplyDelete
    Replies
    1. Firstly, to setup the server, a clean Internet line is CRITICAL for downloads that's why we had problems with PostGIS. With my entry level Unifi package, no hiccups were experienced, line for line as what we did before. Secondly, you know to link server to the client we need a switch. At the office, is LAN managed by BTM,SUKN or BTM,HQ? Get them to dedicate a local IP address. My Unifi router has spare sockets so I also made it my switch. Configure the Unifi LAN setup to dedicate a static ip address then check with the server if it accepts that ip address by ifconfig (tak kan dah lupa ke) If, OK, ping to your server and sees if it pongs back. PgAdminIII is available at Ubuntu Software Centre, the details of setup, as usual, you will be charged 1 IKEA curry puff per question :-D (Yeah!)

      Delete
  2. Hi Abbas
    I want to install PostgreSQL/PostGIS With acute installation?
    thank you.

    ReplyDelete
    Replies
    1. It is complex and not something that cannot be easily explained over the Internet. You will need local help. Anyway, I am still struggling and have not fully accomplished this goal.

      Delete