| From: | Russell Mercer <rmercer(at)getspatial(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Unable to connect to any data source for foreign server |
| Date: | 2024-05-29 09:41:58 |
| Message-ID: | fa013ef3-b3e5-43c9-8c3e-8ad59bc9b50a@getspatial.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I'm running into a problem connecting to a foreign server with my
Postgres database. I am using the OGR_FDW trying to connect to an Excel
"XLSX". I had this database on another server, and the foreign server
was set up and working properly there. I am trying to change the path
to the file which it is referencing, and I am now receiving an error.
In addition, I tried to just create a new foreign server to that same
"XLSX" file and it also gave the error of "Failed to connect to data
source".
I used the OGR_FDW_INfo tool to make sure I had the foreign server
reference structured correctly, but it matches what I had before, and
didn't make a difference.
I'm a bit lost as to where to look for possible solutions. One idea I
have is that perhaps it is a permissions issue with accessing other
files on the server where Postgres is installed, with the "postgres" user.
Some basic info:
Server: Windows Server 2022
PostgreSQL 16.2 - Installed using Stack Builder
Any information or ideas as to a solution, would be very much appreciated.
Thanks,
Russell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muhammad Salahuddin Manzoor | 2024-05-29 10:15:11 | Re: Unable to connect to any data source for foreign server |
| Previous Message | Muhammad Salahuddin Manzoor | 2024-05-29 09:40:45 | Re: Memory issues with PostgreSQL 15 |