Re: Unable to connect to any data source for foreign server

2024-06-05 Thread Russell Mercer
Hi, Getting back to this after a bit.  I am still having no luck.  I checked the settings for the postgres windows user between the new and old servers, and ensure they are matching.  The user has full control over the directory the file I want to connect to is located in. Here are the resul

Re: Unable to connect to any data source for foreign server

2024-05-29 Thread Muhammad Salahuddin Manzoor
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_f

Unable to connect to any data source for foreign server

2024-05-29 Thread Russell Mercer
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 f