MIME-Version: 1.0
References: <fa013ef3-b3e5-43c9-8c3e-8ad59bc9b50a@getspatial.com>
In-Reply-To: <fa013ef3-b3e5-43c9-8c3e-8ad59bc9b50a@getspatial.com>
From: Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
Date: Wed, 29 May 2024 15:15:11 +0500
Message-ID: <CAKD7CD=14QPRpTCtFg2kz3Ly_Y-gGh5PyMsUH_Ph_P4tj-gFUw@mail.gmail.com>
Subject: Re: Unable to connect to any data source for foreign server
To: Russell Mercer <rmercer@getspatial.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006528a106199507c2"
Archived-At: <https://www.postgresql.org/message-id/CAKD7CD%3D14QPRpTCtFg2kz3Ly_Y-gGh5PyMsUH_Ph_P4tj-gFUw%40mail.gmail.com>
Precedence: bulk

--0000000000006528a106199507c2
Content-Type: text/plain; charset="UTF-8"

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.

On Wed, 29 May 2024, 14:42 Russell Mercer, <rmercer@getspatial.com> wrote:

> 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
>
>
>
>

--0000000000006528a106199507c2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Greetings,</div><div dir=3D"auto"><br></div><div dir=
=3D"auto">While configuring ORG_FWD.</div><div dir=3D"auto">I hope you are =
setting path like server name and absolute path to file on your network sha=
re and network share has appropriate permissions.</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">&#39;\\remote_server\path\to\file.xlsx&#39; on ne=
twork share<br></div><div><br></div><div dir=3D"auto">Create user mapping i=
f required.</div><div dir=3D"auto"><br></div><div dir=3D"auto">check your c=
onfig through</div><div dir=3D"auto"><div dir=3D"auto">ogr_fdw_info -s &quo=
t;\\\\remote_server\\path\\to\\file.xlsx&quot; -l</div><div dir=3D"auto"><b=
r></div></div><div dir=3D"auto">To diagnose the issue you can check permiss=
ions, network accessability, path format should include server name and abs=
olute file path and any compatability issues.</div><div dir=3D"auto"><br></=
div><div dir=3D"auto">Regards,</div><div dir=3D"auto">Salahuddin.</div></di=
v><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On W=
ed, 29 May 2024, 14:42 Russell Mercer, &lt;<a href=3D"mailto:rmercer@getspa=
tial.com">rmercer@getspatial.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">Hi,<br>
<br>
I&#39;m running into a problem connecting to a foreign server with my <br>
Postgres database.=C2=A0 I am using the OGR_FDW trying to connect to an Exc=
el <br>
&quot;XLSX&quot;.=C2=A0 I had this database on another server, and the fore=
ign server <br>
was set up and working properly there.=C2=A0 I am trying to change the path=
 <br>
to the file which it is referencing, and I am now receiving an error.=C2=A0=
 <br>
In addition, I tried to just create a new foreign server to that same <br>
&quot;XLSX&quot; file and it also gave the error of &quot;Failed to connect=
 to data <br>
source&quot;.<br>
<br>
I used the OGR_FDW_INfo tool to make sure I had the foreign server <br>
reference structured correctly, but it matches what I had before, and <br>
didn&#39;t make a difference.<br>
<br>
I&#39;m a bit lost as to where to look for possible solutions.=C2=A0 One id=
ea I <br>
have is that perhaps it is a permissions issue with accessing other <br>
files on the server where Postgres is installed, with the &quot;postgres&qu=
ot; user.<br>
<br>
Some basic info:<br>
<br>
Server:=C2=A0 Windows Server 2022<br>
PostgreSQL 16.2 - Installed using Stack Builder<br>
<br>
Any information or ideas as to a solution, would be very much appreciated.<=
br>
<br>
Thanks,<br>
Russell<br>
<br>
<br>
<br>
</blockquote></div>

--0000000000006528a106199507c2--