From: | "Given, Robert A" <bgiven(at)bu(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: REFRESH MATERIALIZED VIEW error |
Date: | 2023-10-05 14:19:52 |
Message-ID: | DM6PR03MB3497C89EF317157D5775DDEBA6CAA@DM6PR03MB3497.namprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thank you Tom! We downloaded the file_fdw.so library and recompiled the Materialized views and the application is running normally.
Thank you for your insight!
Bob
-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Wednesday, October 4, 2023 5:04 PM
To: Given, Robert A <bgiven(at)bu(dot)edu>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: REFRESH MATERIALIZED VIEW error
"Given, Robert A" <bgiven(at)bu(dot)edu> writes:
> After an OS upgrade from CentOS 7 to RHEL 9.2, our Materialized Views are not getting refreshed. We are receiving this error:
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2023-10-05 14:44:19 | BUG #18148: Handle null in a date/time fields when passing empty arrays issue |
Previous Message | PG Bug reporting form | 2023-10-05 14:01:06 | BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx |