bug#29914: 27.0.50; pg.el - protocol version 1.0 not supported, PostgreSQL 10.1 dropped 1.0 support

bug#29914: 27.0.50; pg.el - protocol version 1.0 not supported, PostgreSQL 10.1 dropped 1.0 support

[Jean M. Louis]

I have upgraded PostgreSQL from 9.6 to 10.1 and that version is dropping
support for protocol 1.0, which is then (probably) used by pg.el
package, the Emacs connection to PostgreSQL.

Now, I cannot connect to PostgreSQL, if somebody can help me make
changes or advise me which package to use?

Jean Louis


In GNU Emacs 27.0.50 (build 3, x86_64-pc-linux-gnu, X toolkit, Xaw3d scroll bars)
 of 2017-12-31 built on localhost.rcdrun.com
Repository revision: a5835dfee139322de7aa071f1c87ef015acbecad
Windowing system distributor 'The X.Org Foundation', version 11.0.11801000
System Description: GNU/Linux OS (GNU.Support) 0.1

Recent messages:
For information about GNU Emacs and the GNU system, type C-h C-a.

Configured using:
 'configure --prefix=/package/text/emacs-27.0.50/ --with-mailutils
 --without-imagemagick --without-pop --with-x-toolkit=lucid
 PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/opt/qt4/lib/pkgconfig:/opt/qt5/lib/pkgconfig'

Configured features:
XAW3D XPM JPEG TIFF GIF PNG RSVG SOUND GPM DBUS GSETTINGS NOTIFY ACL
LIBSELINUX GNUTLS LIBXML2 FREETYPE XFT ZLIB TOOLKIT_SCROLL_BARS LUCID
X11 LCMS2

Important settings:
  value of $LANG: en_US.UTF-8
  locale-coding-system: utf-8-unix

Major mode: Lisp Interaction

Minor modes in effect:
  tooltip-mode: t
  global-eldoc-mode: t
  eldoc-mode: t
  electric-indent-mode: t
  mouse-wheel-mode: t
  tool-bar-mode: t
  menu-bar-mode: t
  file-name-shadow-mode: t
  global-font-lock-mode: t
  font-lock-mode: t
  blink-cursor-mode: t
  auto-composition-mode: t
  auto-encryption-mode: t
  auto-compression-mode: t
  line-number-mode: t
  transient-mark-mode: t

Load-path shadows:
None found.

Features:
(shadow sort mail-extr emacsbug message rmc puny seq byte-opt gv
bytecomp byte-compile cconv cl-loaddefs cl-lib dired dired-loaddefs
format-spec rfc822 mml easymenu mml-sec password-cache epa derived epg
epg-config gnus-util rmail rmail-loaddefs mm-decode mm-bodies mm-encode
mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047
rfc2045 ietf-drums mm-util mail-prsvr mail-utils elec-pair time-date
mule-util tooltip eldoc electric uniquify ediff-hook vc-hooks
lisp-float-type mwheel term/x-win x-win term/common-win x-dnd tool-bar
dnd fontset image regexp-opt fringe tabulated-list replace newcomment
text-mode elisp-mode lisp-mode prog-mode register page menu-bar
rfn-eshadow isearch timer select scroll-bar mouse jit-lock font-lock
syntax facemenu font-core term/tty-colors frame cl-generic cham georgian
utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean
japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european
ethiopic indian cyrillic chinese composite charscript charprop
case-table epa-hook jka-cmpr-hook help simple abbrev obarray minibuffer
cl-preloaded nadvice loaddefs button faces cus-face macroexp files
text-properties overlay sha1 md5 base64 format env code-pages mule
custom widget hashtable-print-readable backquote dbusbind inotify lcms2
dynamic-setting system-font-setting font-render-setting x-toolkit x
multi-tty make-network-process emacs)

Memory information:
((conses 16 95833 8357)
 (symbols 48 20452 1)
 (miscs 40 42 120)
 (strings 32 29181 1478)
 (string-bytes 1 769863)
 (vectors 16 14149)
 (vector-slots 8 500532 9188)
 (floats 8 51 66)
 (intervals 56 244 0)
 (buffers 992 12)
 (heap 1024 16985 1212))

bug#29914: 27.0.50; pg.el - protocol version 1.0 not supported, PostgreSQL 10.1 dropped 1.0 support

[Glenn Morris]

Jean M. Louis wrote:

> I have upgraded PostgreSQL from 9.6 to 10.1 and that version is dropping
> support for protocol 1.0, which is then (probably) used by pg.el
> package, the Emacs connection to PostgreSQL.
>
> Now, I cannot connect to PostgreSQL, if somebody can help me make
> changes or advise me which package to use?

I suggest you ask whoever maintains pg.el.
Since it isn't part of GNU Emacs or GNU ELPA I will close this report.

Emacs includes sql.el. You might try that, but I know nothing about it.