This has been asked me many times. Many users has asked me how they can create READ-ONLY user, READ-ONLY Database or How they can create backup user which can be use only for backup (no modification) Well answer is in …
READ-ONLY user,READ-ONLY Database,READ-ONLY backup user in PostgreSQL/PPASAuthor Archive
READ-ONLY user,READ-ONLY Database,READ-ONLY backup user in PostgreSQL/PPAS
Wednesday, March 21st, 2012 by Vibhor Kumar
Partition Syntax Support in PPAS 9.1
Monday, February 13th, 2012 by Vibhor KumarIn Series of New Features in Advanced Server 9.1, today I tought to write about Parition Table Syntax Supported in PPAS 9.1. In PostgreSQL and till PPAS 9.0, user has to follow method given below for partitioning a table: 1. …
Partition Syntax Support in PPAS 9.1
Virtual Private Database (VPD) in PPAS 9.1
Friday, February 10th, 2012 by Vibhor KumarGreat News is Postgres Plus Advanced 9.1 is now available for users. So, I thought to write something about Virtual Private Database features, which is part of 9.1 Virtual Private Database (VPD) is a feature which enables Administrator to create …
Virtual Private Database (VPD) in PPAS 9.1
Configure PEM Server on Postgres Plus Cloud
Sunday, February 5th, 2012 by Vibhor KumarPostgres Plus Cloud is now available for users, so I thought to write a short tutorial on How to create Instance on Postgres Plus Cloud and How to configure PEM Server on Postgres Plus Cloud. Creating and Installing on Postgres … Continue reading 
Workaround for SMTP Exceptions in PPAS9.0
Sunday, December 18th, 2011 by Vibhor KumarTill PPAS 9.0, UTL_SMTP package has no specific named Exceptions for Transient_error, Invalid_operation and Permanent Error. However, Oracle provide following types of named exceptions for SMTP: 1. INVALID_OPERATION: Raised when an invalid operation is made. In other words, calling API …
Workaround for SMTP Exceptions in PPAS9.0Postgres Plus Advanced Server 9.1 Beta 1
Friday, December 16th, 2011 by Vibhor KumarPPAS 9.1 Beta 1 has been released. So, I thought to write about it and New Features which are coming. Best part of PPAS 9.1 is that it has all features of PostgreSQL 9.1, which I have already discribed in …
Postgres Plus Advanced Server 9.1 Beta 1
PostgreSQL 9.1:: New in Object Manipulation
Tuesday, December 6th, 2011 by Vibhor KumarIn Series of writing Blog on New features in PostgreSQL 9.1, I thought to write and give example on Object Manipulation Changes.
Let see what we have in Object Manipulation Features in 9.1
1. CREATE/ALTER/DROP EXTENSIONS PostgreSQL 9.1 has different …
PostgreSQL 9.1:: New in Object ManipulationNew Replication and Recovery Features in PostgreSQL 9.1
Tuesday, November 15th, 2011 by Vibhor Kumar1. Streaming Replication and Continuous Archiving Features. a. Synchronous Replication PostgreSQL 9.1 came with Synchronous Replication. In Synchronous Replication, all commited transaction will be transferred to standby synchronously. When Primary is in Synchronous replication, then each commit transaction will wait …
New Replication and Recovery Features in PostgreSQL 9.1
