Tagged Questions
0
votes
1answer
22 views
Problems installing Postgis extension on Ubuntu 14.04
I have Ubuntu 14.04 with Postgres 9.3 and I'm trying to install Postgis extension. One of the most recommended and straightforward ways I found is very simple:
sudo apt-get install postgresql-contrib ...
0
votes
1answer
107 views
Problems using “Excel PostgreSQL Import, Export & Convert Software”
I want to export data from Postgresql, and I tried many ways then find the tutorial of Excel PostgreSQL Import, Export & Convert Software on Youtube.
I installed the software, but I could not ...
-1
votes
1answer
21 views
postgres: how to use subquery correctly?
I have the following query
CREATE TABLE test_buffslip AS
SELECT
ST_INTERSECTS(
(SELECT ST_Buffer(geom, 0.005) FROM segments where class = 7)
,geom)
FROM segments;
resulting in
...
5
votes
0answers
156 views
Storing and querying rolling data in PostgreSQL
I have a large quantity of weather model data being put into a PostgreSQL database. The machine has 8 cores and 16 GB of RAM. I'm running PostgreSQL 9.3 with PostGIS 2.1. Each table will have a ...
1
vote
0answers
92 views
PostgreSQL how to create a scalable location-based query
I need suggestions because I am not good enough.
I have a DB in PostgreSQL that runs on AWS (Amazon Web Services).
I have a table "user_location" where there are stored the locations of each user ...
0
votes
0answers
38 views
GetProj4StringSPI: Cannot find SRID (4326) in spatial_ref_sys
I'm trying to execute the following statement in a Rails app that uses postgis.
Postgres 9.3.4, Postgis 2.1.3 (with homebrew on Mac).
ActiveRecord::StatementInvalid:
PG::InternalError: ERROR: ...
0
votes
0answers
67 views
Unable to send WHERE parameters to subquery
I have the following problem (in PostgreSQL in combination with PostGIS):
I have the following nice query who clusters multiple records. Although it uses PostGIS function, my problem is not PostGIS ...
0
votes
0answers
112 views
PostGres- How to loop in Table to update every record in Table
I am working on complicated problem, but I will simplify it to this problem.
I have two tables
A [ID, column1, column2, column3]
B [ID, column1, column2, column3, column4]
and i want to update the ...
0
votes
0answers
138 views
PostgreSQL 9.2 (PostGIS) performance problem
A month ago i got acquainted with PostgreSQL and only now i've noticed that some of my queries are pretty slow.
Well, for example, i have table:
CREATE TABLE sometable
(
gid serial NOT NULL,
geom ...
0
votes
0answers
92 views
Creating PostGIS extension in single-user mode
I am trying to create a PostGIS extension for my PostgreSQL database when running a single-user mode by using the following command:
echo "CREATE EXTENSION postgis;" | su postgres sh -c ...
0
votes
0answers
993 views
Cannot run pgAdmin from the terminal: No such file libwx_gtk2u
(Probably irrelevant) I'm using Puppet to setup/manage a class of computers that are equipped with PostgreSQL and PostGIS, and this implies that each computer goes through an unattended install:
...
