Achieving PCI Compliance with PostgreSQL
Today, I gave Security talk on Achieving PCI Compliance at PgWest 2010, San Francisco. Slides are available to download. http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=achievingpcicompliace-12888219148022-phpapp02&stripped_title=achieving-pci-compliace-5659979
Security & PgWest2010
Open Source databases still needs solid presence in enterprise world. One of the myths about open source databases is that they aren’t secure. To eliminate this myth we have to share our experience related to security aspect of PostgreSQL database. At OmniTi , we help businesses to achieve PCI compliance or provide payment processor:PayPI . […]
Outlining Surge Conference Sessions
OmniTi’s Surge conference is around the corner (Sept 30th) and there are plenty of industry leading speakers and most advance technology sessions to choose from list. Most probably I will be attending second day of two days conference. I spent a lot of time to decide on most interesting sessions to attend from wide variety […]
PostgreSQL Recovery Manager – PG_RMAN
During PgEast, I heard a lot about making PostgreSQL acceptable at more enterprise shops. I firmly believe that PostgreSQL has potential but lack of marketing perspective during the promotion of product and tools. Anyways, let’s start creating/testing/using and telling new tools those can be attracted by C-Level people!! If you have Oracle background , you […]
RubyRep Presentation Slides
Guys, Today I gave presentation @ PgEast2010 in Philadelphia. You can download slides Here Thanks for attending or following it!! http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=rubyrepv2-100326211120-phpapp01&stripped_title=yet-another-replication-tool-rubyrep
Heading to PgEast
Guys, I will be in Philadelphia on 25th and 26th March 2010 to attend PgEast PostgreSQL conference. Moreover, I will be speaking on RubyRep on 26th March 2010. If you are attending this conference , see you there!
Secure your web from SQL Injections
Last couple of months, I came across two incidents of SQL injections due to most common errors by IT professionals. How To Hack A Brazilian Power Company SQL Injection discovered on Wall Street Journal Both incidents are stunning and they were exploited by hackers with minimal effort. Little care during web application development could avoid […]
Postgres 8.4 – Replace regular index with Text Based Index
I came across a nice post by Peter Eisentraut that shows how text based index can be used to do direct lookup on the text fields. Quick test proves that.. postgres=# d employees Table “public.employees”Column | Type | Modifiers——–+———+———–emp_id | integer | not nullname | text |Indexes: “employees_pkey” PRIMARY KEY, btree (emp_id)postgres=# create index idx_employees_name […]
Yet Another PostgreSQL Replication Tool – RubyRep
One of the key features any enterprise considers when choosing a database technology for their architecture solution stack is that of replication. Oracle and MySQL both have built in replication solutions, but as of yet PostgreSQL doesn’t support a built in replication solution. There are many replication solutions available however, and different companies are using […]
pg_migrator beta-1 released
pg_migrator ———– Version 8.4, Beta 1 What it Does ———— pg_migrator allows data stored in Postgres data files to be migrated to a later Postgres major version without the dump/reload of data typically required for major version upgrades, e.g. 8.3.7 -> 8.4.1. It is not required for minor version upgrades, e.g. 8.4.1 -> 8.4.5. Limitations […]