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
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
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
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
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
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
\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
How can I determine if my tables are 'read only' or
'read/write'?
Bob