| From: | Stefan Huber <schweinsaug(at)crosswinds(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pgsql |
| Date: | 2001-04-27 13:37:51 |
| Message-ID: | 5.1.0.14.0.20010427152247.00aeb698@pop.crosswinds.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
At 11:21 2001-04-26 -0500, Omar Sanchez - Informatica wrote:
>I installed linux redhat 6.2 for sun sparc 5. I am using postgresql,
>wish to know how do i connect 2 different data base over 2 different
>server.
Do you want to "merge" the two databases virtually, or do you simply want
to connect to a PostgreSQL database on a different server?
$ psql -h other.server.bogus -U username database
should do the second trick. I dopn't know, whether SQL Clauses over more
than one database are already working. I remember having seen them on the
TODO list :)
>I installed visual age 3.0 I wish to know why reason i can´t connect
>whit database of postgresql
Visual Age sounds like Windows...Have you installed the PostgreSQL ODBC
Driver and created a system DSN?
Stefan
--
Murphy's Laws: "If anything simply cannot go wrong, it will anyway."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Marschalek | 2001-04-27 15:22:47 | ODBC connection to PostgreSQL |
| Previous Message | Tom Lane | 2001-04-27 12:41:02 | Re: Restoring a pg_dump fails with |