From: Venkata B Nagothi
Sent: Friday, September 30, 2016 02:48
To: Rakesh Kumar
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Multi tenancy : schema vs databases
On Fri, Sep 30, 2016 at 10:16 AM, Rakesh Kumar
mailto:rakeshkumar...@outlook.com>
On 9/30/2016 2:06 AM, Rakesh Kumar wrote:
We require complete data isolation. Absolutely nothing should be shared between
two tenants.
WHy would multiple dbs be any worse than multiple schemas in performance?
complete? use 1000s of seperate VM instances, one per tennant.
ok, thats ridiculo
Tom Lane schrieb am 29.09.2016 um 23:10:
> Thomas Kellerer writes:
>> for some reason pg_upgrade failed on Windows 10 for me, with an error
>> message that one specifc _vm file couldn't be copied.
>
> Hmm ... a _vm file would go through rewriteVisibilityMap(), which is new
> code for 9.6 and has
Via schemata if the tenants represent sub entities of the same organization.
This gives the top level mgmt the ability to have a consolidated view of the
whole organization.
On 30/09/2016 12:06, Rakesh Kumar wrote:
From: Venkata B Nagothi
Sent: Friday,
> ok, thats ridiculous, isn't it. so now its time to find a compromise.
You don't understand how sales people pitch our products. We deal with
financial data
and our customers are extremely sensitive to even imagining that their data
will co-reside
with that of their competitors who also are o
On Fri, Sep 30, 2016 at 6:40 PM, Thomas Kellerer wrote:
> Tom Lane schrieb am 29.09.2016 um 23:10:
>> Thomas Kellerer writes:
>>> for some reason pg_upgrade failed on Windows 10 for me, with an error
>>> message that one specifc _vm file couldn't be copied.
>>
>> Hmm ... a _vm file would go thro
you could also use a hybrid approach :
- have a systematic tenant_id field in your tables, allowing for 1 db / 1
schema multi-tenants
- give your application the ability to set the schema path for a tenant,
so it will locate the tenant schema if it has a decidated schema
- maybe go to the extrem
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Armand Pirvu (home)
Sent: Thursday, September 29, 2016 5:42 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] executing os commands from a function
All
I know this
On Fri, Sep 30, 2016 at 6:06 AM, Rakesh Kumar
wrote:
> A typical fear mongering Q from
> them "what if due to a bug in your s/w, our competitors end up looking at our
> data" or
> something like that. That's why schema level vs db level discussion.
So... if your software isolates customers based
On Fri, Sep 30, 2016 at 5:11 AM, John R Pierce wrote:
> On 9/30/2016 2:06 AM, Rakesh Kumar wrote:
>>
>> We require complete data isolation. Absolutely nothing should be shared
>> between two tenants.
>>
>> WHy would multiple dbs be any worse than multiple schemas in performance?
>
>
> complete? u
Rakesh,
As long as one application knows how to connect to more than 1 tenant,
there will *always* be the possibility that a software bug in your
application causes one tenant to access another tenant's data. I think this
is why you're getting people asking you to refine your requirements. There
q
On Fri, Sep 30, 2016 at 6:06 AM, Rakesh Kumar
wrote:
A typical fear mongering Q from
them "what if due to a bug in your s/w, our competitors end up looking at our
data" or
something like that. That's why schema level vs db level discussion.
I've been reading this discussion with great interes
Armand
On Thu, Sep 29, 2016 at 11:41 PM, Armand Pirvu (home)
wrote:
> I know this may sound like heresy since it involves executing an OS command
> from a function , but here goes
> After an insert in a table, I want to touch a file
> I used plsh extension but I had to use two functions
On Thu, Sep 29, 2016 at 2:41 PM, Armand Pirvu (home) wrote:
> I used plsh extension but I had to use two functions and a trigger, see
> code below
>
I don't see any way to not use a trigger given your requirement. And as
written I don't see that you need the second function - just write the
t
> I've been reading this discussion with great interest, to see what other
> Postgres experts think. :-)
I am bit disappointed that most of the replies are questioning why we are
doing what we are doing. Once again, we (db designers) have no choice
in that. What I would like to know that which on
Hello.
I've just uploaded ZSON extension on GitHub:
https://github.com/afiskon/zson
ZSON learns on your common JSONB documents and creates a dictionary
with strings that are frequently used in all documents. After that you
can use ZSON type to compress documents using this dictionary. When
docum
I've upped max_worker_processes to 16, but I still can't get it to launch
workers unless I use EXPLAIN ANALYZE. I've also found that this simplified
setup exhibits the same behavior:
create table big as (
SELECT generate_series(1,3000) AS id
);
explain analyze SELECT avg(id) from big where
Jay Knight writes:
> I've tried this on a CentOS VM (VirtualBox on Windows) that I gave 2 cores,
> and it worked as expected (it launched workers with and without explain
> analyze), so I've only been able to reproduce this on Windows.
FWIW, I tried your original example on Linux yesterday, and i
On 29/09/16 15:29, Dave Page wrote:
> The pgAdmin Development Team are pleased to announce the release of
> pgAdmin 4 version 1.0.
>
> pgAdmin is the leading Open Source management and administration tool
> for PostgreSQL.
>
> pgAdmin 4 is a complete rewrite of pgAdmin, built using Python and
> Jav
Select version(); shows
postgreSQL 9.6beta3, compiled by Visual C++ build 1800, 64-bit
--
View this message in context:
http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5923791.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-g
Hi,
On Fri, 2016-09-30 at 18:10 +0100, Tim Clarke wrote:
> WebViewWindow.h:20:20: fatal error: QWebView: No such file or directory
These are the -devel packages that I installed to build pgadmin4 RPMs:
BuildRequires: mesa-libGL-devel
BuildRequires: gcc-c++
BuildRequires: qt5-qtbase-devel >=
On Fri, Sep 30, 2016 at 2:06 AM, Rakesh Kumar
wrote:
>
> We require complete data isolation. Absolutely nothing should be shared
> between two tenants.
>
Then you need different clusters per tenant. Otherwise, the WAL records of
different tenants are inextricably mingled together.
Cheers,
Jef
* Jeff Janes (jeff.ja...@gmail.com) wrote:
> On Fri, Sep 30, 2016 at 2:06 AM, Rakesh Kumar
> wrote:
> > We require complete data isolation. Absolutely nothing should be shared
> > between two tenants.
>
> Then you need different clusters per tenant. Otherwise, the WAL records of
> different tena
>Then you need different clusters per tenant. Otherwise, the WAL records
> of different tenants are inextricably mingled together.
Yes we are aware of it .This part is OK as it is not deemed as user table data.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On 30/09/16 18:35, Devrim Gündüz wrote:
> These are the -devel packages that I installed to build pgadmin4 RPMs:
> BuildRequires:mesa-libGL-devel
> BuildRequires:gcc-c++
> BuildRequires:qt5-qtbase-devel >= 5.1
> BuildRequires:qt5-qtwebkit-devel
> BuildRequires:
> Does anybody know a Software for generating graphical entity relation models
> from existing postgresql databases?
>
> Best regards Johannes
I use dbWrench (dbwrench.com). It's not free, but they do have a free trial
version so you can see if you like it before you buy it. It's also not
expe
>> I've been reading this discussion with great interest, to see what
>> other Postgres experts think. :-)
>
>I am bit disappointed that most of the replies are questioning why we are
>doing what we are doing. Once again, we (db designers) have no choice in that.
> What I would like to know that
A java application threw a major error when closing and it crashed my
system (including wiping out most of /tmp). After rebooting I su'd to user
postgres and tried to start postgresql-9.5.4, but this error displays:
postgres@salmo:~$ FATAL: could not open shared memory segment
"/PostgreSQL.180
On 09/30/2016 01:15 PM, Rich Shepard wrote:
A java application threw a major error when closing and it crashed my
system (including wiping out most of /tmp). After rebooting I su'd to user
postgres and tried to start postgresql-9.5.4, but this error displays:
postgres@salmo:~$ FATAL: could no
On 09/30/2016 11:32 AM, Tim Clarke wrote:
On 30/09/16 18:35, Devrim Gündüz wrote:
These are the -devel packages that I installed to build pgadmin4 RPMs:
BuildRequires: mesa-libGL-devel
BuildRequires: gcc-c++
BuildRequires: qt5-qtbase-devel >= 5.1
BuildRequires: qt5-qtwebkit-devel
BuildRequir
Rich Shepard writes:
>A java application threw a major error when closing and it crashed my
> system (including wiping out most of /tmp). After rebooting I su'd to user
> postgres and tried to start postgresql-9.5.4, but this error displays:
> postgres@salmo:~$ FATAL: could not open shared m
On 09/30/2016 08:18 AM, dudedoe01 wrote:
Select version(); shows
postgreSQL 9.6beta3, compiled by Visual C++ build 1800, 64-bit
There is no isnull() in 9.6 either, if that is what you are asking?
Otherwise what is the question you want answered?
--
Adrian Klaver
adrian.kla...@aklaver.com
-
On 09/30/2016 01:15 PM, Rich Shepard wrote:
> A java application threw a major error when closing and it crashed my
> system (including wiping out most of /tmp). After rebooting I su'd to user
> postgres and tried to start postgresql-9.5.4, but this error displays:
>
> postgres@salmo:~$ FATAL:
On Fri, 30 Sep 2016, Adrian Klaver wrote:
See here:
https://www.postgresql.org/message-id/24208.1473724630%40sss.pgh.pa.us
Ah, shoot! I completely forgot about this. Yes, I reset the perms on
/dev/shm and that fixed the problem.
My apologies to all,
Rich
--
Sent via pgsql-general mailing
On Fri, 30 Sep 2016, Tom Lane wrote:
Wrong permissions on /dev/shm, perhaps?
Tom,
Yes. I keep forgetting about this since I don't reboot this
server/workstation often.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On 1 October 2016 at 05:47, Tom Lane wrote:
> FWIW, I tried your original example on Linux yesterday, and it seemed to
> work fine --- it only wanted to use 1 worker, but the speedup was just
> about exactly 2X with or without "explain analyze". So this is somehow
> Windows specific. That's darn
I don't know if that's helpful to you or not, but hopefully it was at least a
little.
===
yes it was. thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a bytea col which stores Java UUID data. When I run
Select cast(uuid_col as varchar) from table limit 1
Output in pgadmin
-===
"A001"
Output in psql
\x4130303030303030303030303030303030303030303030303030303030303031
is there some set
David Rowley writes:
> On 1 October 2016 at 05:47, Tom Lane wrote:
>> Somebody will need to trace through this on Windows and see where it's
>> going off the rails.
> I tried the test case on 9.6.0 on a Windows 8.1 machine, and it works
> fine for me.
Hm, but if we assume that EXPLAIN ANALYZE i
Rich Shepard writes:
> On Fri, 30 Sep 2016, Tom Lane wrote:
>> Wrong permissions on /dev/shm, perhaps?
>Yes. I keep forgetting about this since I don't reboot this
> server/workstation often.
You ought to do some investigation and figure out what is causing
it to come up with the wrong permi
Rakesh Kumar writes:
> I have a bytea col which stores Java UUID data. When I run
> Select cast(uuid_col as varchar) from table limit 1
> Output in pgadmin
> -===
> "A001"
> Output in psql
>
> \x4130303030303030303030303030303030303030303030
On 1 October 2016 at 10:10, Tom Lane wrote:
> David Rowley writes:
>> On 1 October 2016 at 05:47, Tom Lane wrote:
>>> Somebody will need to trace through this on Windows and see where it's
>>> going off the rails.
>
>> I tried the test case on 9.6.0 on a Windows 8.1 machine, and it works
>> fine
Michael Paquier wrote:
> On Tue, Sep 27, 2016 at 2:13 PM, raf wrote:
> > So, my qestion is, is it possible that "pg_ctl status" could be
> > removing postgres's semaphores and can I stop it? It seems
> > extremely unlikely. So, if it isn't, what else could it be?
> > Systemd perhaps? It's been kn
On 09/30/2016 11:32 AM, Tim Clarke wrote:
On 30/09/16 18:35, Devrim Gündüz wrote:
These are the -devel packages that I installed to build pgadmin4 RPMs:
BuildRequires: mesa-libGL-devel
BuildRequires: gcc-c++
BuildRequires: qt5-qtbase-devel >= 5.1
BuildRequires: qt5-qtwebkit-devel
BuildRequir
Thanks for replies.
Good deal of info
While plsh seems to be an easier approach , I am also inclined in a an ESQL/C
type app to listen to an event
@Igor Neyman
It is just maybe I have missed a sample of a C app in that area, similar like
ESQLC
Cheers
Armand
On Sep 30, 2016, at 10:45 AM,
45 matches
Mail list logo
