Обсуждение: connect to another db

is there any possibility in plpgsql (or from the psql prompt) to retrive
data from any other PG database. if not is there a (recommended) work around
for this problem.

regards sepp

am  07.12.2005, um  8:18:45 +0000 mailte Robert Wimmer folgendes:
> is there any possibility in plpgsql (or from the psql prompt) to retrive
> data from any other PG database. if not is there a (recommended) work
> around for this problem.

You can use dblink (conntrib) or languages like plpgperl to connect to
multiple db.

http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/


A better way is to use only one DB and using schemas.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

hi,

a schema wouldnt help. i have to import data from a different PG db.dblink
would be the right choice, but i think i need a NIX OS to install it ? PG
runs on windows in the company I work for...

is the perl solution available on windows ? i think there is no plperl
installed on windows.

Postgres 8.0
Windows XP Professional

regards and thanks fo the prompt response

>From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
>To: pgsql-novice@postgresql.org
>Subject: Re: [NOVICE] connect to another db
>Date: Wed, 7 Dec 2005 09:51:46 +0100
>
>am  07.12.2005, um  8:18:45 +0000 mailte Robert Wimmer folgendes:
> > is there any possibility in plpgsql (or from the psql prompt) to retrive
> > data from any other PG database. if not is there a (recommended) work
> > around for this problem.
>
>You can use dblink (conntrib) or languages like plpgperl to connect to
>multiple db.
>
>http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/
>
>
>A better way is to use only one DB and using schemas.
>
>
>HTH, Andreas
>--
>Andreas Kretschmer    (Kontakt: siehe Header)
>Heynitz:  035242/47212,      D1: 0160/7141639
>GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>  ===    Schollglas Unternehmensgruppe    ===
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend

Robert Wimmer <seppwimmer@hotmail.com> schrieb:

> hi,
>
> a schema wouldnt help. i have to import data from a different PG db.dblink
> would be the right choice, but i think i need a NIX OS to install it ? PG
> runs on windows in the company I work for...

How often du you need this import? Is the different PG db on the same
machine?
At work i have also different PG db's on the same machine, and now i
know i need connections between tables on different db's. Now i have a
new server and i transform old db's to the new server to one db, but
different schemas. I think, this is a good solution.


>
> is the perl solution available on windows ? i think there is no plperl
> installed on windows.

I don't know, i hate windows and don't use this. But i think, plperl are
also available under this OS. But i'm not sure.


> >From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>

Please, no silly top-posting.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

> hi,
>
> a schema wouldnt help. i have to import data from a
> different PG db.dblink
> would be the right choice, but i think i need a NIX
> OS to install it ? PG
> runs on windows in the company I work for...

it sounds to me like you have the original data in one
database and that you are manually moving it to
another database at consistent time intervals.

is this right?

if so, consider the following questions:

1. why are two different machines absolutely
necessary?  if they aren't, use one machine.  try to
make sure the reason is technically valid and fight
against political reasons.
2. why are two databases necessary?  if not, use one
db.  if separation of data is technically required,
using different schema may be a solution.
3. if two machines and two dbs are necessary, can the
machines be networked?  if so, you may be able to
write an automation script that dumps from one
database and restores to the other database.

good luck.



__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com