Tags » PostgreSQL

Catatan koneksi php ke sql

PHP merupakan bahasa pemrograman yang sering digunakan bersama database SQL seperti MySQL, PostgreSQL, dan sejenisnya. Pada tulisan ini admin menuliskan catatan teknis menghubungkan PHP dan SQL sebelum membangun aplikasi web PHP. 252 more words

Foreign Data Wrappers for PostGIS

SOURCE: PostGIS News

The last couple weeks have seen two interesting updates in the world of PostgreSQL “foreign data wrappers” (FDW). Foreign data wrappers allow you to access remote data inside your database, exactly like other tables. 97 more words

Geospatial

Create .dbf file with PostgreSql and Php

helloooo world…. :D
Dapet ilmu baru lagi nih, dapet tugas baru jadi nambah ilmu baru juga deh(alhamdulillah).
Hmm tadinya sempet kebingungan juga sih gimana caranya, ada n’ga toolsnya, trus saya-nya sendiri bisa n’ga?? 856 more words

Php

Yosemite, brew, and postgreSQL

After upgrading to Yosemite and deciding to create a new application on Heroku.com, I ran into some problems. I hope this might help someone get through the ‘gem pg’ issue I had. 212 more words

Ruby

Troubleshooting basic PostgreSQL Problems In Linux (RHEL)

Encountered 2 PostgreSQL problems today. One was about the wrong permission to opt/PostgreSQL/9.3/data directory.

# /etc/rc.d/init.d/postgresql-9.3 restart
Restarting PostgreSQL 9.3:
waiting for server to shut down…. 224 more words

Linux

viewshed analysis

I want a program that tells me which antenna is visible from any position. I want it for about 300 antennas in the city of Berlin… 637 more words

Qgis

Replication status in PostgreSQL 9.1

Execute on master:

select client_addr, state, sent_location, write_location, flush_location, 
replay_location from pg_stat_replication;

To show the lag, run the following on slave

 select now() - pg_last_xact_replay_timestamp() AS replication_delay; 
Technical