Thursday, June 23, 2016

PostgreSQL Upgrade - Fedora 24

Fedora 24 will upgrade your PostgreSQL database from 9.4.8-1 to 9.5.3-1.

Since this is a major upgrade it will require that you upgrade your database.

Here is how to do it:

  1. Install the upgrade utilities:  dnf install postgresql-upgrade
  2. Become user postgres:  sudo su - postgres
  3. Rename the data directory:  mv /var/lib/pgsql/data/ /var/lib/pgsql/data_9.4/
  4. As root, initialize your 9.5 database:  sudo postgresql-setup initdb
  5. As user postgres, Copy your pg_hba.conf:  cp /var/lib/pgsql/data_9.4/pg_hba.conf/ /var/lib/pgsql/data/pg_hba.conf/
  6. To avoid any potential password issues, temporarily change "md5" to "trust" in both pg_hba.conf files
  7. Run the upgrade process:  pg_upgrade -b /usr/lib64/pgsql/postgresql-9.4/bin/ -B /usr/bin/ -d data_9.4/ -D data
  8. Change "trust" to md5" if you changed in step 6 
  9. Enable your postgresql.service:  sudo systemctl enable postgresql.service
  10. Start your postgresql.service:  sudo systemctl start postgresql.service
  11. Run the analyse_new_cluster.sh script as suggested
  12. Run the delete_old_cluster.sh script as suggested
Note:  When running commands as the postgres user, it is assumed you are running them from the postgres user $home directory.  This will be your location after you enter the command in step 2.  If you for some reason change to another directory from this userid, just remember to enter:  cd $home before entering any postgresql commands - otherwise you may not be able to execute the desired command, or may receive a permission error.

Thursday, May 19, 2016

Google Allo & Duo - Innovation, Desperation or Emulation

I am about as pro-Google as a person can get.  This blog is on Blogger, I use GMail, Google Apps, G+, Google Photos, Calendar, Chrome, Music, Android, TV, etc. - but as of late Google has lost my loyalty.  As the saying goes:  "Fooled me once, shame on you.  Fooled me twice, shame on me."

In the past I've been excited and enthusiastic about such announcements; wondering what great new things Google was creating.  Now - not so much.  Is this Innovation, Desperation or Emulation.

It isn't Innovation.  Telegram is a messaging application which is available now and does everything that Allo claims to do, and more.  Desperation?  I seriously doubt it  Google has so much money this is just a blip on their radar, if that.  Emulation?  Yup... they figure that messaging is so fundamental, they might as well have a messaging client.  Based on the feature set, platforms and availability they clearly aren't that excited about it; almost seems like an afterthought.

I'm sure by now everyone is familiar with the Allo & Duo Product Announcement.  This was one of their major announcements from the 2016 Google I/O... another messaging app.  Huh?  We were told that Hangouts (which was to replace SMS and GTalk) was going to the Google Messaging solution.  Then, not too much later Google Messenger was introduced on Android to handle SMS.  That should have been a red flag.  The problem with Google is they can't make up their mind.

Instead of launching a product and improving it, they have gotten into the habit of letting the current product wither and just launching another replacement.

What they are forgetting about messaging is that it's not just the decision of one person which messaging app you use... what is also important is the application that your friends and colleagues choose to use.

Another factor is pervasiveness of the application.  The more places it can run, the larger the potential customer base.  They have decided that Allo is to run only on mobile.  If you want to send messages from your Desktop, you can use Hangouts.  Huh?

What we are also being told is that not all of the features of Hangouts are available in Allo - but don't worry; you can continue to use Hangouts for that.... and eventually, maybe, someday, could be, we will be updating Allo.  Seriously?  Didn't you say that about Hangouts?  What is more likely to happen, based upon past experience, is that Google will simply discontinue Allo and come out with something else - and expect everyone to switch again to a new application.

This has become Google's modus operandi.  Google thinks that their customers have not noticed, or that their customers do not care.  They are mistaken.  What Google doesn't seem to understand is that if you want people and their contacts to switch to your product there needs to be a compelling reason to do so.  Allo just isn't compelling.

Of course this is assuming that Google cares.  It could be simply that they don't care - and that this is just one big kabuki dance to make everyone believe they are trying to innovate and compete in the messaging space.  Either way, it isn't working.  They clearly aren't serious.  One only need look to see what is available from the competition.  This is too little, too late.

I currently use Telegram and it currently supports everything that Allo will do, is available now and runs on every imaginable platform (yes, including Linux Desktops which Google has been ignoring for years).  Telegram supports phone number signup and allows to also create a nickname (if you don't want people to know your phone number).  If you want an open source, full featured, secure, continually improving messaging client that runs on ALL platforms, and is available NOW - check out Telegram.


Saturday, May 23, 2015

Telegram Messenger Installation for Fedora

Telegram is a lightweight messenger platform which is easy to install, configure and use.  It is quite similar to Facebook owned Whatsapp messenger, but has the following advantages:

  1. Your chats are synchronized across all your devices  
  2. You can install and send messages from your phone, tablet and/or desktop
  3. You can send documents of any type
  4. The client is open source and is licensed under GPLv3
  5. It is free.  No ads or subscription fees
  6. There are no limits on the size of your media or chats
  7. Your messages are encrypted
The Telegram installation instructions are simple and easy to follow.  I have also created a telegram_install script which you can download and execute.  Be sure to set the script as executable first by issuing the command:  chmod +x telegram_install

The script will do the following:

  1. Check the architecture to determine if you are running 32bit or 64bit
  2. Download the appropriate version and save it as tsetup.tar.xz
  3. Extract the compressed tar file into your home directory
  4. Start the Telegram setup program
  5. Remove tsetup.tar.xz (as it is no longer needed)
Telegram will create a desktop file to allow you to click on an icon from your start menu:($HOME/.local/share/applications/telegramdesktop.desktop)


Telegram will automatically upgrade as new versions are available.

If you wish to uninstall, simply:

  1. rm $HOME/Telegram --recursive
  2. rm $HOME/.local/share/applications/telegramdesktop.desktop


Sunday, May 3, 2015

PostgreSQL Upgrade - Fedora 22

Fedora 22 will upgrade your PostgreSQL database from 9.3.6 to 9.4.1

Since this is a major upgrade it will require that you upgrade your database.

Here is how to do it:

  1. Install the upgrade utilities:  dnf install postgresql-upgrade
  2. Become user postgres:  sudo su - postgres
  3. Rename the data directory:  mv /var/lib/pgsql/data/ /var/lib/pgsql/data_9.3/
  4. As root, initialize your 9.4 database:  sudo postgresql-setup initdb
  5. As user postgres, Copy your pg_hba.conf:  cp /var/lib/pgsql/data_9.3/pg_hba.conf  /var/lib/pgsql/data/pg_hba.conf
  6. To avoid any potential password issues, temporarily change "md5" to "trust" in both pg_hba.conf files
  7. Run the upgrade process:  pg_upgrade -b /usr/lib64/pgsql/postgresql-9.3/bin/ -B /usr/bin/ -d data_9.3/ -D data
  8. Change "trust" to md5" if you changed in step 6 
  9. Enable your postgresql.service:  sudo systemctl enable postgresql.service
  10. Start your postgresql.service:  sudo systemctl start postgresql.service
  11. Run the analyse_new_cluster.sh script as suggested
  12. Run the delete_old_cluster.sh script as suggested

Wednesday, May 14, 2014

Enable Google Profile name and icon with Chrome Profile Management

This is no longer an experimental feature and is now enabled by default, so the information listed below no longer applies.

Chrome has a feature called:  Chrome Profile Management which allows you to setup multiple users of Chrome on the same computer.  Google has introduced an experimental feature which changes the way new users are managed.  It also will display your avatar and name from your Google account; assuming you have logged in.

Information about this Experimental Chrome Profile Management feature can be found on Google Plus.

Since this is an experimental feature, the functions available are under development and may be different depending on which version of Chrome you are running.  If the feature is discontinued or migrated as a regular feature I will update this post.

I am running the latest normal version of chrome (not beta):  34.0.1847.137

To activate, go to chrome://flags and enable: 

Enable new profile management system
Enable Google profile name and icon

Chrome Flag Default Settings

After you enable, the Relaunch Now button will appear, press it to relaunch Chrome and activate the changes. 

Relaunch Now Button appears to apply changes

When Chrome relaunches, assuming you are logged into your Google Account you will see your avatar at the top left corner of the screen.  You're done.

Chrome Flag showing changes enabled


Tuesday, December 17, 2013

PostgreSQL Upgrade - Fedora 20

Fedora 20 will upgrade your PostgreSQL database from 9.2.6-1 to 9.3.1-2.

Since this is a major upgrade it will require that you upgrade your database.

Here is how to do it:

  1. Install the upgrade utilities:  yum install postgresql-upgrade
  2. Become user postgres:  sudo su - postgres
  3. Rename the data directory:  mv /var/lib/pgsql/data/ /var/lib/pgsql/data_9.2/
  4. As root, initialize your 9.3 database:  sudo postgresql-setup initdb
  5. As user postgres, Copy your pg_hba.conf:  cp /var/lib/pgsql/data_9.2/pg_hba.conf/ /var/lib/pgsql/data/pg_hba.conf/
  6. To avoid any potential password issues, temporarily change "md5" to "trust" in both pg_hba.conf files
  7. Run the upgrade process:  pg_upgrade -b /usr/lib64/pgsql/postgresql-9.2/bin/ -B /usr/bin/ -d data_9.2/ -D data
  8. Change "trust" to md5" if you changed in step 6
  9. Enable your postgresql.service:  sudo systemctl enable postgresql.service
  10. Start your postgresql.service:  sudo systemctl start postgresql.service
  11. Run the analyse_new_cluster.sh script as suggested
  12. Run the delete_old_cluster.sh script as suggested

Thursday, July 11, 2013

Fedora 19 Installation on the ASUS X401U

If you want a great budget laptop that runs Fedora with no issues, look no further: 
ASUS X401U - Best Buy

It's not a speed demon, but:
  • Great form factor, thin and light
  • AMD processor - more bang for the buck
  • ASUS build quality
  • Open Source compatibility
  • Bright sharp display, supports desktop effects
  • Perfectly fine for web surfing, word processing, watching videos, music, light gaming, etc.

What's the negative?  It comes bundled with Windows.  Well, it's easy to fix that by installing Fedora 19.

First you'll need to download the Fedora Network Install Image

Then put that image on a USB stick.  You only need 512Mb.
Making USB Media

Insert the USB stick in the laptop.

Disable the UEFI secure boot - you don't need it.  If you want to read more about it:  UEFI Secure Boot Guide

When powering on your system for the first time, you will be presented with the boot menu.

Please select boot device:
Windows 8
Enter Setup
 Select:  Enter Setup - to enter the BIOS settings

Go to the Security tab, scroll down until you ave selected:
System Boot Control                    [Enabled]
When you have selected, you will notice the text is now white, and on the right side of the screen you will see the text:

Secure Boot flow control.
Secure Boot is possible only if System runs in User mode

Press enter, a blue menu will pop up, with the word Enabled in a black background.  Use the down arrow to select:  Disabled

Press enter, then press F10 to save and exit.

When the system boots again, select the inserted USB stick to boot the Fedora Network install.

Follow the prompts.  When you reach the part about the installation media, select the entire drive and tell Fedora to reclaim the space.  The other installation defaults are fine.  Be advised if you reclaim the entire disk (which is what I did) there is no going back.  ASUS ships the disk with a recovery partition, and if you reclaim the entire disk, you've erased that partition.

You may wish to plug in a network cable rather than using wireless for the install, that would be faster.  The network connector on the laptop has a latch that you may need to manually pull down a bit if you have problems removing the Ethernet cable.  You'll notice it moves downward when you first insert the cable, then snaps back up somewhat to lock the cable in place.