On 05/09/2017 07:03 PM, Armand Pirvu (home) wrote:
On May 9, 2017, at 7:11 PM, Adrian Klaver wrote:
On 05/09/2017 05:02 PM, armand pirvu wrote:
Well
Jt1 is prod and jt2 is dev
You are talking schemas, not databases, correct?
Correct
Before someone pushes to prod it does work in dev.
Em ter, 9 de mai de 2017 às 17:40, basti
escreveu:
> Hello,
>
> I must convert a Latin9 Pg-cluster (Version 9.1) in utf-8 with minimal
> downtime, if possible.
> My idea is to use WAL replication for that.
> Is it usable for that or in other words, can WAL Replication handle
> different encoding
On May 9, 2017, at 7:11 PM, Adrian Klaver wrote:
> On 05/09/2017 05:02 PM, armand pirvu wrote:
>> Well
>> Jt1 is prod and jt2 is dev
>
> You are talking schemas, not databases, correct?
>
>
Correct
>> Before someone pushes to prod it does work in dev. The jdbc connection
>
> That would co
On 05/09/2017 05:02 PM, armand pirvu wrote:
Well
Jt1 is prod and jt2 is dev
You are talking schemas, not databases, correct?
Before someone pushes to prod it does work in dev. The jdbc connection
That would concern me, as anything bad that happened in the dev schema
could bring the entir
Well
Jt1 is prod and jt2 is dev
Before someone pushes to prod it does work in dev. The jdbc connection routes
to jt2. In the mean time it wad needed that some tables in prod are synced at
all times from dev. Hence the view/fdw.
What I meant by connections was more to say the type of load or user
On 05/09/2017 02:36 PM, Armand Pirvu (home) wrote:
Hi
I have two schemas jt1, and jt2 in the same db
In both I have the same table tbl3
The idea is to keep in sync jt1.tbl3 from jt2.tbl3 each time I have an
insert/update/delete on jt2.tbl3
So I was thinking about the following cases to avoid r
2017-05-09 10:19 GMT+12:00 Brian Dunavant :
> From what you're saying about migrating, I'm assuming the new table
> has additional columns or something. If you can map the difference,
> then you could use CTE's to select from the first table, and if
> nothing is there, then pull from the second t
Hi
I have two schemas jt1, and jt2 in the same db
In both I have the same table tbl3
The idea is to keep in sync jt1.tbl3 from jt2.tbl3 each time I have an
insert/update/delete on jt2.tbl3
So I was thinking about the following cases to avoid replication
1) in jt2 rather than have the tbl3 tab
Hello,
I must convert a Latin9 Pg-cluster (Version 9.1) in utf-8 with minimal
downtime, if possible.
My idea is to use WAL replication for that.
Is it usable for that or in other words, can WAL Replication handle
different encoding on master/slave?
Is there perhaps an other way to do that?
Is it p
On Tue, May 9, 2017 at 2:50 PM, Rajesh Mallah
wrote:
> Hi ,
>
> I am referring to audit trigger as described in
>
> https://wiki.postgresql.org/wiki/Audit_trigger_91plus OR
> https://wiki.postgresql.org/wiki/Audit_trigger
>
> Although there are documented limitations for these systems , but
> I
Hi ,
I am referring to audit trigger as described in
https://wiki.postgresql.org/wiki/Audit_trigger_91plus OR
https://wiki.postgresql.org/wiki/Audit_trigger
Although there are documented limitations for these systems , but
I would like to mention and seek suggestion on a limitation that I feel
On Mon, May 8, 2017 at 2:26 PM, Paul Hughes wrote:
> Hello,
>
> I noticed that most of the largest web platforms that use PostgreSQL as
> their primary database, also use Python as their primary back-end language.
> Yet, according to every benchmark I could find over the last couple of
> years, b
9.5 both
But the enable always trigger I missed that
Once that set it runs
Thank you for your help
Armand
On May 9, 2017, at 8:26 AM, Adrian Klaver wrote:
> On 05/08/2017 08:31 PM, Armand Pirvu (home) wrote:
>> My bad
>> db1 I have two tables t1 and t2 (or more)
>> db2 has one table t3 fo
On Mon, 8 May 2017 14:26:02 -0700, Paul Hughes
wrote:
>Hello,
>
>I noticed that most of the largest web platforms that use PostgreSQL as
>their primary database, also use Python as their primary back-end language.
>Yet, according to every benchmark I could find over the last couple of
>years, bac
On Tue, May 9, 2017 at 1:44 PM, vinny wrote:
> In fact, I don't think many companies/developers even choose a language
> or database, but rather just use whatever they have experience in.
That is choosing. You choose them because you know them.
Francisco Olarte.
--
Sent via pgsql-general mai
On 8 May 2017 at 22:26, Paul Hughes wrote:
> I noticed that most of the largest web platforms that use PostgreSQL as
> their primary database, also use Python as their primary back-end language.
> Yet, according to every benchmark I could find over the last couple of
> years, back-end languages l
> My question still remains though - why is it that all the largest web
> platforms that have used PostgreSQL *specifically* choose Python as their
> back-end language?
If you write the developers a nice tweet or e-mail they might tell
you. Anything else is going to be speculation because th
On May 9, 2017, at 2:07 , Paul Hughes wrote:
>
> Postgres might be a popular choice among Rails devs, but Ruby is not as
> popular among the big web platforms that choose Postgres.
Ahem.
AirBnB, Bloomberg, Crunchbase, Github, Groupon, Heroku, Hulu, Kickstarter,
Scribd, Shopify, Slideshare, S
On 2017-05-09 05:26 AM, Francisco Olarte wrote:
Do you have any data supporting that? AFAIK people tend to choose the
language first, database second, not the other way round, and many
times the platform language is nailed, but the db can be changed.
Also, WHICH platforms are you referring to?
On 05/08/2017 08:31 PM, Armand Pirvu (home) wrote:
My bad
db1 I have two tables t1 and t2 (or more)
db2 has one table t3 for example which can get data aggregated from one
or more multiple tables from the above set . I can
updates/inserts/deletes in db1.t1 and/or db1.t2 which combined may m
On 2017-05-09 11:26, Francisco Olarte wrote:
Paul:
On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
My question still remains though - why is it that all the largest
web platforms that have used PostgreSQL *specifically* choose Python
as their back-end language?
Do you have any data s
On 9 May 2017 at 06:20, Neil Anderson wrote:
> On 9 May 2017 at 05:26, Francisco Olarte wrote:
>> Paul:
>>
>> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
>>> My question still remains though - why is it that all the largest web
>>> platforms that have used PostgreSQL *specifically* c
On 9 May 2017 at 05:26, Francisco Olarte wrote:
> Paul:
>
> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
>> My question still remains though - why is it that all the largest web
>> platforms that have used PostgreSQL *specifically* choose Python as their
>> back-end language?
>
> Do y
Paul:
On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
> My question still remains though - why is it that all the largest web
> platforms that have used PostgreSQL *specifically* choose Python as their
> back-end language?
Do you have any data supporting that? AFAIK people tend to choos
24 matches
Mail list logo
