pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedREFRESH MATERIALIZED VIEW error
3+ messages / 2 participants
[nested] [flat]
* REFRESH MATERIALIZED VIEW error
@ 2023-10-04 17:46 Given, Robert A <bgiven@bu.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Given, Robert A @ 2023-10-04 17:46 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; +Cc: Given, Robert A <bgiven@bu.edu>
Greetings,
After an OS upgrade from CentOS 7 to RHEL 9.2, our Materialized Views are not getting refreshed. We are receiving this error:
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: REFRESH MATERIALIZED VIEW error
@ 2023-10-04 23:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Given, Robert A <bgiven@bu.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2023-10-04 23:03 UTC (permalink / raw)
To: Given, Robert A <bgiven@bu.edu>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
"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 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: REFRESH MATERIALIZED VIEW error
@ 2023-10-05 14:19 Given, Robert A <bgiven@bu.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Given, Robert A @ 2023-10-05 14:19 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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@sss.pgh.pa.us>
Sent: Wednesday, October 4, 2023 5:04 PM
To: Given, Robert A <bgiven@bu.edu>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: REFRESH MATERIALIZED VIEW error
"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 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-05 14:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-04 17:46 REFRESH MATERIALIZED VIEW error Given, Robert A <bgiven@bu.edu>
2023-10-04 23:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-05 14:19 ` Given, Robert A <bgiven@bu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox