public inbox for [email protected]  

help / color / mirror / Atom feed

From: Russell Mercer <[email protected]>
To: [email protected]
Subject: Unable to connect to any data source for foreign server
Date: Wed, 29 May 2024 02:41:58 -0700
Message-ID: <[email protected]> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Unable to connect to any data source for foreign server
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox