Re: [GENERAL] grant connect on database

spur230 writes: > I am using Postgres 9.4. I created a login role and gave select to all > tables to a schema as follows: > > > create role fix; > create role dcv login password 'mypassword' in role fix; > grant select on all tables on schema xzy to dcv'; > > I was

[GENERAL] grant connect on database

I am using Postgres 9.4. I created a login role and gave select to all tables to a schema as follows: create role fix; create role dcv login password 'mypassword' in role fix; grant select on all tables on schema xzy to dcv'; I was able to connect to the database without giving 'grant

Re: [GENERAL] "Immediate shutdown if postmaster.pid is removed" not mentioned in Release Notes

> I noticed, that 9.5 release notes (beta2) do not mention > commit 7e2a18a9161fee7e67642863f72b51d77d3e996. > > > I think this one should be added. +1. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent

Re: [GENERAL] "Immediate shutdown if postmaster.pid is removed" not mentioned in Release Notes

On Wed, Dec 16, 2015 at 3:42 PM, Tom Lane wrote: > Victor Yegorov writes: > > I noticed, that 9.5 release notes (beta2) do not mention > > commit 7e2a18a9161fee7e67642863f72b51d77d3e996. > > We don't normally document back-patched patches in

Re: [GENERAL] grant connect on database

On 12/16/2015 11:58 AM, Jerry Sievers wrote: spur230 writes: I am using Postgres 9.4. I created a login role and gave select to all tables to a schema as follows: create role fix; create role dcv login password 'mypassword' in role fix; grant select on all tables

[GENERAL] "Immediate shutdown if postmaster.pid is removed" not mentioned in Release Notes

I noticed, that 9.5 release notes (beta2) do not mention commit 7e2a18a9161fee7e67642863f72b51d77d3e996. I think this one should be added. -- Victor Y. Yegorov

Re: [GENERAL] "Immediate shutdown if postmaster.pid is removed" not mentioned in Release Notes

Victor Yegorov writes: > I noticed, that 9.5 release notes (beta2) do not mention > commit 7e2a18a9161fee7e67642863f72b51d77d3e996. We don't normally document back-patched patches in as-yet-unreleased branches, since the point of release notes is to tell you what's new

[GENERAL] Check old and new tuple in row-level policy?

I've been trying to learn more about the row-security policies but coming up short in my searches. Was there any consideration to allowing access to both old and new row tuples in a POLICY ... CHECK expression? This idiom I've seen in the lower level rule and trigger systems seems like it would

Re: [GENERAL] Check old and new tuple in row-level policy?

Karl, * Karl Czajkowski (kar...@isi.edu) wrote: > I've been trying to learn more about the row-security policies but > coming up short in my searches. Was there any consideration to > allowing access to both old and new row tuples in a POLICY ... CHECK > expression? This idiom I've seen in the

Re: [GENERAL] dblink_connect fails

