Re: [HACKERS] Database schema diff

2015-10-14 Thread Torello Querci
Few years ago I developed a tool called fsgateway ( https://github.com/mk8/fsgateway) that show metadata (table, index, sequences, view) as normal files using fuse. In this way to yout can get differences between running db instance using diff, meld or what do you prefear. Unfortunally at the mome

Re: [HACKERS] pg_cancel_backend by non-superuser

2011-12-13 Thread Torello Querci
Hi Greg 2011/12/13 Greg Smith : > On 12/11/2011 05:29 PM, Torello Querci wrote: >> >> I will try to adjust the patch and submit for the next Commit Fest if >> this is ok for you. >> > > > I don't think we'll need this, it will take a bit to explain wh

Re: [HACKERS] pg_cancel_backend by non-superuser

2011-12-11 Thread Torello Querci
2011/12/6 Magnus Hagander : > On Sun, Oct 2, 2011 at 23:32, Tom Lane wrote: >> Noah Misch writes: >>> On Sun, Oct 02, 2011 at 06:55:51AM -0400, Robert Haas wrote: On Sat, Oct 1, 2011 at 10:11 PM, Euler Taveira de Oliveira wrote: > I see. What about passing this decision to DBA? I m

Re: [HACKERS] ToDo: pg_backup - using a conditional DROP

2011-11-15 Thread Torello Querci
2011/11/15 Pavel Stehule : > Hello, > > there is a request on enhancing of pg_backup to produce a conditional > DROPs. A reason for this request is more simple usage in very dynamic > production - cloud BI solution. > > pg_backup can have a new option "--conditional-drops" and then pg_dump > will p

Re: [HACKERS] pg_cancel_backend by non-superuser

2011-10-02 Thread Torello Querci
I like this idea +1 Il giorno 02/ott/2011 12:56, "Robert Haas" ha scritto: > On Sat, Oct 1, 2011 at 10:11 PM, Euler Taveira de Oliveira > wrote: >> On 01-10-2011 17:44, Daniel Farina wrote: >>> >>> On Fri, Sep 30, 2011 at 9:30 PM, Tom Lane wrote: ISTM it would be reasonably non-contro

Re: [HACKERS] pg_cancel_backend by non-superuser

2011-09-30 Thread Torello Querci
2011/10/1 Tom Lane : > Daniel Farina writes: >> This patch would appear(?) to have languished: >> https://commitfest.postgresql.org/action/patch_view?id=541 > >> I'd really like to see it included.  In the last comments of the >> review, there seem to be problems in *terminate* backend, but even >

Re: [HACKERS] pg_terminate_backend and pg_cancel_backend by not administrator user

2011-07-01 Thread Torello Querci
2011/6/2 Noah Misch : > On Wed, Jun 01, 2011 at 10:26:34PM -0400, Josh Kupershmidt wrote: >> On Wed, Jun 1, 2011 at 5:55 PM, Noah Misch wrote: >> > On Sun, May 29, 2011 at 10:56:02AM -0400, Josh Kupershmidt wrote: >> >> Looking around, I see there were real problems[1] with sending SIGTERM >> >> t

[HACKERS] pg_terminate_backend and pg_cancel_backend by not administrator user

2011-02-14 Thread Torello Querci
Hi, this is the first time that I post here, so if I wrong please don't kill me ... I see that pg_terminate_backend and pg_cancel_backend can be execute only by admin users. This approach seems to be too restrictive in a lots of real situation. In dept, I have a situation where it is created one