Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On Fri 16 Nov, 2018, 3:36 AM Thomas Munro On Fri, Nov 16, 2018 at 5:07 AM Adrian Klaver > wrote: > > On 11/15/18 7:59 AM, Sachin Kotwal wrote: > > > I feel community has most of linux based instance in thier buildfarm > for > > > testing, might be very few Ubuntu based. > > > I might be wrong her

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On Fri 16 Nov, 2018, 1:06 AM Alvaro Herrera On 2018-Nov-15, Sachin Kotwal wrote: > > > I feel community has most of linux based instance in thier buildfarm for > > testing, might be very few Ubuntu based. > > If you feel the need to run more buildfarm members on Ubuntu, run some > yourself. It's

Re: Trouble with postgres_fdw & dblink extensions

On 11/15/18 3:23 PM, Lukáš Sobotka wrote: Hi guys, I would be grateful for some help. I am writing you because I am confused about using data foreign wrappers and dblink. I attached simplified script describing the problem. What I am trying to do? I have two databases and I need to copy tabl

Re: Trouble with postgres_fdw & dblink extensions

=?UTF-8?B?THVrw6HFoSBTb2JvdGth?= writes: > I would be grateful for some help. I am writing you because I am confused > about using data foreign wrappers and dblink. I attached simplified script > describing the problem. I think what is happening is that postgres_fdw starts a transaction on its co

Trouble with postgres_fdw & dblink extensions

Hi guys, I would be grateful for some help. I am writing you because I am confused about using data foreign wrappers and dblink. I attached simplified script describing the problem. What I am trying to do? I have two databases and I need to copy table from local database to the remote one. For co

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On Fri, Nov 16, 2018 at 5:07 AM Adrian Klaver wrote: > On 11/15/18 7:59 AM, Sachin Kotwal wrote: > > I feel community has most of linux based instance in thier buildfarm for > > testing, might be very few Ubuntu based. > > I might be wrong here. > > Easy enough to see: > > https://buildfarm.postgr

Re: Default Privilege Table ANY ROLE

On Wed, Nov 14, 2018 at 03:19:00PM +0100, Nicolas Paris wrote: > Hi > > I d'like my user be able to select on any new table from other users. > > > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema" GRANT > > select ON TABLES TO "myuser" > > ALTER DEFAULT PRIVILEGES FOR ROL

Re: VM Instance to Google Cloud SQL Migration

On Thu, 15 Nov 2018 at 07:06, Ian Lawrence Barwick wrote: > > 2018年11月15日(木) 17:19 Andreas Kretschmer : > > > > Am 15.11.2018 um 08:54 schrieb Sathish Kumar: > > > We would like to migrate our Postgresql VM instance on Google Cloud > > > Platform to Google Cloud SQL with a minimal downtime. As I c

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On 2018-Nov-15, Sachin Kotwal wrote: > I feel community has most of linux based instance in thier buildfarm for > testing, might be very few Ubuntu based. If you feel the need to run more buildfarm members on Ubuntu, run some yourself. It's self-service. -- Álvaro Herrerahttps:

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On 11/15/18 7:59 AM, Sachin Kotwal wrote: On Thu 15 Nov, 2018, 7:59 PM Adrian Klaver wrote: On 11/14/18 10:39 PM, Sachin Kotwal wrote: > > > Looks like no one have clear idea yet and deal also not completely done. Barring some re

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On Thu 15 Nov, 2018, 7:59 PM Adrian Klaver On 11/14/18 10:39 PM, Sachin Kotwal wrote: > > > > > > > Looks like no one have clear idea yet and deal also not completely done. > > Barring some regulatory intervention(which I do not see) the deal will > be completed. > > > Hope Redhat community suppor

RE: pg_dump out of memory for large table with LOB

Thanks to Daniel Verite, nice answer, really helpful :) It summarizes what I have read in the doc and blogs. What about updates where the bytea do not changed. Does a new copy of the bytea will be made in the toast table or new row will point to the original bytea? > https://www.postgresql.org/do

Re: db-connections (application architecture)

Am 15.11.2018 um 16:14 schrieb Andreas Kretschmer: Am 15.11.2018 um 16:09 schrieb Mark Moellering: I can see how, for only a few (hundreds to thousands) of users, the latter might make more sense but if I need to scale up to millions, I might not want all of those connections open. consi

Re: db-connections (application architecture)

On 11/15/18 7:09 AM, Mark Moellering wrote: So, I am working on some system designs for a web application, and I wonder if there is any definitive answer on how to best connect to a postgres database. I could have it so that each time a query, or set of queries, for a particular request, need

Re: db-connections (application architecture)

Oh, excellent. I knew I was about to reinvent the wheel. Sometimes, there are just too many new things to keep up on. Thank you so much! On Thu, Nov 15, 2018 at 10:16 AM Adrian Klaver wrote: > On 11/15/18 7:09 AM, Mark Moellering wrote: > > So, I am working on some system designs for a web app

Re: db-connections (application architecture)

Am 15.11.2018 um 16:09 schrieb Mark Moellering: I can see how, for only a few (hundreds to thousands) of users, the latter might make more sense but if I need to scale up to millions, I might not want all of those connections open. consider a connection-pooler like phbouncer. Regards, And

db-connections (application architecture)

So, I am working on some system designs for a web application, and I wonder if there is any definitive answer on how to best connect to a postgres database. I could have it so that each time a query, or set of queries, for a particular request, needs to be run, a new connection is opened, queries

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On 11/14/18 10:39 PM, Sachin Kotwal wrote: Looks like no one have clear idea yet and deal also not completely done. Barring some regulatory intervention(which I do not see) the deal will be completed. Hope Redhat community support will continue same as earlier. Let's wait until someth

Re: Java UnsatisfiedLinkError exception when connecting to Postgresql database

Rob Sargent wrote: > > On 11/14/18 5:03 PM, dcl...@cinci.rr.com wrote: > > Adrian Klaver wrote: > >> On 11/14/18 10:24 AM, dcl...@cinci.rr.com wrote: > >> Please reply to list also. > >> Ccing list. > >>> Adrian Klaver wrote: > On 11/14/18 9:25 AM, dcl...@cinci.rr.com wro

RE: pg_dump out of memory for large table with LOB

Jean-Marc Lessard wrote: > Another area where LOB hurts is the storage. LOB are broken and stored in 2K > pieces. > Due to the block header, only three 2k pieces fit in an 8k block wasting 25% > of space (in fact pgstattuple reports ~ 20%). Yes. bytea stored as TOAST is sliced into pieces

Re: VM Instance to Google Cloud SQL Migration

2018年11月15日(木) 17:19 Andreas Kretschmer : > > Am 15.11.2018 um 08:54 schrieb Sathish Kumar: > > We would like to migrate our Postgresql VM instance on Google Cloud > > Platform to Google Cloud SQL with a minimal downtime. As I checked, we > > have to export and import the SQL file and our database

Re: <-> Operator on Trigram Index

Hello, On 14.11.2018 01:42, Jeffrey Kamei wrote: I'm trying to get the <-> operator to recognize a trigram index (GIST) I've set on a table. Using `EXPLAIN VERBOSE` I can see the query engine ignoring the trigram index when using the `<->` operator. However if I use the `%` operator, the index

Re: VM Instance to Google Cloud SQL Migration

Am 15.11.2018 um 08:54 schrieb Sathish Kumar: We would like to migrate our Postgresql VM instance on Google Cloud Platform to Google Cloud SQL with a minimal downtime. As I checked, we have to export and import the SQL file and our database size is large and cannot afford longer downtime.