Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on Jul 7, 2023

• Script to create read only group and user in a postgreSQL database.

  jleto

  committed
  4ebadb9

  Copy full SHA for 4ebadb9

Commits on Jun 23, 2020

• Delete keybase.md

  jleto

  authored
  624ee71

  Copy full SHA for 624ee71

• Create keybase.md

  jleto

  authored
  54b3915

  Copy full SHA for 54b3915

Commits on Jun 6, 2017

• Puncuation.

  

  EC2 Default User

  committed
  bf79de6

  Copy full SHA for bf79de6

Commits on Mar 20, 2014

• Added: shell script to monitor long running queries.

  jleto

  committed
  487def2

  Copy full SHA for 487def2

• Migration: Moved encryption functions from utility schema to encrypt schema

  jleto

  committed
  2458d49

  Copy full SHA for 2458d49

Commits on Aug 20, 2013

• Refactored encrypt and decrypt functions to not require output parameter but instead return the result.

  jleto

  committed
  ff78a4f

  Copy full SHA for ff78a4f

Commits on Jul 19, 2013

• Added functions to monitor queries being executed on the server and to report activity of tables.

  jleto

  committed
  c9b9ef4

  Copy full SHA for c9b9ef4

Commits on Jul 11, 2013

• Added _dba.fn_tablespace_parentless_indexes to report indexes that are in different tablespaces than their parent tables. This is helpful after doing table migrations to different tablespaces.

  Show description for eb34419
  jleto

  committed
  eb34419

  Copy full SHA for eb34419

Commits on Jul 9, 2013

• Added function to view tablespace objects.

  Show description for ad1f0c6
  jleto

  committed
  ad1f0c6

  Copy full SHA for ad1f0c6

Commits on Jul 4, 2013

• Added encrypt and decrypt utiliy functions

  Show description for 039457e
  jleto

  committed
  039457e

  Copy full SHA for 039457e

Commits on Jul 1, 2013

• Added function that allows developers to turn debugging and logging info on and off.

  Show description for cfbf56a
  jleto

  committed
  cfbf56a

  Copy full SHA for cfbf56a

Commits on Jun 25, 2013

• Added fn_table_diff function that compares defintions of two tables.

  Show description for 9139319
  jleto

  committed
  9139319

  Copy full SHA for 9139319

Commits on Jun 24, 2013

• Added dba script fn_column_datatype_compare to compare data types of identically named columns across multiple tables and schemas.

  jleto

  committed
  ecc636d

  Copy full SHA for ecc636d

• Bugfix - mispelling of "procpid" column passed in to pg_terminate_backend function.

  Show description for 85eb935
  jleto

  committed
  85eb935

  Copy full SHA for 85eb935

• Added _dba schema to contain functions specific to common dba tasks. Added function that disconnects non superusers.

  Show description for 481e2e0
  jleto

  committed
  481e2e0

  Copy full SHA for 481e2e0

Commits on Jun 23, 2013

• Added create_indexes boolean parameter to allow user to report back missing indexes and display statements to be executed before creating indexes.

  Show description for 1f7a6cd
  jleto

  committed
  1f7a6cd

  Copy full SHA for 1f7a6cd

Commits on Jun 18, 2013

• Added monitoring function fn_table_size_nolock that reads files on disk to estimate table sizes. This avoids potential table locking.

  Show description for daaba30
  jleto

  committed
  daaba30

  Copy full SHA for daaba30

• Added _monitoring schema to organize helper functions that report general database information. Moved 1 function to _monitoring schema, added three new monitoring functions.

  Show description for cfd63c1
  jleto

  committed
  cfd63c1

  Copy full SHA for cfd63c1

• Added fn_server_uptime which returns server uptime as interval.

  jleto

  committed
  7c81e76

  Copy full SHA for 7c81e76

Commits on Jun 16, 2013

• Moved notice for reporting sucessful index creation and added author, date info.

  jleto

  committed
  9608032

  Copy full SHA for 9608032

• Merge github.com:jleto/postgres

  jleto

  committed
  3bf8ed6

  Copy full SHA for 3bf8ed6

• Initial commit

  jleto

  committed
  3423076

  Copy full SHA for 3423076

• Added fn_create_missing_foreignkey_indexes function.

  jleto

  committed
  71a53d7

  Copy full SHA for 71a53d7