On 8/24/19 3:42 PM, Howard Wells wrote:
I have three servers behind a load balancer and a fourth server solely
for Postgres 10 database that is not behind the load balancer. All four
are behind the same firewall, with port 5432 open.
I have a simple browser-based html form to submit email add
> On Aug 24, 2019, at 4:42 PM, Howard Wells wrote:
>
> I have three servers behind a load balancer and a fourth server solely for
> Postgres 10 database that is not behind the load balancer. All four are
> behind the same firewall, with port 5432 open.
>
> I have a simple browser-based ht
I have three servers behind a load balancer and a fourth server solely for
Postgres 10 database that is not behind the load balancer. All four are behind
the same firewall, with port 5432 open.
I have a simple browser-based html form to submit email addresses, usernames
and passwords; the form
On Sat, Aug 24, 2019 at 11:53 AM Peter Wainaina wrote:
>
> Thanks much for the response. This is what I mean am a database administrator
> for a production company and the product owner doesn't want me to be able to
> either read or write information that will come from Django application.
I pe
Hi Karsten
Thanks for the infinitly good hint. I remembered the infinity
blurredly somewhen this morning, looked it up in the docs and already
dumped my functions in favour of the infinity solution. :-) Great,
that PostgreSQL has the infinity concept! Thanks
Kind regards
Thiemo
Quoting
On Sat, Aug 24, 2019 at 12:57:07AM +, Thiemo Kellner wrote:
> Call: select utils.get_max_timestamptz();
> --
>
> Function
> --
> create or replace function GET_MAX_TIMESTAMPTZ()
> returns timestamptz
> language plpgsql
> immutable
> -- Include the hosting schema into search_path so tha
these values were collected before vacuum analyse:select (select reltuples
from pg_Class where relName = t.relName), * from pg_stat_sys_tables t where
schemaname = 'pg_catalog' and relname in
('pg_class','pg_attribute','pg_index');
reltuples relid schemaname relname seq_scanseq
