On Wed, Jul 4, 2012 at 7:21 AM, Raghavendra
wrote:
> You can use trail version of PEM, a product of EnterpriseDB. Am not a sales
> guy :), just came out as you said the word "Like OEM for oracle".
>
Pretty sure that's not a web client, though, which is what he asked for?
You might want to look
On Wed, Jul 4, 2012 at 10:25 AM, Madhu.Lanka wrote:
>
>> Hi Friends
>>
>> ** **
>>
>> Can u please suggest me any web client tool for administrating postgres
>> database.(like OEM for oracle)
>>
>> ** **
>>
>> **
>>
>
You can monitor PostgreSQL with Zabbix tool:
http://blog.gtuhl.com/2009/
You can use trail version of PEM, a product of EnterpriseDB. Am not a
sales guy :), just came out as you said the word "Like OEM for oracle".
http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http:/
On Wed, Jul 4, 2012 at 7:09 AM, Samuel Stearns wrote:
> Ok, that returns only the 1 row:
>
> ** **
>
> SELECT idstat.indexrelid as indexrelid,
>
>idstat.schemaname AS schema_name,
>
>idstat.relname AS table_name,
>
>idstat.indexrelname AS index_name,
>
Hi Friends
Can u please suggest me any web client tool for administrating postgres
database.(like OEM for oracle)
Thanks in Advance.
Regards
Madhu.Lanka
Ok, that returns only the 1 row:
SELECT idstat.indexrelid as indexrelid,
idstat.schemaname AS schema_name,
idstat.relname AS table_name,
idstat.indexrelname AS index_name,
idstat.idx_scan AS times_used,
idstat.idx_scan AS times_used,
pg_size_pretty(pg_rela
On 06/25/2012 11:40 AM, Rob Cowell wrote:
Why would the output from ‘ls’ show older filenames (013D...xx)
as newer in date than the “013F...xx” filenames?
Does Postgres re-cycle old log filenames ?
It recycles old log files. If you turn on log_checkpoints, you can see
how man
On Tue, Jul 3, 2012 at 12:48 PM, Samuel Stearns
wrote:
> Before and after analyze:
>
> ** **
>
> select schemaname,relid,indexrelid,relname,indexrelname from
>
> pg_stat_all_indexes where relname='input_transaction_snbs';
>
> ** **
>
> schemaname | relid | indexrelid |reln
Before and after analyze:
select schemaname,relid,indexrelid,relname,indexrelname from
pg_stat_all_indexes where relname='input_transaction_snbs';
schemaname | relid | indexrelid |relname |
indexrelname
+---+++
