Greetings,
While configuring ORG_FWD.
I hope you are setting path like server name and absolute path to file on your network share and network share has appropriate permissions.
'\\remote_server\path\to\file.xlsx' on network share
Create user mapping if required.
check your config through
ogr_fdw_info -s "\\\\remote_server\\path\\to\\file.xlsx" -l
To diagnose the issue you can check permissions, network accessability, path format should include server name and absolute file path and any compatability issues.
Regards,
Salahuddin.
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