tag:blogger.com,1999:blog-3301074144512804889.post3937749352890541898..comments2022-08-01T02:59:54.491-07:00Comments on Database Technologies: PostgreSQL Database Link to Oracle Database on LinuxVibhor Kumarhttp://www.blogger.com/profile/12848190692973269508noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-3301074144512804889.post-9498168343466996352013-07-10T18:59:07.370-07:002013-07-10T18:59:07.370-07:00You can use Oracle Heterogeneous Database link fea...You can use Oracle Heterogeneous Database link feature to fetch the data of Postgres DB in Oracle.Vibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-88203918350547762092013-01-31T22:35:31.069-08:002013-01-31T22:35:31.069-08:00Hi Vibhor,
How can I fetch data into Oracle DB fr...Hi Vibhor,<br /><br />How can I fetch data into Oracle DB from Postgres DB?Akankshanoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-16464157659189338072012-08-11T08:45:14.823-07:002012-08-11T08:45:14.823-07:00Generally its in PostgreSQL Installation directory...Generally its in PostgreSQL Installation directory.<br />/binVibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-42541062280081538682012-08-11T08:43:42.366-07:002012-08-11T08:43:42.366-07:00Are you sure, you have compiled this module proper...Are you sure, you have compiled this module properly. If this kind of incompatibility is coming, then would recommend to contact Cybertech.Vibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-77847204815337549572012-08-11T08:41:48.868-07:002012-08-11T08:41:48.868-07:00I believe this module is not compatible with 8.1I believe this module is not compatible with 8.1Vibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-59595779224973240742012-08-11T08:40:13.463-07:002012-08-11T08:40:13.463-07:00Above error seems incompatibility with PG Version....Above error seems incompatibility with PG Version. What is version you are using?Vibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-84242536340595878822012-07-17T09:22:17.084-07:002012-07-17T09:22:17.084-07:00We are getting the error on PG 8.1
psql:odbclink....We are getting the error on PG 8.1<br /><br />psql:odbclink.sql:13: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:17: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:21: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:25: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:29: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:33: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:odbclink.sql:37: ERROR: could not load library "/usr/lib/pgsql/odbclink.so": /usr/lib/pgsql/odbclink.so: undefined symbol: TextDatumGetCString<br /><br />Any ideas please?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-71585170213827578082012-07-13T16:57:26.095-07:002012-07-13T16:57:26.095-07:00I have too a mistake
in ubuntu everything was esta...I have too a mistake<br />in ubuntu everything was established but in debian an error of TextDatumGetCString.<br />postgresql 8.3 version<br />and postgresql 8.4 versionAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-28920321424373289002012-07-03T22:33:53.122-07:002012-07-03T22:33:53.122-07:00Hi, What is the path we have to set pg_config bina...Hi, What is the path we have to set pg_config binary's path in PATH Environment VariableNaushadhttps://www.blogger.com/profile/01997550619476172697noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-29877057337158903022012-06-02T05:09:27.216-07:002012-06-02T05:09:27.216-07:00Nice post. I was checking continuously this blog a...Nice post. I was checking continuously this blog and I'm impressed! Very useful info specifically the last part :) I care for such information a lot. I was looking for this certain info for a very long time. Thank you and good luck.<br /><i>Feel free to surf my site</i> :: <b><a href="http://gldstock.org" rel="nofollow">view</a></b>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-25489398532621018302011-08-24T10:59:23.455-07:002011-08-24T10:59:23.455-07:00I have executed first few steps, but I am getting ...I have executed first few steps, but I am getting the error when I try to 'Execute following odbclink.sql file in PostgreSQL database to create require functions to access the Other Database'. I am getting the following error:<br />CREATE SCHEMA<br />CREATE TYPE<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:13: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:17: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:21: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:25: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:29: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:33: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:37: ERROR: could not load library "/usr/local/pgsql/lib/odbclink.so": /usr/local/pgsql/lib/odbclink.so: undefined symbol: TextDatumGetCString<br />GRANT<br />psql:/usr/local/pgsql/share/contrib/odbclink.sql:48: ERROR: function odbclink.connect(text, text, text) does not existAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-60751856794232320182011-07-06T08:08:46.985-07:002011-07-06T08:08:46.985-07:00You have to set pg_config location in PATH (env Va...You have to set pg_config location in PATH (env Variable) Before running "make USE_PGXS=1" as given below:<br />export PATH=:$PATH<br />make USE_PGXS=1Vibhor Kumarhttps://www.blogger.com/profile/12848190692973269508noreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-71104689040671203552011-07-04T14:24:27.768-07:002011-07-04T14:24:27.768-07:00Hi. I'm using Ubuntu 10.04 LTS and Postgresql ...Hi. I'm using Ubuntu 10.04 LTS and Postgresql 8.4.8. <br /><br />HELP!<br /><br />When I run the make command I get error:<br />postgres@dev-postgres-1:~/ODBC-Link-1.0.4$ make USE_PGXS=1<br />Makefile:12: /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory<br />make: *** No rule to make target `/usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk'. Stop.<br /><br />pg_config:<br />postgres@dev-postgres-1:~/ODBC-Link-1.0.4$ pg_config<br />BINDIR = /usr/lib/postgresql/8.4/bin<br />DOCDIR = /usr/share/doc/postgresql<br />HTMLDIR = /usr/share/doc/postgresql<br />INCLUDEDIR = /usr/include/postgresql<br />PKGINCLUDEDIR = /usr/include/postgresql<br />INCLUDEDIR-SERVER = /usr/include/postgresql/8.4/server<br />LIBDIR = /usr/lib<br />PKGLIBDIR = /usr/lib/postgresql/8.4/lib<br />LOCALEDIR = /usr/share/locale<br />MANDIR = /usr/share/postgresql/8.4/man<br />SHAREDIR = /usr/share/postgresql/8.4<br />SYSCONFDIR = /etc/postgresql-common<br />PGXS = /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk<br />CONFIGURE = '--build=i486-linux-gnu' '--prefix=/usr' '--includedir=/usr/include' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--libexecdir=/usr/lib/postgresql-8.4' '--disable-maintainer-mode' '--disable-dependency-tracking' '--disable-silent-rules' '--srcdir=.' '--mandir=/usr/share/postgresql/8.4/man' '--with-docdir=/usr/share/doc/postgresql-doc-8.4' '--sysconfdir=/etc/postgresql-common' '--datadir=/usr/share/postgresql/8.4' '--bindir=/usr/lib/postgresql/8.4/bin' '--includedir=/usr/include/postgresql/' '--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug' '--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld' '--with-tclconfig=/usr/lib/tcl8.5' '--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5' '--with-system-tzdata=/usr/share/zoneinfo' '--with-pgport=5432' 'CFLAGS=-g -O2 -g -Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,--as-needed' 'build_alias=i486-linux-gnu' 'CPPFLAGS='<br />CC = gcc<br />CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5<br />CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g<br />CFLAGS_SL = -fpic<br />LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed<br />LDFLAGS_SL =<br />LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm<br />VERSION = PostgreSQL 8.4.8JonathanSFLnoreply@blogger.comtag:blogger.com,1999:blog-3301074144512804889.post-25881451450597175642011-06-28T05:52:32.604-07:002011-06-28T05:52:32.604-07:00Thank you for this post - based on this I now have...Thank you for this post - based on this I now have a working connection between pg and oracle. I encountered couple of stumbling blocks on Ubuntu 10.04 on x86_64: <br /><br />* Make sure your version of unixodbc is at least 2.2.12, or you can encounter the error "undefined symbol: SQLGetPrivateProfileStringW" when connecting to oracle. The version in Ubuntu 10.04 was 2.2.11.<br /><br />* Even the most recent packages of unixodbc in Ubuntu, 2.2.14, have a bug which requires patching and recompiling. Otherwise all odbc-queries will return "ERROR: odbclink: unsuccessful SQLAllocStmt call". The needed change, as discussed on OTN: http://forums.oracle.com/forums/thread.jspa?threadID=340030&start=15&tstart=-1<br /><br />In the unixodbc sources for version 2.2.14, you need to change two places, lines 1827 and 1855 of DriverManager/SQLConnect.c:<br /><br /> old: SQLUSMALLINT supported;<br /> new: SQLUSMALLINT supported = SQL_TRUE;<br /><br />After recompiling and installing with the above change, and otherwise following along your post, I'm now at the point where I can "select * from dual" through odbc.Anonymousnoreply@blogger.com