Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

2017-04-11 Thread Muhammad Hanif Abdul Hamid
Dear Adrian, Solved, it is due to pgdg.list. Typo, it should be xenial-pgdg instead of trusty-pgdg for the repository. Thank you. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Rabu, 12 April 2017 12:16 ptg To: Muhammad Hanif Abdul Hamid

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

2017-04-11 Thread Adrian Klaver
On 04/11/2017 07:23 PM, Muhammad Hanif Abdul Hamid wrote: Dear Admin, I would like to install “postgresql-plperl-9.4” package, however it failed due to the “libperl5.18” dependency is lower than “libperl5.22” installed as below:- Obviously some Debian derived distribution, but what one and

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

2017-04-11 Thread Muhammad Hanif Abdul Hamid
Dear Admin, I would like to install “postgresql-plperl-9.4” package, however it failed due to the “libperl5.18” dependency is lower than “libperl5.22” installed as below:- root@db:/home/prod# apt-get install postgresql-plperl-9.4 Reading package lists... Done Building dependency tree

Re: [GENERAL] dynamic schema modeling and performance

2017-04-11 Thread RJ Ewing
I thought that might be an answer around here :) I guess I was looking for what might be a better approach. Is dynamically creating a table for each entity a bad idea? I can see something like creating a schema for each project (group of related entities) and then creating a table for each

Re: [GENERAL] dynamic schema modeling and performance

2017-04-11 Thread RJ Ewing
Poul, I took a quick look at the demo site, but didn't see anything where the user was defining the fields. It looks like they can choose from a list of predetermined metadata fields. Looking at the code, but not actually seeing the total db schema, it looks like they might be using the EAV

Re: [GENERAL] browser interface to forums please?

2017-04-11 Thread Bruce Momjian
On Tue, Apr 4, 2017 at 12:01:24PM +0200, vinny wrote: > Now, I'm not saying the mailinglists should go, I'm saying there should be > an easier way > to access them. It should be possible to register on the site, post a > message and read replies, > without having to subscribe to the list and

Re: [GENERAL] dynamic schema modeling and performance

2017-04-11 Thread Dorian Hoxha
If you are asking if you should go nosql, 99% you should not. On Tue, Apr 11, 2017 at 10:06 PM, Poul Kristensen wrote: > dataverse.org uses Postgresql and is well documented + it is completely > user driven. Maybe the concept could be usefull for you. I have installed > and

Re: [GENERAL] dynamic schema modeling and performance

2017-04-11 Thread Poul Kristensen
dataverse.org uses Postgresql and is well documented + it is completely user driven. Maybe the concept could be usefull for you. I have installed and configuration a few to be uses for researchers. regards Poul 2017-04-11 19:46 GMT+02:00 Rj Ewing : > I'm looking for

[GENERAL] dynamic schema modeling and performance

2017-04-11 Thread Rj Ewing
I'm looking for thoughts on the best way to handle dynamic schemas. The application I am developing revolves around user defined entities. Each entity is a tabular dataset with user defined columns and data types. Entities can also be related to each other through Parent-Child relationships. Some

Re: [GENERAL] Unable to connect to Postgresql

2017-04-11 Thread John Iliffe
On Monday 10 April 2017 19:37:43 Adrian Klaver wrote: > On 04/10/2017 01:23 PM, John Iliffe wrote: > > On Monday 10 April 2017 11:53:35 Daniel Verite wrote: > >>John Iliffe wrote: > >>> So, the problem is resolved, although I have no idea why it was > >>> necessary. > >> > >> The key seems to

Re: [GENERAL] Build PostGIS In Windows Using --with-gdalconfig=FILE

2017-04-11 Thread Jan de Visser
On Tuesday, April 11, 2017 5:43:29 AM EDT Osahon Oduware wrote: > Hi, > > I am using Windows 7 OS and I have installed a GDAL with support for MrSID > format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to > point to this new GDAL. > > How do I accomplish this in a Windows OS?

[GENERAL] Build PostGIS In Windows Using --with-gdalconfig=FILE

2017-04-11 Thread Osahon Oduware
Hi, I am using Windows 7 OS and I have installed a GDAL with support for MrSID format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to point to this new GDAL. How do I accomplish this in a Windows OS?

[GENERAL] Build PostGIS With GDAL-config-file in Windows

2017-04-11 Thread Osahon Oduware
Hi, I am using Windows 7 OS and I have installed a GDAL with support for MrSID format. I want to build my PostGIS with the GDAL-config-file to point to this new GDAL. How do I accomplish this in a Windows OS?