Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2022-12-21 Thread Sandeep Saxena
I could find old post on postgres community , https://www.postgresql.org/message-id/20180625142233.GD20745%40momjian.us On Thu, May 17, 2018 at 07:07:00AM +, ROS Didier wrote: > Hi > > Regarding the encryption of data by pgcrypto, I would like to > know the recommendations for the management

Re: pgAgent for multiple databases in same instance

2021-03-11 Thread Sandeep Saxena
Hi Adam , Thank you for the such a good explaination , actually in same instance dba's are looking to create multiple QA databases and we had jobs in oracle for archiving and some business functionality so I created pgagent extension in multiple databases ,in our application end users can submit j

pgAgent for multiple databases in same instance

2021-03-10 Thread Sandeep Saxena
Hi, We are using EDB postgres 12 ,and using pgAgent to schedule db jobs , now we have two databases in the instance but job run only on one of the databases. I created a pgAgent extension on both db's , I can submit a job on both db's too , just it doesnt run on one db until i change dbname in edb

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Sandeep Saxena
9 8:39 AM, Sandeep Saxena wrote: > > Hi All, > > > > In our company we are looking to migrate oracle db to postgres , now > > since we dont have any expertise in Postgres in our organization so we > > are planning to go > > with AWS aurora or EDB postgres so tha

Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Sandeep Saxena
Hi All, In our company we are looking to migrate oracle db to postgres , now since we dont have any expertise in Postgres in our organization so we are planning to go with AWS aurora or EDB postgres so that we have helping hand in migration(in dev and dba) while we get mature in postgres ... do yo