Re: [GENERAL] pg_restore error -- missing pg table

--- t...@sss.pgh.pa.us wrote: From: Tom Lane <t...@sss.pgh.pa.us> To: "" <kbran...@pwhome.com> cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore error -- missing pg table Date: Mon, 11 Sep 2017 13:43:16 -0400 "" <kbran...@pwhome.com> writ

Re: [GENERAL] pg_restore error -- missing pg table

"" writes: > /opt/pgsql-9.5/bin/pg_restore -v --clean --create --dbname=nms > --schema=public . > ... > pg_restore: [archiver (db)] could not execute query: ERROR: function > _pg_sv_column_array(oid, smallint[]) does not exist > LINE 6: _pg_sv_column_array(k1.conrelid,

[GENERAL] pg_restore error -- missing pg table

We've been doing backups and restores with many tests and uses and never had a problem until now. Sadly, I'm not sure where to even begin looking to figure out what to do, so any pointers would be very much appreciated! The vital stats: Pg: 9.5.1 (this will get upgraded to 10.0 when it's