pg v10.3 ERROR: function pg_last_xlog_receive_location() does not exist

NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers

BSD 3-Clause "New" or "Revised" License

1.03k stars 113 forks source link

pg v10.3 ERROR: function pg_last_xlog_receive_location() does not exist #12

Closed seadba closed 6 years ago

seadba commented 6 years ago

Hello, cool tool - is there a version that works with v10?

Type your choice and press : 1 psql.bin:/instance1/postgres/10/sitewatch/test/postgres_dba/sql/1_basic.sql:53:ERROR: function pg_last_xlog_receive_location() does not exist LINE 13: when pg_last_xlog_receive_location() = pg_last_xlo... ^ HINT: No function matches the given name and argument types. You might need toadd explicit type casts. Press to continue…

NikolayS commented 6 years ago

hi @seadba thanks for catching this!

Just fixed it and committed to master, please check. Now report 1 has to work both with postgres 10 and earlier versions.

seadba commented 6 years ago

excellent - works well , thanks very much for the fast response - great tool