Restrict number of connections to specific table

From: "Sam Franklin" <Sam(dot)Franklin(at)senergyworld(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Restrict number of connections to specific table
Date: 2014-05-13 10:50:18
Message-ID: 17F5AB8399453A43B8514B1516503D2C2F9E8E@senabzmail2.senergyltd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi - apologies if this question has a painfully obvious answer. I put
the N in novice regarding postgresql.

I use postgres with the spatial extension, postgis.

I have some licenced geospatial data. The licence terms state that only
"one user can access the data at one time".

I want to add this data to the collection of spatially-enabled postgis
tables that I serve to my enterprise, where users access and consume
postgis data tables via GIS clients.

Can I put a constraint on a specific table to restrict the number of
concurrent connections to 1, which will allow me to adhere to the data
licencing terms?

If not, is there an alternative solution to serve up the data via a
PostgreSQL table and still keep within the data licence terms?

Any help is much appreciated.

Cheers

Sam

Sam Franklin

GIS Manager

survey & geoengineering

27 Gay Street

Bath

BA1 2PD

United Kingdom

T: +44 1225 485800

F: +44 2075 048106

E: Sam(dot)Franklin(at)senergyworld(dot)com

W: www.senergyworld.com

www.senergyworld.com/careers

Visit Senergy Careers <http://www.senergyworld.com/careers> online.

Visit Senergy at:

SPWLA
18-22 May 2014
Abu Dhabi,
Middle East
Stand S13

IPA
21-22 May 2014
Jakarta,
Indonesia

EAGE
16-19 June 2014
Amsterdam,
The Netherlands

Stand 3335

ONS
25-28 Aug 2014
Stavanger, Norway
Stand U34

SPE ATCE
27-29 Oct 2014
Amsterdam,
The Netherlands
Stand 2033

PETEX
18-20 Nov 2014
London,
UK


The information contained in this message is confidential. If you have
received this message in error please notify the originator, and remove
it from your system, immediately. The unauthorised use, disclosure,
copying or alteration of this message is strictly forbidden. This
message has not been encrypted. It may therefore be liable to
compromise. It is your responsibility to scan this message for viruses.
Viruses and compromises of security are inherent risks in relation to
email. To the extent permitted by law we do not accept any liability for
any virus infection and/or external compromise of security in relation
to transmissions by email. Senergy Holdings Limited and its
subsidiaries reserves the right to monitor and record e-mail messages
sent to and from this address for the purposes of investigating or
detecting any unauthorised use of its system and ensuring its effective
operation.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2014-05-13 11:29:36 Re: Restrict number of connections to specific table
Previous Message Jonatan Malaver 2014-05-12 14:49:04 Re: link tables