> On 13 Feb 2016, at 11:21, drum.lu...@gmail.com wrote:
>
> Anyone can help with that please?
>
> Cheers
What would help is:
1. to post an actual query that you need optimised and
2. an explain analyze of that query.
What you posted in your original message was some kind of query-template with
On 2/13/16, Adrian Klaver wrote:
> On 02/13/2016 07:42 PM, Deven Phillips wrote:
>> I'm trying to convert a series of ISO8601 strings into TIMESTAMPs for
>> use with a function:
>>
>> CREATE OR REPLACE FUNCTION v1_nexus_vlan_count(id TEXT, start_time
>> TIMESTAMP, end_time TIMESTAMP)
>> RETURNS TE
Hi Alban! Sorry.. that was my mistake
Original Query:
SELECT concat(company, ' ', customer_name_first, ' ',
customer_name_last) AS customer,
sum(revenue) AS revenue,
sum(i.quantity) AS quantity,
sum(i.cost) AS costFROM
( SELECT account.id,
job.customerid,
I'm trying to install postgis on an Amazon Linux AMI 2015.09 - x86_64
machine. I was able to install PostgreSQL 9.3, however, when I try to
install postgis2_93, I get a notice that gdal requires a libpopper
library. When I --skip-broken it misses a whole bunch of dependencies and
though it doesn'
Hi,
I think you also need to add/enable EPEL repo, too.
Regards,Devrim
On February 15, 2016 12:09:01 AM GMT+02:00, Augori wrote:
>I'm trying to install postgis on an Amazon Linux AMI 2015.09 - x86_64
>machine. I was able to install PostgreSQL 9.3, however, when I try to
>install postgis2_93, I
> On 14 Feb 2016, at 20:40, drum.lu...@gmail.com wrote:
>
> Hi Alban! Sorry.. that was my mistake
Okay, first advice on that query: Trim it down to something that people can
wrap their minds around.
You have a silly amount of code repetition in there, much of which doesn't even
seem to serve
On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce
wrote:
>On 2/12/2016 2:28 PM, George Neuner wrote:
>> In Linux the distinction between a "workstation" and a "server" is
>> largely a matter of system configuration. Windows "desktop" and
>> "server" editions are different code bases: there are n
Thanks, Devrim. It looks like epel is already installed:
rpm -ivh epel-release-6-8.noarch.rpm
warning: epel-release-6-8.noarch.rpm: Header V3 RSA/SHA256 Signature, key
ID 0608b895: NOKEY
Preparing... #
[100%]
package epel-release-6
Error: Package: gdal-libs-1.9.2-6.rhel6.x86_64 (pgdg93)
Requires: libpoppler.so.5()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Hi,
what happens if you try to install libpoppler (it is in the standard
On 2/14/2016 7:45 PM, Augori wrote:
This matches what Steve was seeing on this page:
http://lists.osgeo.org/pipermail/postgis-users/2014-August/039520.html
But his question seemed to reach a dead end without resolution.
must be something specific about amazon. I'm on a centos 6.recent box,
an
Firstly, I apologise for the delay in replying to you.
>On which of the database clusters are you seeing the 4 template0
databases?
template0 looks the same on both the master and slave,
===
$ psql -U user -l -h master | grep template0
templat
On Sun, Feb 7, 2016 at 8:14 AM, Melvin Davidson
wrote:
> With regards to Karsten's thought, here is a query to find any pg_catalog
> indexes that are corrupt.
>
> SELECT n.nspname as schema,
>i.relname as table,
>i.indexrelname as index,
>i.idx_scan,
>i.idx_tup_rea
12 matches
Mail list logo
