Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using libpq from within postgresql

Using libpq from within postgresql

From
PGSql User
Date:
Hi all,

Sorry if this question is a bit basic.  I want to be able to have different PGSql db's talking to each other.  So, one DB must act like a client, and be able to connect to another one.  Do you guys know if this is done before, and examples of that?
I'm having problems linking the src/interfaces directory with my src/backend directory.

Any help is appreciated!

Re: Using libpq from within postgresql

From
Mladen Gogala
Date:
PGSql User wrote:
> Hi all,
>
> Sorry if this question is a bit basic.  I want to be able to have
> different PGSql db's talking to each other.  So, one DB must act like
> a client, and be able to connect to another one.  Do you guys know if
> this is done before, and examples of that?
> I'm having problems linking the src/interfaces directory with my
> src/backend directory.
>
> Any help is appreciated!
DB doesn't "act". DB doesn't do anything, DB is a well organized data
store. Programs do things, they are the entities that "act".

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

Re: Using libpq from within postgresql

From
PGSql User
Date:
Ok, thanks.

What I meant was that I want to have one backed connect and execute queries on another backend.

On Tue, Jun 15, 2010 at 6:52 PM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
PGSql User wrote:
Hi all,

Sorry if this question is a bit basic.  I want to be able to have different PGSql db's talking to each other.  So, one DB must act like a client, and be able to connect to another one.  Do you guys know if this is done before, and examples of that?
I'm having problems linking the src/interfaces directory with my src/backend directory.

Any help is appreciated!
DB doesn't "act". DB doesn't do anything, DB is a well organized data store. Programs do things, they are the entities that "act".

--
Mladen Gogala Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

Re: Using libpq from within postgresql

From
Tom Lane
Date:
PGSql User <pgsqluser@gmail.com> writes:
> Sorry if this question is a bit basic.  I want to be able to have different
> PGSql db's talking to each other.  So, one DB must act like a client, and be
> able to connect to another one.  Do you guys know if this is done before,
> and examples of that?
> I'm having problems linking the src/interfaces directory with my src/backend
> directory.

Maybe contrib/dblink does what you want?

            regards, tom lane