--- t...@sss.pgh.pa.us wrote:
From: Tom Lane
To: ""
cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore error -- missing pg table
Date: Mon, 11 Sep 2017 13:43:16 -0400
"" writes:
> /opt/pgsql-9.5/bin/pg_restore -v --clean --create --dbname
"" 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, k1.conkey) AS fk_colu
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 av
