Skip to content

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Presenting
  • Publications
  • Volunteering
  • Contact

Category: postgresql

Using psql in Docker

  • Posted onFebruary 2, 2021February 2, 2021
  • containerization

Run psql in docker exec docker exec -ti NAME_OF_CONTAINER psql -U YOUR_POSTGRES_USERNAME

Continue Reading

Using PostGIS in Docker

  • Posted onFebruary 2, 2021February 2, 2021
  • containerization

This requires a different image in Docker. You can’t just use the postgres image and create an extension in it. Instead, you have to use the postgis image. This image will have a database in it already setup for you to use with postgis. If…

Continue Reading

Using Docker on Windows to have persistent PostgreSQL settings and databases

  • Posted onFebruary 1, 2021February 2, 2021
  • containerization

This is a super simple way to retain the data and settings that you create and change on your PostgreSQL Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that it’s easier to have persistent…

Continue Reading

pgadmin upgrade and saved servers list

  • Posted onNovember 24, 2020
  • postgresql

I used to freak out each time (and especially the first time) I upgraded pgadmin on my local computer. What happened to my saved servers list?!? Of course, I could recreate it because I have a listing of all the servers in Confluence, but ugh…

Continue Reading

Recent posts

  • Standards Matter
  • What I’ve Been Up To
  • Testing SQL Server backups and offloading integrity checks
  • What perms does a user need to create a table variable?
  • Get the schema of a temp table

Categories

  • Azure (1)
  • containerization (12)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • other (3)
  • postgresql (4)
  • security (1)
  • SQL Server (8)
  • sql server administration (111)
    • jobs (2)
  • sql sever syntax (77)
  • web dev (6)
  • zen (1)

Archives

  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (5)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • Standards Matter
  • What I’ve Been Up To
  • Testing SQL Server backups and offloading integrity checks
  • What perms does a user need to create a table variable?
  • Get the schema of a temp table
© Copyright 2022 –
Chip Life Theme by TutorialChip ⋅ Powered by WordPress