Postgresql: show tables, show databases, show columns

Posted on July 3rd, 2009

postgresql logoPostgreSQL is one of the best database engines for an average web project and many who moves to psql from mysql (for example) often ask the following questions: what  is the analog of “show tables” in postgres? or how can I get the list of databases in postgres like “show databases” in mysql? The answers are short:

mysql: SHOW TABLES
postgresql: \d
postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema...

[Read more →]

SOURCE: http://www.linuxscrew.com

Tags: Linux Screw, linux, tips // Add Comment »

VirtualBox 3.0 for Linux With 3D and OpenGL 2 Support

Posted on July 3rd, 2009


Sun xVM VirtualBox allows users to create "virtual machines" in their host operating system so that they can install any guest OS, facilitating the development, cross-platform running and testing of multi-tier applications on a single computer. Being very space efficient, Sun xVM VirtualBox has around 40 megabytes and is ready...

[Read more →]

SOURCE: http://praveenkumarg.blogspot.com/

Tags: Rapidshare Download Links, linux // Add Comment »

VMWare ESXi – Decreasingly Free As Time Goes On

Posted on July 3rd, 2009

Hey, what do you say we throw some actual content up here and see what happens…

The excellent virtualization blog RTFM Education has a post today talking about VMware ESXi. Specifically that as time continues, fewer and fewer features work with it.

The case in point started with the remote command line interface being changed to “read only”, which doesn’t make it much of an interface at all.

After that failed to correct itself, a 3rd party backup solution called Veeam was just asked to remove backup support for ESXi.

This is a disturbing trend, and as someone on the brink of ...

[Read more →]

SOURCE: http://www.standalone-sysadmin.com/blog

Tags: ESXi, General, Standalone Sysadmin, VMWare, virtualization // Add Comment »

Aaaaand we’re back…

Posted on July 3rd, 2009

Sorry about that weird bit of downtime there. It turns out that one of my MySQL tables had been corrupt for a long time, and it only just felt the load today. And of course, *poof*

The table has been marked as repaired, a new backup set has been created and moved offsite, and we are once again rolling along.

Boy, you hate to have stuff start that way, but that’s how it goes sometimes.

Also, very special thanks to everyone who reached out to me to let me know that the blog was down, caught on fire, and sinking. Thanks, it means a lot to me that people care that much to go out of their way to alert me.

Maybe I should setup a Nagios server on here ;-)...

[Read more →]

SOURCE: http://www.standalone-sysadmin.com/blog

Tags: General, Standalone Sysadmin, administrivia // Add Comment »

Welcome to the future!

Posted on July 3rd, 2009
If you're reading this via RSS reader, I invite you to come visit the new blog! I've got all sorts of enhancements available here, so come check it out!

Lets do an overview of what's new. First, instead of being hosted on blogger's servers, I've got a VPS for the site, and the domain name is www.standalone-sysadmin.com now. Since there are tons of links going to the old site, I've implemented an http meta redirect to a php script that I write. It parses the referrer information and sends the user to the correct page on this site.

The big RSS icon in the top right hand corner of the page links to the feedburner stream. If you subscribe via RSS (and as of today,...

[Read more →]

SOURCE: http://standalone-sysadmin.blogspot.com/

Tags: Standalone Sysadmin // Add Comment »

Welcome to the future!

Posted on July 3rd, 2009

If you’re reading this via RSS reader, I invite you to come visit the new blog! I’ve got all sorts of enhancements available here, so come check it out!

Lets do an overview of what’s new. First, instead of being hosted on blogger’s servers, I’ve got a VPS for the site, and the domain name is www.standalone-sysadmin.com now. Since there are tons of links going to the old site, I’ve implemented an http meta redirect to a php script that I write. It parses the referrer information and sends the user to the correct page on this site.

The big RSS icon in the top right hand corner of the page links to the feedburner stream. If you subscribe...

[Read more →]

SOURCE: http://www.standalone-sysadmin.com/blog

Tags: General, Standalone Sysadmin // Add Comment »

HP LaserJet 2100 Printer, Go On - Make That Purchase

Posted on July 3rd, 2009
By Ben PateWith dynamic uses and workability that is truly all encompassing, the HP LaserJet 2100 is without opposition. Surpassing all requirements of the modern small company, the machine comes through on all facets in terms of performance. When used with HP 2100 Toner, it gives picture-perfect prints consistently and with precision and is a versatile small company expert, regardless of the

SOURCE: http://system-check.blogspot.com/

Tags: System Check // Add Comment »

Here’s How You Can Find Wii Game Downloads

Posted on July 3rd, 2009
By Sam LockwoodWith the booming sales of the Nintendo Wii, we decided it would be a good idea to create a guide for learning how to download Wii games. As you likely know, it can get pricey to buy brand new games at the store. Downloading games for your Wii can save you a bundle of money. As an added bonus, you'll always have access to any new game you'd like to try. Most Wii owners don't know

SOURCE: http://system-check.blogspot.com/

Tags: System Check // Add Comment »

LaserJet 5MP Printer - LaserJet 5MP Toner: Where To Buy And Product Specifications

Posted on July 3rd, 2009
By Ben PateThe LaserJet 5MP printer using HP 5MP Toner is on the higher end of the scale when it comes to purchases. Before any large purchase there is research you should do. Always you should find out whether a particular purchase is right for you. The LaserJet 5MP printer appears a product of Hewlett Packard. It runs around $700. 00 and is large enough for a small office. Something like this

SOURCE: http://system-check.blogspot.com/

Tags: System Check // Add Comment »

HP LaserJet 9000 - Makes for A Great Printer

Posted on July 3rd, 2009
By Ben PateThis commercial duty LaserJet 9000 Toner package offers unparalleled ease of use. It already has business solutions installed, which allow you to use HP compatible software and hardware to get the job done fast. HP 9000 Compatible Toner is what you need. Edge to edge printing and 1200 dpi clearness along with high print speed and extra large handling trays can handle any printing job

SOURCE: http://system-check.blogspot.com/

Tags: System Check // Add Comment »

Next Page »