Skip to main content

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 a blank page. However, invoking the debugger via Setting Breakpoint menu runs well (...but slow). I would say pgadmin4 is not ready yet.

Fortunately, google search told that there is someone who forked the pgadmin3 project and continue to maintain it.  In his  website https://www.bigsql.org/pgadmin3/ only the Windows version are available. If you use linux like me, you have to compile your self.

Here is the steps I took to compile pgadmin3. I use ubuntu 12.04, if you use other distro please adjust accordingly.


  1. Install the required packages:

    $sudo apt-get install build-essential git libwxgtk2.8-dev libwxgtk2.8 libxml2 libxslt-dev python-sphinx
  2. Create directory and git clone the source code

    $git clone https://github.com/dimv36/pgadmin3.git
  3. Make

    $cd pgadmin3
    $make
  4. After make you can proceed installing with sudo make install, but as I had already have pgadmin3 package installed, I just copied the resulted binary overwriting the old one:

    $sudo cp pgadmin/pgadmin3 `which pgadmin3`
  5. Finished. Big thanks to Dmitri Voronin ( https://github.com/dimv36 ) for maintaining pgadmin3.



Labels:

Comments

Post a Comment

Popular posts from this blog

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
2 comments
Read more

Program timbangan elektronik, sebuah program Windows yang dijalankan di Linux.

Kemarin, mumpung hari libur aku setup program timbangan digital baru di kantor. Program yang lama merupakan program DOS yang aku tulis dengan menggunakan Clipper, program ini berjalan dengan baik di linux dengan bantuan dosemu. Program baru merupakan program Windows. Salah satu improvement dalam program ini adalah support untuk beberapa jenis indikator. Program diinstall di linux dengan wine versi 1.1.20. Beberapa catatan dalam instalasi program ini di wine: Pencetakan slip bukti timbangan dan laporan-2 menggunakan printer Dot Matrix. Apabila pencetakan dilakukan lewat printer driver, pencetakan dengan printer dot matrix akan menjadi sangat lambat plus hasil buruk plus boros pita... :) Oleh karena itu, program ini melakukan pencetakan langsung melalui printer port lpt1. Di windows, hal ini tidak menjadi suatu permasalahan, di linux dengan wine, maka lpt1 akan dimap ke /dev/lp0. Masalahnya, owner dari device ini adalah root dan group lp. Secara default user-user di Ubuntu (..nggak tahu
13 comments
Read more

NOTEPAD++ SOURCECOOKIFIER SETTING FOR CLIPPER LANGUAGE

Notepad++ is a very excellent programmer editor for Windows. It has plugin system which enhances it's functionality. Sourcecookifier is a plugin I like very much, it is a simple plugin which shows the outline of your source code. The screenshot below shows a pascal (delphi) source code. We can easily see the structure of the source code, and we can go to a particular method/function just by one click. Sourcecookifier recognizes several programming languages, but it does not support Clipper language. Fortunately, it is very easy to add Clipper configure. Follow this step: Click setting icon (the yellow gear icon) on the sourcecookiefier window. Click Language Settings On the setting form, type Clipper on the language box and click add. Set the file extension setting, add .prg to the extenson box On Tag Type choose any letter you like. Here I add “f” for “function” (any letter will be fine) On Appearance box, you can write the de
Post a Comment
Read more