Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BDD8D9F9DB0 for ; Mon, 15 Oct 2007 12:42:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 44233-10 for ; Mon, 15 Oct 2007 12:42:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by postgresql.org (Postfix) with ESMTP id 8267E9F99CD for ; Mon, 15 Oct 2007 12:42:42 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so87407ana for ; Mon, 15 Oct 2007 08:42:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=+HOLR+9I/UAw3Qy/EANDWpiHDUexiT6zl44dBS4sNbw=; b=Wvekacd2YqzEM+7z7O7ZipaRBHS0q2UE4rTZyFhUEq1dMG+eTQYIdAvBrnKOtD7MY06S5XFpnMfGTxauFR6XDClhHSjeaHiyzlwD8Kvn7n8oUS3/oo5NqqO7ZZTHXkWayJCwy8xVTsMvQHjuApc/TAoDrSXxYNIQgd9KMzYscyE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nFXMkoP8s1CJrLmDLhUCabN1gjlCkLgBfrCIp5SpkcEkFbkBMuGhclB9w0d5m7jOSHaJ7cYdD2HRUdOj9x1ESasIA6x5kysAu/LGGGha6vxEryDAa5bFP2uiOaz07sJNnVBmTaSvXmBFw4pT2RDDziMSwNCYrLF8DyjYjKEgZbI= Received: by 10.143.17.13 with SMTP id u13mr1519494wfi.1192462960780; Mon, 15 Oct 2007 08:42:40 -0700 (PDT) Received: by 10.143.8.5 with HTTP; Mon, 15 Oct 2007 08:42:40 -0700 (PDT) Message-ID: <36e682920710150842n166107eeq445fb55294ef002@mail.gmail.com> Date: Mon, 15 Oct 2007 11:42:40 -0400 From: "Jonah H. Harris" To: "=?ISO-8859-1?Q?Martial_Elis=E9e_Wendb=E9_KIBA?=" Subject: Re: Distributed DataBases Cc: pgsql-admin@postgresql.org In-Reply-To: <93500.93219.qm@web25604.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <93500.93219.qm@web25604.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/122 X-Sequence-Number: 27036 On 10/14/07, Martial Elis=E9e Wendb=E9 KIBA wrote: > I have some questions about postgreSQL, concerning Distributed DataBases. > I know Oracle can do this very Well. With Oracle, i can configure my > dataBases to use data stored in another DataSource (Microsoft SQL Server, > Access, Access, ...), using Oracle Transparent Gateway. > What i want to know is There is a way to configure PostgreSQL to do the > same, or there is contrib/module that i can configure to do the same like > Oracle Transparent Gateway. See the projects: dblink (Postgres-to-Postgres in contrib) dblink_odbc (Postgres-to-ODBC on PgFoundry) dblink_tds (Postgres-to-Sybase/SQL Server on PgFoundry [has a memory leak]) dbi-link (Postgres-to-DBD in Perl) --=20 Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/