pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConnecting to Oracle from Postgresql 9.2 on Windows
9+ messages / 4 participants
[nested] [flat]
* Connecting to Oracle from Postgresql 9.2 on Windows
@ 2013-11-01 05:53 Rune Gullstrom <rgullstrom@gmail.com>
2013-11-01 06:15 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Raghu Ram <raghuchennuru@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
0 siblings, 2 replies; 9+ messages in thread
From: Rune Gullstrom @ 2013-11-01 05:53 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm very new to postgres. I've been searching the net for a solution to
connect to our Oracle (11g) databases.
What are my options if I install postgres 9.2 on a window server?
The only options I see (e.g. on fusion forge) seem to be for postgres on
linux/unix,
regards,
Rune
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
@ 2013-11-01 06:15 ` Raghu Ram <raghuchennuru@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Raghu Ram @ 2013-11-01 06:15 UTC (permalink / raw)
To: Rune Gullstrom <rgullstrom@gmail.com>; +Cc: pgsql-admin
On Fri, Nov 1, 2013 at 11:23 AM, Rune Gullstrom <rgullstrom@gmail.com>wrote:
> Hi,
>
> I'm very new to postgres. I've been searching the net for a solution to
> connect to our Oracle (11g) databases.
> What are my options if I install postgres 9.2 on a window server?
> The only options I see (e.g. on fusion forge) seem to be for postgres on
> linux/unix,
>
>
Below URL provide more information about database link from Oracle to
PostgreSQL:
http://boomslaang.wordpress.com/2009/10/06/configure_heterogeneous_connection_from_oracle_db_to_post...
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
@ 2013-11-02 06:32 ` Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Christian Ullrich @ 2013-11-02 06:32 UTC (permalink / raw)
To: pgsql-admin
* Rune Gullstrom wrote:
> I'm very new to postgres. I've been searching the net for a solution to
> connect to our Oracle (11g) databases.
> What are my options if I install postgres 9.2 on a window server?
> The only options I see (e.g. on fusion forge) seem to be for postgres on
> linux/unix,
<http://oracle-fdw.projects.pgfoundry.org/;
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
@ 2013-11-03 22:56 ` Rune Gullstrom <rgullstrom@gmail.com>
2013-11-04 05:31 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
0 siblings, 1 reply; 9+ messages in thread
From: Rune Gullstrom @ 2013-11-03 22:56 UTC (permalink / raw)
To: Christian Ullrich <chris@chrullrich.net>; +Cc: pgsql-admin
Thanks Christian,
I found this one, downloaded it but it seems this is for postgressql on
unix/linux not for postgresql on windows,
right?
regards,
Rune
On Sat, Nov 2, 2013 at 5:32 PM, Christian Ullrich <chris@chrullrich.net>wrote:
> * Rune Gullstrom wrote:
>
> I'm very new to postgres. I've been searching the net for a solution to
>> connect to our Oracle (11g) databases.
>> What are my options if I install postgres 9.2 on a window server?
>> The only options I see (e.g. on fusion forge) seem to be for postgres on
>> linux/unix,
>>
>
> <http://oracle-fdw.projects.pgfoundry.org/;
>
> --
> Christian
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
@ 2013-11-04 05:31 ` Christian Ullrich <chris@chrullrich.net>
2013-11-04 13:52 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 1 reply; 9+ messages in thread
From: Christian Ullrich @ 2013-11-04 05:31 UTC (permalink / raw)
To: pgsql-admin
* Rune Gullstrom wrote:
> I found this one, downloaded it but it seems this is for postgressql on
> unix/linux not for postgresql on windows,
> right?
Well, I have not used it myself, but just from looking at the download
page I think it works on Windows, too. It looks like they have no binary
packages for 64-bit Windows available, so if your server is of that
sort, you probably have to build it yourself anyway.
Here is a link to a discussion on the same topic:
<http://lists.pgfoundry.org/pipermail/oracle-fdw-general/2012q4/000065.html;
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-04 05:31 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
@ 2013-11-04 13:52 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-11-05 22:33 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
0 siblings, 1 reply; 9+ messages in thread
From: Albe Laurenz @ 2013-11-04 13:52 UTC (permalink / raw)
To: Christian Ullrich *EXTERN* <chris@chrullrich.net>; pgsql-admin
Christian Ullrich wrote:
> * Rune Gullstrom wrote:
> [oracle_fdw]
>> I found this one, downloaded it but it seems this is for postgressql on
>> unix/linux not for postgresql on windows,
>> right?
>
> Well, I have not used it myself, but just from looking at the download
> page I think it works on Windows, too. It looks like they have no binary
> packages for 64-bit Windows available, so if your server is of that
> sort, you probably have to build it yourself anyway.
It should work on 64-bit Windows, but I have no such machine to build it.
I'd be happy to publish binaries if somebody can build them.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-04 05:31 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-04 13:52 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Albe Laurenz <laurenz.albe@wien.gv.at>
@ 2013-11-05 22:33 ` Christian Ullrich <chris@chrullrich.net>
2013-11-06 08:42 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 1 reply; 9+ messages in thread
From: Christian Ullrich @ 2013-11-05 22:33 UTC (permalink / raw)
To: pgsql-admin; +Cc: rgullstrom@gmail.com
* Albe Laurenz wrote:
> It should work on 64-bit Windows, but I have no such machine to build it.
> I'd be happy to publish binaries if somebody can build them.
Every time I go up against what passes for a PostgreSQL build system on
Windows, I am pleasantly surprised that it is not half as fragile as it
looks.
I now have working 64-bit builds of oracle_fdw.dll for both 9.2 and 9.3,
built against the respective git branches. The only thing is, I'm not at
all conversant with the build environment required for portable
extension modules. I have been using Visual Studio 2012; do I have to
build with 2008 to avoid runtime library clashes, or is that not an
issue here?
Rune, if you want to try my DLLs, I'll be happy to send them to you.
postgres=# select version();
version
-------------------------------------------------------------
PostgreSQL 9.3.1, compiled by Visual C++ build 1700, 64-bit
(1 row)
postgres=# create extension oracle_fdw;
CREATE EXTENSION
postgres=# create server oradb foreign data wrapper oracle_fdw options
(dbserver '//oracle.local/orcl');
CREATE SERVER
postgres=# create user mapping for postgres server oradb options (user
'hr', password 'hr');
CREATE USER MAPPING
postgres=# create foreign table oradepts (department_id integer not
null, department_name varchar(30) not null, manager_id integer,
location_id integer) server oradb options (table 'DEPARTMENTS');
CREATE FOREIGN TABLE
postgres=# select * from oradepts;
department_id | department_name | manager_id | location_id
---------------+----------------------+------------+-------------
10 | Administration | 200 | 1700
20 | Marketing | 201 | 1800
30 | Purchasing | 114 | 1700
40 | Human Resources | 203 | 2400
50 | Shipping | 121 | 1500
60 | IT | 103 | 1400
...
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting to Oracle from Postgresql 9.2 on Windows
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-02 06:32 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-04 05:31 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
2013-11-04 13:52 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Albe Laurenz <laurenz.albe@wien.gv.at>
2013-11-05 22:33 ` Re: Connecting to Oracle from Postgresql 9.2 on Windows Christian Ullrich <chris@chrullrich.net>
@ 2013-11-06 08:42 ` Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 9+ messages in thread
From: Albe Laurenz @ 2013-11-06 08:42 UTC (permalink / raw)
To: Christian Ullrich *EXTERN* <chris@chrullrich.net>; pgsql-admin; +Cc: rgullstrom@gmail.com <rgullstrom@gmail.com>
Christian Ullrich wrote:
> * Albe Laurenz wrote:
>> It should work on 64-bit Windows, but I have no such machine to build it.
>> I'd be happy to publish binaries if somebody can build them.
>
> Every time I go up against what passes for a PostgreSQL build system on
> Windows, I am pleasantly surprised that it is not half as fragile as it
> looks.
>
> I now have working 64-bit builds of oracle_fdw.dll for both 9.2 and 9.3,
> built against the respective git branches. The only thing is, I'm not at
> all conversant with the build environment required for portable
> extension modules. I have been using Visual Studio 2012; do I have to
> build with 2008 to avoid runtime library clashes, or is that not an
> issue here?
I don't know enough about Windows to answer this, but I use
Microsoft Windows SDK for Windows 7 (7.1)
to build my binaries.
As far as I know, that is an outtake from Visual Studio, but
I don't know which version it corresponds to.
Do your DLL work with the PostgreSQL binaries that EnterpriseDB offers for
download? If yes, then I'd be interested in publishing them.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Connecting to Oracle from Postgresql 9.2 on Windows
@ 2013-11-02 00:59 Rune Gullstrom <rgullstrom@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Rune Gullstrom @ 2013-11-02 00:59 UTC (permalink / raw)
To: pgsql-admin
Thanks Raghu,
but that's from Oracle to Postgresql. I have no control over the oracle
db's, but I do have
read only credentials with which I would like to set up a view in my
Postgresql reading from
an Oracle db,
regards,
Rune
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2013-11-06 08:42 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-01 05:53 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
2013-11-01 06:15 ` Raghu Ram <raghuchennuru@gmail.com>
2013-11-02 06:32 ` Christian Ullrich <chris@chrullrich.net>
2013-11-03 22:56 ` Rune Gullstrom <rgullstrom@gmail.com>
2013-11-04 05:31 ` Christian Ullrich <chris@chrullrich.net>
2013-11-04 13:52 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-11-05 22:33 ` Christian Ullrich <chris@chrullrich.net>
2013-11-06 08:42 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-11-02 00:59 Connecting to Oracle from Postgresql 9.2 on Windows Rune Gullstrom <rgullstrom@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox