Skip to main content

Posts

Showing posts from 2017

Postgresql 9.6 and Pgadmin3 trouble

Yesterday, I updated my PostgreSQL to the latest version 9.6 from version 9.5. The upgrade process went successfully, unfortunately pgadmin choked a little bit dealing with PostgreSQL 9.6, everytime we want to define primary key an error is thrown: ERROR: column "amgettuple" does not exist LINE 1: ...am WHERE EXISTS (SELECT 1 FROM pg_proc WHERE oid=amgettuple... we can ignore this error and the primary key creation will succeed, however it is annoying. My pgadmin was the latest version: pgadmin3 v 1.22.2 Visiting  https://pgadmin.org/download/source.php  reveals that this version is the final version and won't be supported anymore. We are encouraged to use pgadmin4 instead. I then downloaded and installed pgadmin4, installation was a pain in ass but I succeeded got it installed. However, pgadmin4 was terribly very slow. It also got a problem with the function debugger. After function parameters entry, the debugger is showed, unfortunately it only shows

Install Sketchup 2017 64 bits on Linux Ubuntu 16.04 64 bits

Install Sketchup 2017 64 bits on Linux Ubuntu 16.04 64 bits: 1.Enable 32 bit architecture: $sudo dpkg --add-architecture i386  2. Set wine PPA $sudo add-apt-repository ppa:wine/wine-builds Update repository $sudo apt-get update 3. Install wine newest staging branch version $sudo apt-get install --install-recommends winehq-staging 4. Ensure we get a 64bits wine, edit file ~/.profile and locate for text: export WINEARCH= If the value is win64 you are good, if the value is win32 change it to win64. Save the file. Ensure the environment variable also set to win64 by typing command: $export WINEARCH=win64 5. Download winetricks: $wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks    Don't forget to set the attribute so it is executable $chmod +x winetricks 6. Run winetricks $./winetricks Inside winetricks: Choose Select the default wineprefix, click OK Choose Install a Windows DLL or component, click OK Choos