Re: [HACKERS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions

2017-03-17 Thread Giuseppe Broccolo
ty model. > Exactly, so I repost here my initial question: On Fri, Mar 17, 2017 at 4:16 PM, Giuseppe Broccolo < > giuseppe.brocc...@2ndquadrant.it> wrote: > >> >> >> Check which user is used the first time you connect to the database >> through QGIS, and if yo

Re: [HACKERS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions

2017-03-17 Thread Giuseppe Broccolo
; > I will be glad if someone can help me unravel this mystery. > Check which user is used the first time you connect to the database through QGIS, and if you switch the user to [user_name] in a second moment. I'm wondering if you are keeping some privileges from a previous session

Re: [HACKERS] dump a comment of a TSDictionary

2017-03-07 Thread Giuseppe Broccolo
x27;t reproduce a failure > in simple cases. > Yep, the issue is reproducible during parallel restore - I've seen this for 4 parallel processes. Sorry for having not mentioned this before. Regards, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL & PostGIS Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

[HACKERS] dump a comment of a TSDictionary

2017-03-06 Thread Giuseppe Broccolo
gt;dobj.dumpId); This is present in the master branch too, so potentially all the PostgreSQL versions are affected. Let me know what do you think about this change. Regards, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL & PostGIS Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

Re: [HACKERS] File based Incremental backup v7

2015-01-28 Thread Giuseppe Broccolo
| Location | Access privileges | Options | Size | Description +--+---+---+-++- pg_default | postgres | | | | 37 MB | pg_global | postgres | | | | 437

Re: [HACKERS] [RFC] Incremental backup v3: incremental PoC

2015-01-27 Thread Giuseppe Broccolo
) File "/home/gbroccolo/.pyenv/versions/2.7.5/lib/python2.7/shutil.py", line 130, in copy2 copyfile(src, dst) File "/home/gbroccolo/.pyenv/versions/2.7.5/lib/python2.7/shutil.py", line 82, in copyfile with open(src, 'rb') as fsrc: IOError: [Errno 2] No such file or directory: 'backups/2601151641/data/base/16384/16406_fsm' Any idea on what's going wrong? Thanks, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it