Category Archives: PostgreSQL

AWS Lambda to generate CSV file from RDS PostgreSQL

One of the requirement was to generate csv file for set of queries from RDS PostgreSQL and upload the csv file to s3 bucket for power bi reporting. Powerbi connects to s3 url and generate report. There is no gateway … Continue reading

Posted in AWS, AWS Lambda, AWS SSM, PostgreSQL, S3 | Leave a comment

AWS S3—>AWS Lambda —>SSM—> SQL Server Job

Scenario: Application is running on java and the database is using PostgreSQL.  Application user uploads the data and this data needs to process to analytic server as well. There is no direct access to Analytic Database server that is running … Continue reading

Posted in AWS, AWS Lambda, AWS SSM, PostgreSQL, S3, SQL Server 2016 | Leave a comment

AWS Lambda to connect to PostgreSQL and execute a function/query using Python

It’s been long time since i wrote a blog post. In this post i would like to show an example of lambda to connect to PostgreSQL database and execute the query. Build a PostgreSQL psycopg module in order to connect … Continue reading

Posted in AWS, PostgreSQL, Uncategorized | 5 Comments

How to kill all the sessions in postgreSQL database

The below script will be used to kill all the sessions except your session. If you are looking for specific process id then you can provide the pid value in the where clause as below   Hope you enjoyed the post! Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter    

Continue reading

Posted in PostgreSQL | Leave a comment