Tag Info

Hot answers tagged

9

Firstly, Postgres 9 and later do have builtin replication support and that is what we (the OpenStreetMap operations team) expect to look at using now that we are (as of about 90 minutes ago) running on Postgres 9.1 for the main database. To answer your question as to what OSM do, well to date we don't do any kind of replication - there is one large Postgres ...


4

Use "/usr/share/postgresql/8.4/contrib/postgis.sql" instead of "/usr/share/postgresql-8.2-postgis/lwpostgis.sql".


3

PostgreSQL can only use one core for any given query. It achieves good parallel performance with many concurrent queries, but doesn't benefit from large core counts for workloads of just a couple of very big queries. So if you're only running a single query that 5% isn't all that surprising, though I'd expect it to be 12% on an 8-core system. The lack of ...


3

I can see two options here : Database pooling - replication http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling , I would PG cluster as it is synchronous and permits load balancing . You can also go with master - slaves architecture but without connection pooling and asynchronous , it all depends on the architecture and the ...


2

According to the currently broken blog here (Googlecache). There is a repository of postgres9/postgis1.5.2/etc binaries for 64-bit architectures at deb http://www.gmajna.net/svojat/jaka/apt-pgsql/ squeeze main contrib non-free Otherwise, you'll probably need to compile and install postgis from source against 9.0 yourself, which will need the headers from ...


2

Running your Explain Anlayze output through explain.depesz.com highlights that the bulk of the slowness comes from this action: Seq Scan on planet_osm_polygon p Was that indexed before? Can you index it now? By searching for that problem area, I also found a related Q&A on an Open Street Map site: Local Tile Server - EXTREMELY slow rendering


2

You can't install packages for one version of Ubuntu on another version, or more accurately, you REALLY shouldn't. You will create a mess of dependencies that will need to be resolved, and can easily dig down so far into your system that you wind up with an unstable or unusable machine as a result. If you need a particular version of some package you ...


2

You have two choices: 1) Install on Linux Postgresql v9.1 2) Remove from dump every command, which Postgresql v8.4 doesn't know. EDIT: You can do two exports - first only structure of database (pg_dump -s) and then only data (pg_dump -a). Then you can edit only one file...


1

TLDR: svn co svn://svn.freebsd.org/ports/head /usr/ports I'm guessing you just deleted the actual port tree directory. In that case, you'll need to use svn to retrieve the relevant section of the ports tree from the central FreeBSD repository. This primer will help you achieve that, most relevant to you is probably the "Partial Checkout" sections. If that's ...


1

Any reason why you want to access istsos admin page on port 8080 ? I cannot see any reference to this port in the doc you provided. In the doc they say to modify file /etc/apache2/sites-enabled/000-default.conf. This file is the default Virtual Host configuration for Apache. It is configured on port 80. From now, it seems you already have a Virtual Host ...


1

One solution is to install through the official postgresql installation package: 1) Go to http://www.enterprisedb.com/products-services-training/pgdownload#osx 2) Download the version 9.1.6 of postgresql 3) After the installation, run the Stack Builder 4) Stack Builder: select your postgresql installation and click next 5) Select Categories -> Spatial ...


1

Most of the necessary missing libraries seem to be in the EPEL repository. I have no idea why PostgreSQL would want to provide them separately, and older versions at that. Beyond that, it seems something is probably wrong with your CentOS base repositories. For instance, perl-DBD-Pg is located in the base repo, but your copy of yum didn't find it for some ...


1

Did you tune your PostgreSQL server or are you using it OOTB after doing an apt-get install postgresql-server? PostgreSQL is known for being installed with very, very conservative settings. You can gain a lot by properly tuning your server. Luckily there's an excellent post on this by the guys from opengeo: ...


1

I suspect you have an old version of nominatim that had a memory leak, this was fixed a few weeks back. Probably if you update the code from svn and rebuilt that will resolve the issue.


1

To resolve this issue just reinstall GeoServer to the newer version 2.0.1 is Tomcat. It seems GeoServer V2.0.0 has the bug.


1

For Java hosting services with the choice of Tomcat, JBoss, or GlassFish Java application servers try eApps Hosting


1

You need to install postgresql-8.3-postgis. The 1.3 release is quite old: You might want to install potgis 1.4 or even better 1.5 from source, but then you have to compile proj and geos first.


1

Take a look at the output of dpkg -L postgis, this should give you a list of all files contained in the package that you installed. The locate command gets its information from a database, which is updated nightly (or manually by running sudo updatedb.



Only top voted, non community-wiki answers of a minimum length are eligible