Skip to content
Question Defense
Technical answers for technical questions
Question Defense
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact
Linkedin page opens in new windowTwitter page opens in new window
Search:
Search
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact

Tag Archives: database

You are here:
  1. Home
  2. Entries tagged with "database"

Technology Insights

Visualize Your Rails Database Schema for Free on Windows

InsightsBy Chirag PatelNovember 8, 20081 Comment

Using Railroad and Graphviz Blog update (10/22/2007): Thanks to the comment posted by Blog de Kilgore, I tried Railroad (instead of using the below method with starUML) to visualize my RoR app. Very easy to setup and use (see examples on web page). Here’s a quick command to create a .png graphic file of your…

Technology Insights

Does pgAdmin III Install and Run on Windows Vista

InsightsBy alexNovember 1, 2008Leave a comment

It is not stated clearly on pgAdmin’s site if it will operate on Windows Vista without issue so I decided to download, install and see if there were any issues. First I visited pgAdmin III Windows download page here. On this page it states that pgAdmin III will work with Windows 2000, Windows XP, and…

Technology Insights

Monitor Postgres Table Activity with check_postgres.pl

InsightsBy alexOctober 17, 2008Leave a comment

Its fairly straight forward to monitor a postgresql table’s activity with the wonderful script check_postgres.pl created by Greg Sabino Mullane. This script is useful for so many things I will surely be writing about other ways to use this script with Nagios and Cacti. Download Script: Download the check_postgres.pl script here.

Technology Errors

install_driver(Pg) failed: Can’t locate DBD/Pg.pm in @INC

ErrorsBy alexOctober 9, 200812 Comments

This error message was received when attempting to run an NRPE command from the shell. The fill error is below followed by how the issue was resolved. The error has been posted on the next page because of its length.

Code Snippets

No Titles After Importing Blogger To WordPress

Code Snippets, InsightsBy alexSeptember 16, 2008Leave a comment

I imported an old Blogger account into a WordPress blog recently and my titles did not import correctly. So there I was stuck with 500 posts with no titles. I decided the easiest way to fix that would be to copy the post dates from the Blogger account to the titles in WordPress. So here is…

Technology Insights

Delete All Data In A PostgreSQL Table Using PGAdmin

InsightsBy alexSeptember 3, 2008Leave a comment

Open PGAdmin and connect to the database where you would like to remove all data from a certain table. Click the SQL (execute arbitrary SQL commands) button. Use the below syntax and all data will be removed. truncate table table_name

Code Snippets

Shell Script To Check Number Of Rows In A PostgreSQL Database

Code SnippetsBy alexAugust 23, 2008Leave a comment

The below code snipet was created to check the number of rows in a PostgreSQL database, log the output to a file, and warn if the number of rows is over a certain number. There are numerous variables in the code snipet below that will need to be modified for it to work properly including…

Technology Insights

How To See The Number Of Rows In A PostgreSQL Table

InsightsBy alexAugust 21, 2008Leave a comment

Checking the number of rows in a PostgreSQL table is very easy. First connect to the database by using pgsql. psql -U postgres -d “database-name” Next use the following command to see the number of rows in a certain table. select count(*) from tablename

Technology Insights

Timestamp support for Rails and MySQL/PostgreSQL/Oracle

InsightsBy Chirag PatelAugust 13, 2008Leave a comment

Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…

123456
Question Defense
© 2021 question-defense.com
Go to Top