Thursday, March 14, 2013

Upgrading Postgres 9.1 to 9.2

Had PostgreSQL 9.1 installed
Installed PostgreSQL 9.2, disint application and data directory.

Changed postgres instance password in pgAdminIII,  then couldn't log in.
        Set connection Method to trust in pg_hba.conf
        Connect with pgAdmin
        Right Click Login Roles >> postgres
        Uncheck Account expires


Tried to run pg_upgrade:

C:\Users\mmuller\PostgreSQL>"C:\Program Files\PostgreSQL\9.2\bin\pg_upgrade.exe"  --old-datadir data --new-datadir 9.2/data --old-bindir "C:\Program Files\PostgreSQL\9.1\bin" --new-bindir "C:\Program Files\PostgreSQL\9.2\bin" -u postgres

Many problems.  Solutions:

      Grant Firewall permission to PostgreSQL server (windows control panel)
      Set connection Method to trust in pg_hba.conf (both old and new data directories)
      Be sure to set -u postgres

Sunday, March 3, 2013

HP D4620 Reinstallation

My HP D4620 crapped out on me this weekend.  Returned it to Costco. Bought another.

First mistake, tried to set up with my old Ink Cartridges.  No,no.  Printer wouldn't set up with them, nor would it let me take out the old cartridges.  I don't know what I did to finally get them out and install the new ones.

Did a few other things to get Scan To Computer working:

Update Firmware
http://h10025.www1.hp.com/ewfrf/wc/softwareCategory?os=219&lc=en&cc=us&dlc=en&sw_lang=&product=5191646#N332

HP Officejet Full Feature Software and Drivers - Mac OS X 10.6, OS X 10.7, OS X 10.8
http://h10025.www1.hp.com/ewfrf/wc/softwareDownloadIndex?softwareitem=mp-107215-1&cc=us&dlc=en&lc=en&os=219&product=5191646&sw_lang=

Now Scan To Computer Works.