Re: [ADMIN] Read Only Role

2011-11-30 Thread M. D.
On 11/29/2011 11:52 PM, senthilnathan wrote: Is there any simple way to define read only roles. Basically that user should be able to login and be able to do *select* statements alone. It should be applied for all tables in all schemas in a database. -- View this message in context: http://pos

Re: [ADMIN] parsing audit table

2011-08-16 Thread M. D.
2011-07-05 new, B04TaEsAAIG5bEEX5xBVPQ,3,jakew,mag,...,2011-08-04 you could probably load it into excel -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of M. D. Sent: Tuesday, August 16, 2011 5:03 PM To: pgsql-...@postgresql.

[ADMIN] parsing audit table

2011-08-16 Thread M. D.
Hi everyone, I'm a bit lazy, or actually in a bit of a crunch. I added an audit recording a few months ago, but never really used it much, but today I'm seeing a bunch of suspicious activity by one user. Does someone have any function to quickly parse this data? I followed this: http://wik

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread M. D.
On 08/11/2011 08:41 AM, CS DBA wrote: Hi All; Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? Thanks in advance... SymmetricDS is capable of doing replication one DB to another, but I've never used it so cannot spea

[ADMIN] library problem with psql

2011-05-28 Thread M. D.
Hi, I just did an upgrade on a server from 8.4.4 to 9.0.4. I used EnterpiseDB's binary packages. Everything seems to be running good, but when I run psql, any command will give me a memory dump exactly like in this post: http://forums.enterprisedb.com/posts/list/2604.page#9753 Should I revert t

Re: [ADMIN] visualizing database schema - png/jpeg?

2011-05-18 Thread M. D.
might want to take a look at Power*Architect - http://www.sqlpower.ca/page/architect MD On 05/18/2011 01:09 PM, neubyr wrote: > Anyone knows of tools that can generate PNG/JPEG image from pgsql > database schema? > > -- > neuby.r > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or