No it is not. Just in case I tried setting it to 'postgres', logged in without -U (doesn't work without PGUSER set) and tried the operation again. Same result. Cheers, James Sewell, PostgreSQL Team Lead / Solutions Architect __ Level 2, 50 Queen St,

Re: [GENERAL] Check old and new tuple in row-level policy?

* Karl Czajkowski (kar...@isi.edu) wrote: > I think that there is significant overlap between authorization, state > transition models, and data integrity constraints once you start > considering collaborative applications with mutable records. Even with OLD/NEW being available to UPDATE, many of

Re: [GENERAL] Index contains unexpected zero page at block

Victor Blomqvist writes: >> From time to time I get this and similar errors in my Postgres log file: > < 2015-12-17 07:45:05.976 CST >ERROR: index > "user_pictures_picture_dhash_idx" contains unexpected zero page at block > 123780 Hm, can't tell for sure from the error message

Re: [GENERAL] Index contains unexpected zero page at block

Sorry, I should have included the index definition, its a normal btree index on a bigint column: CREATE INDEX user_pictures_picture_dhash_idx ON user_pictures USING btree (picture_dhash); And the table itself: CREATE TABLE user_pictures (picture_dhash bigint) (and ~10 other columns not

Re: [GENERAL] Fwd: dblink_connect fails

On 12/16/2015 06:10 PM, James Sewell wrote: Oops left off the list. -- Forwarded message -- From: *James Sewell* > Date: Thursday, 17 December 2015 Subject: dblink_connect fails To: Joe Conway

Re: [GENERAL] "Immediate shutdown if postmaster.pid is removed" not mentioned in Release Notes

> We don't normally document back-patched patches in as-yet-unreleased > branches, since the point of release notes is to tell you what's new > compared to the previous release, and this item isn't (or won't be). That makes sense. > Also, I doubt that this is of any great concern to the average

Re: [GENERAL] dblink_connect fails

On 12/16/2015 04:53 PM, James Sewell wrote: > No it is not. > > Just in case I tried setting it to 'postgres', logged in without -U > (doesn't work without PGUSER set) and tried the operation again. > > DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist That "PRDSWIDEGRID01$" is

Re: [GENERAL] Check old and new tuple in row-level policy?

On Dec 16, Stephen Frost modulated: > There is still a need to refer back to some kind of state that is > external to the table under consideration to determine what the session > level access is, no? Even if the ACLs are in a table somewhere, how do > you know who the current user is? > Yes,

[GENERAL] Fwd: dblink_connect fails

Oops left off the list. -- Forwarded message -- From: *James Sewell* Date: Thursday, 17 December 2015 Subject: dblink_connect fails To: Joe Conway On Thu, Dec 17, 2015 at 12:11 PM, Joe Conway

Re: [GENERAL] Fwd: dblink_connect fails

On 12/16/2015 06:10 PM, James Sewell wrote: > Oops left off the list. Me too -- response repeated below... > -- Forwarded message -- > From: *James Sewell* > > Date: Thursday, 17 December 2015 > Subject:

Re: [GENERAL] dblink_connect fails

On 12/16/2015 04:53 PM, James Sewell wrote: No it is not. Just in case I tried setting it to 'postgres', logged in without -U (doesn't work without PGUSER set) and tried the operation again. Do you mean this: DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist or that you could not

Re: [GENERAL] dblink_connect fails

Perhaps the attached will help. It's a sample function that I wrote and tested a few years ago on PG v8.3 It worked then, so it should be a good model for you. On Wed, Dec 16, 2015 at 8:00 PM, Adrian Klaver wrote: > On 12/16/2015 04:53 PM, James Sewell wrote: > >> No

[GENERAL] Index contains unexpected zero page at block

>From time to time I get this and similar errors in my Postgres log file: < 2015-12-17 07:45:05.976 CST >ERROR: index "user_pictures_picture_dhash_idx" contains unexpected zero page at block 123780 < 2015-12-17 07:45:05.976 CST >HINT: Please REINDEX it. < 2015-12-17 07:45:05.976 CST >CONTEXT:

Re: [GENERAL] Packages for Ubuntu Wily (15.10)

Hi Steve, Adrian and list, sorry for my delay in replying. As I suggested in my OP, there aren't currently 9.3 (or 9.4) packages for Wily in PGDG, that's why I was asking if whoever's responsible for these packages could flip the switch to build them. It would be ever so helpful. See

Re: [GENERAL] json indexing and data types

Hi Oleg This is known problem, that's why we stop developing jsquery and are working on sql-level query language for jsonb, then you'll use all power and extendability of SQL. The idea is to use power of subselects and unnest to unroll jsonb to sql level. There is presentation at pgconf.eu

Re: [GENERAL] Does PostgreSQL support to write glusterfs by Libgfapi

On Wed, Dec 16, 2015 at 1:26 AM, zh1029 wrote: > Hi, > It seems low performance PostgreSQL(9.3.6) while writing data to > glusterFS > distributed file system. libgfapi is provide since GlusterFS version 3.4 to > avoid kernel visits/data copy which can improve its performance.

Re: [GENERAL] Packages for Ubuntu Wily (15.10)

On 12/16/2015 04:42 AM, Antony Gelberg wrote: Hi Steve, Adrian and list, sorry for my delay in replying. As I suggested in my OP, there aren't currently 9.3 (or 9.4) packages for Wily in PGDG, that's why I was asking if whoever's responsible for these packages could flip the switch to build

Re: [GENERAL] Packages for Ubuntu Wily (15.10)

Thanks, this looks like it will do the job. Now we just have to hack the Puppet Postgres module in order to handle the -testing source. :) On 16 December 2015 at 16:25, Adrian Klaver wrote: > On 12/16/2015 04:42 AM, Antony Gelberg wrote: > >> Hi Steve, Adrian and

Re: [GENERAL] Does PostgreSQL support to write glusterfs by Libgfapi

On Tuesday, December 15, 2015 11:26:40 PM zh1029 wrote: > Hi, > It seems low performance PostgreSQL(9.3.6) while writing data to glusterFS > distributed file system. libgfapi is provide since GlusterFS version 3.4 to > avoid kernel visits/data copy which can improve its performance. But I >