Postgres Pro
Downloads
Home   >   mailing lists

Re: REFRESH MATERIALIZED VIEW error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: REFRESH MATERIALIZED VIEW error
Date
Msg-id 2648294.1696460625@sss.pgh.pa.us
Whole thread Raw
In response to REFRESH MATERIALIZED VIEW error  ("Given, Robert A" <bgiven@bu.edu>)
Responses RE: REFRESH MATERIALIZED VIEW error  ("Given, Robert A" <bgiven@bu.edu>)
List pgsql-bugs
Tree view 
"Given, Robert A" <bgiven@bu.edu> writes:
> After an OS upgrade from CentOS 7 to RHEL 9.2, our Materialized Views are not getting refreshed. We are receiving
thiserror: 
>> From log...
> 2023-10-04 00:04:01.885 EDT [235717] ERROR:  could not access file "$libdir/file_fdw": No such file or directory

You didn't install the file_fdw.so library that underlies the file_fdw
extension.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows
Next
From: Peter Smith
Date:
Subject: Re: [16+] subscription can end up in inconsistent state