Skip to main content

Jignesh Shah's Blog

Search This Blog

Running PostgreSQL on Virtual Environments - #pgopen 2011

September 15, 2011

Get link
Facebook
X
Pinterest
Email
Other Apps

Slides from my presentation at Postgres Open 2011 (#pgopen11) in Chicago.

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Popular Posts

Tuning DB Parameters for PostgreSQL 12 in Amazon RDS

In my last entry, we saw how to setup PostgreSQL 12 beta 3 in Amazon RDS . In that entry I purposely left out how to change database parameters as I realized that it deserves an entry (or more) by itself. Using the AWS CLI you can create a new database parameter group as follows: $ aws rds create-db-parameter-group --db-parameter-group-name jkpg12pg \ --db-parameter-group-family postgres12 --description "My PostgreSQL 12 Parameter Group" \ --region us-east-2 --endpoint https://rds-preview.us-east-2.amazonaws.com We have just created a group and not applied the parameters to any database. Before we apply, we do to see what are the default values in the created group. You can run a command as follows to see values being set by default in the group. $ aws rds describe-db-parameters --db-parameter-group-name jkpg12pg \ --region us-east-2 --endpoint https://rds-preview.us-east-2.amazonaws.com \ --query 'Parameters[].[ParameterName,ParameterValue]' --ou...

Setting up PostgreSQL 12 Beta 3 for Testing in Amazon RDS

One of the amazing things about the PostgreSQL community is launching releases like clockwork. On 8/8/2019 the PostgreSQL community not only launched the minor versions for PostgreSQL 11 and old major versions but also a new Beta 3 version for upcoming PostgreSQL 12. On AWS, you can check versions of PostgreSQL available in your region as follows: $ aws rds describe-db-engine-versions --engine postgres --query 'DBEngineVersions[*].EngineVersion' [ "9.3.12", ... "11.2", "11.4" ] You will not see any beta versions out there. Pre-release versions for PostgreSQL in AWS are available in the Database Preview Environment within US East 2 (Ohio). If you are using the cli you have to add the region us-east-2 and also the url endpoint rds-preview.us-east-2.amazonaws.com to your CLI commands. $ aws rds describe-db-engine-versions --engine postgres \ --query 'DBEngineVersions[*].EngineVersion...

PostgreSQL Extensions - A Deeper Look

My slides from my session "PostgreSQL Extensions - A Deeper Look" at PostgresOpen 2019 and PostgresConf SV 2019 PostgreSQL Extensions: A deeper look from Jignesh Shah This blog represents my own view points and not of my employer, Amazon Web Services.

Powered by Blogger

Theme images by enot-poloskun