Technology Insights

How To Export From PGAdmin, Export PGAdmin Data To CSV

This afternoon I was using PGAdmin and needed to export some data from a query I had run but realized I wasn’t even sure if PGAdmin had this capability. Typically I would export data using the PSQL command line but since I was already working in PGAdmin I wanted to try and figure out if the capability existed and if so how to do it. After some playing around I was able to figure out how to export PGAdmin data to a CSV (Comma Separated Value) format that would be Microsoft Excel friendly. Follow the directions below to export PGAdmin data to a .CSV file to open in MS Excel.

Details
Technology Errors

oclHashcat64.bin: /usr/lib64/libOpenCL.so: no version information available (required by ./oclHashcat64.bin)

I have been working on a project using oclHashcat this afternoon and started to look into an error that has existed on a development server where we use oclHashcat for quite some time. After some digging around I am confident that regardless of the error existing there is not an issue but I wanted to post an article related to the error in case anyone else looked for a resolution to the error. Below is information on the libOpenCL.so error and my thoughts regarding the error.

Details
Technology Errors

CentOS Linux: ATI Stream Compile Error: GL/glu.h: No such file or directory

Today I was doing some testing with OpenCL and needed to install ATI Stream for one of the tests I was performing but I ran into an error during the compile process. The error related to glu.h which was not found during the compile process using make. Below I describe the error in more detail as well as what was done to resolve the error and make the glu.h file available on the server.

Details
Technology Errors

CentOS IRQ Errors, Server: kernel: Disabling IRQ #177

Recently we have been doing a lot of testing of oclHashcat on CentOS Linux servers. The oclHashcat application takes advantage of the GPU’s, or Graphical Processing Units, of Nvidia graphics cards or ATI graphics cards. Anyhow one of the servers we have been testing with has four Nvidia 295 GTX’s and at times was receiving an error stating the kernel was disabling the IRQ. Below we describe the error in more detail along with a kernel parameter that was added to resolve the error. Even though we experienced this issue with oclHashcat specifically the error could happen with other applications and/or Linux Operating Systems so the resolution could be the same.

Details