Re: BUG #15131: "ERROR: function pg_current_xlog_location() does not exist" in PGAdmin III

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tkinney(dot)usmc(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15131: "ERROR: function pg_current_xlog_location() does not exist" in PGAdmin III
Date: 2018-03-27 23:59:46
Message-ID: 6607.1522195186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> Upgrade from 9.6.8 to 10.3 and used the 10.3 version of pg_dumpall.
> Everything went smoothly, no errors. Launched PGAdmin III and when I open
> my database I get the following error:

> ERROR: function pg_current_xlog_location() does not exist.

That function's been renamed to pg_current_wal_lsn(), as part of
an effort to standardize our terminology about WAL.

> If a patch exists, I cannot find it.

What you need is a newer PGAdmin version. I'm not sure if III will
ever be updated to PG 10; you may need to get IV.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2018-03-28 03:57:59 Re: PostgreSQL crashes with SIGSEGV
Previous Message David Rowley 2018-03-27 23:49:22 Re: BUG #15131: "ERROR: function pg_current_xlog_location() does not exist" in PGAdmin III