Blogs1 - 10 of 569 recent posts for tag:PostgreSQL
10
Feb
2012
Building simple clients for MapFish — Underlying Infrastructure

1 day ago by smathermather

In order to build simple clients for the MapFish print service, we have to understand what the protocols are that are invoked and how they function. To do this we can read the MapFish Print Module Doc, and then modify and vamp from there. While I was going to joke that this would be an excellent cur ...

Smathermather's Weblog - smathermather.wordpress.com · 3 references

09
Feb
2012
Ditching GeoExt– building simple clients for MapFish

2 days ago by smathermather

I’ve been enamored with the GeoExt interface for grabbing MapFish based print services since I first saw it. It’s a slick little interface, and can even been extended for multi-page print layouts pretty easily, ala http://tinyurl.com/mapfishmultipageprint. But as I’ve started to give thought not to ...

Smathermather's Weblog - smathermather.wordpress.com · 3 references

RVM, jRuby, ActiveRecord::ConnectionNotEstablished, and PostgreSQL

2 days ago by jeremyrdavis

I generated a new Rails 3 app with a PostgreSQL backend. I was using the latest jRuby. I started the server and got : ActiveRecord::ConnectionNotEstablished That was annoying. I connected to the database from the command line and from another tool. I ran rails console and got the following : Argumen ...

Arrogant Programmer - arrogantprogrammer.blogspot.com

PostgreSQL memory issues with connection pooling

2 days ago by victori

I recently learned a hard lesson with PostgreSQL’s long lived connections; persistent connections expand in memory size without giving any back to the OS. I saw our PostgreSQL database go from 1.2gigs (shared_buffers set to 1024m) to 3.8gigs in memory size. Almost 2.6gigs of memory wasted on persist ...

Letsgetdugg - letsgetdugg.com · 10 references

08
Feb
2012
Instalando o PostgreSQL 9 e pgAdmin III no Ubuntu 10.04

2 days ago by Tiago Passos

Sem muita conversinha, vamos direto ao assunto. Para instalar o PostgreSQL 9 e o pgAdmin III no Ubuntu 10.04, acesse o Terminal (Menu Principal / Acessórios / Terminal) e digite os seguintes comandos: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get upgrade sudo apt-get ...

tiagopassos.com » Principal - blog.tiagopassos.com · 2 references

Não consegue abrir o pgAdmin III no Ubuntu 10.04? Eis a solução!

2 days ago by Tiago Passos

Esses dias tive esse problema. Instalei o PostgreSQL 9 e o pgAdmin III no meu notebook com o Ubuntu 10.04 e eu simplesmente não conseguia abrir o pgAdmin. Clicava e não acontecia nada. Pesquisando um pouco, encontrei um tópico no Launchpad que me trouxe a solução. É um bug que deveria estar resolvid ...

tiagopassos.com » Principal - blog.tiagopassos.com · 2 references

07
Feb
2012
Django postgresql connect_timeout via environment variable

4 days ago by sandip

Recently, I've had to move a postgresql database onto a separate server and split it out from the django application server. On doing so, we saw intermittent "OperationalError: could not connect to server: Connection timed out". This was quite obvious that the "connect_timeout" had to be increased t ...

LinuxWebLog.com - linuxweblog.com · Rank: 143,513 · 24 references

06
Feb
2012
Console SQL para PostGIS Viewer

4 days ago by Anderson Medeiros

Há quase um ano publiquei uma postagem onde divulgava uma notícia sobre um plugin visualizador de dados geográficos para pgAdmin III. A dica de hoje está relacionada com aquela extensão ( PostGIS Viewer), na verdade sobre uma ampliação de suas funcionalidades. Trata-se de um console para execução de ...

Anderson Medeiros - andersonmedeiros.wordpress.com · Rank: 128,076 · 17 references

Identifying The Hottest Tables

4 days ago by whitemice

In recent versions of PostgreSQL there is a magical view called pg_stat_user_tables which provides per table information on usage; there is one row per table and eight counters per row. Fields relname - The name of the table. seq_scan - The number of sequential scans that have been performed on the ...

Whitemice Consulting - whitemiceconsulting.com · 1 reference

ArcSDE e PostGIS – caracteres pt

4 days ago by duarte

Apenas uma nota rápida sobre a utilização de ArcSDE e PostGIS… Finalmente, estamos a iniciar a transição para PostGIS na nossa plataforma ESRI. Ao copiar um conjunto de tabelas espaciais (com Copy/Paste no ArcCatalog), aparecia uma mensagem de erro de que algo grave se passaria: (duplicate key viola ...

Via SIG - blog.viasig.com · 3 references

Previous1234567