From: | Nikhil Kshirsagar <nkshirsagar(at)reisystems(dot)com> |
---|---|
To: | Stephen Cook <sclists(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: FDW user mapping |
Date: | 2017-09-29 15:16:27 |
Message-ID: | CY1PR0201MB1468DA711B6942D08195E939DE7E0@CY1PR0201MB1468.namprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
I tried using user instead of username. I get the same error -
"ERROR:
invalid option "user"
HINT: Valid options in this context are: <none>"
-----Original Message-----
From: Stephen Cook [mailto:sclists(at)gmail(dot)com]
Sent: Thursday, September 28, 2017 11:01 PM
To: Nikhil Kshirsagar <nkshirsagar(at)reisystems(dot)com>; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] FDW user mapping
It is "user", not "username". This happens to me often :)
-- Stephen
On 2017-09-28 16:15, Nikhil Kshirsagar wrote:
> Hello,
>
>
>
> I want to create foreign data wrapper to access table from SQL server 2012.
>
> I have PostgreSQL9.6. I am facing issues while trying to create user
> mapping. Please find details below
>
>
>
> 1. From
> "http://www.postgresonline.com/journal/archives/361-Foreign-Data-Wrappers-for-PostgreSQL-9.5-windows.html"
> link, I did download and install PostgreSQL 9.6 w64 FDWs installed
> with name'LocalSQL2012ForPg'
> 2. Installed the ODBC FDW in PostgreSQL with SQL Statement: CREATE
> EXTENSION odbc_fdw;
> 3. Ran - CREATE SERVER localsql2012 FOREIGN DATA WRAPPER odbc_fdw
> OPTIONS (dsn 'LocalSQL2012ForPg'); 4. Next I am trying to run
> below query -
>
> CREATE USER MAPPING
>
> FOR postgres
>
> SERVER localsql2012
>
> OPTIONS (username 'pgadmin',password 'pgadmin');
>
>
>
> When I execute above query, I constantly get below error - "ERROR:
> invalid option "username"
> HINT: Valid options in this context are: <none>"
>
>
>
> I verified that pgadmin user is present and can access MS SQL server 2012.
>
>
>
> Can you please let me know what I am missing?
>
>
>
> Thanks & Regards,
>
> *Nikhil Kshirsagar*
>
> REI Systems, Inc...Achieving Excellence Together
>
> Ph.No. : (703)-480-7638 | Cell No: (972)-839-9027
>
> nkshirsagar(at)reisys(dot)com <mailto:nkshirsagar(at)reisys(dot)com> |
> www.reisys.com <http://www.reisys.com/>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-09-29 17:22:23 | Re: FDW user mapping |
Previous Message | David G. Johnston | 2017-09-29 14:50:15 | Re: [NOVICE] Finding Release Dates for next Postgres? |