Re: [GENERAL] Read/Write operation counts

2017-01-18 Thread Rader, David
On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce wrote: > On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote: > >> Is there a way to retrieve the total read/write operations initiated by a >> PG server. I'm looking for measuring the IOPS of a server over a period of >> time. >> > > postgres itself doesn

Re: [GENERAL] Read/Write operation counts

2017-01-18 Thread John R Pierce
On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote: Is there a way to retrieve the total read/write operations initiated by a PG server. I'm looking for measuring the IOPS of a server over a period of time. postgres itself doesn't actually know how many physical disk operations are taking place a

[GENERAL] Read/Write operation counts

2017-01-18 Thread Anirudh Jayakumar
Hi, Is there a way to retrieve the total read/write operations initiated by a PG server. I'm looking for measuring the IOPS of a server over a period of time. Thanks, Anirudh

Re: [GENERAL] Read/Write restriction mechanism

2008-01-09 Thread Michael Glaesemann
On Jan 9, 2008, at 1:39 , Naz Gassiep wrote: In a PHP project I have several functions that I use for DB operations. I only want to allow one of them to write, all the others are for reading only. (Using DB level perms are out, as this is the function usage I'm trying to control, not th

[GENERAL] Read/Write restriction mechanism

2008-01-08 Thread Naz Gassiep
A tangentially PG related question: In a PHP project I have several functions that I use for DB operations. I only want to allow one of them to write, all the others are for reading only. I was thinking that a way I can enforce this would be to check that the read only ones only have queries w

Re: [GENERAL] Read Write

2006-05-20 Thread Adrian Klaver
Sorry meant to add this from the psql command line. On Saturday 20 May 2006 04:37 pm, Adrian Klaver wrote: > \z 'table_name' > Look under access privileges for r and w. > For further information see- > http://www.postgresql.org/docs/8.1/interactive/sql-grant.html > > On Saturday 20 May 2006 03:11

Re: [GENERAL] Read Write

2006-05-20 Thread Adrian Klaver
\z 'table_name' Look under access privileges for r and w. For further information see- http://www.postgresql.org/docs/8.1/interactive/sql-grant.html On Saturday 20 May 2006 03:11 pm, Bob Pawley wrote: > How can I determine if my tables are 'read only' or 'read/write'? > > Bob -- Adrian Klaver

[GENERAL] Read Write

2006-05-20 Thread Bob Pawley
How can I determine if my tables are 'read only' or 'read/write'?   Bob