joelonsql

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

adamcrews

/*
To use this synthetic, set the following Secure credentials:
  NEW_RELIC_INSIGHTS_API_KEY - Your api key from the account settings.
  NEW_RELIC_ACCOUNT_ID - Your account ID, also found in the account settings.
  CERTS_TO_MONITOR - A list of hosts to check via https, separated by a comma and a space, for example:
    host.example.com, foo.example.com

Create a new Synthetic monitor, copy the entire contents of this script to the monitor.
Set the monitor to run once a day from a single location.

picadoh

### Cloudwatch Events ###
# Event rule: Runs at 8pm during working days
resource "aws_cloudwatch_event_rule" "start_instances_event_rule" {
  name = "start_instances_event_rule"
  description = "Starts stopped EC2 instances"
  schedule_expression = "cron(0 8 ? * MON-FRI *)"
  depends_on = ["aws_lambda_function.ec2_start_scheduler_lambda"]
}

# Runs at 8am during working days

dlangille

# All of this was run on FreeBSD 11, but with path adjustments to the keystore, should work for any OS.

# Your cert is in your local directory:
#
# unifi01.int.unixathome.org.key
# unifi01.int.unixathome.org.pem

# aircontrolenterprise is the password we are using on our pkcs12 file

# crete the keys.p12 file

Komzpa

TL;DR

9.4 -> 9.5:

sudo pg_dropcluster 9.5 main --stop
sudo service postgresql stop
sudo pg_upgradecluster -m upgrade -k 9.4 main
sudo su postgres -c "/usr/lib/postgresql/9.5/bin/vacuumdb --all --analyze-in-stages"
sudo pg_dropcluster 9.4 main