Skip site navigation (1) Skip section navigation (2)

Re: pgsql

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 (view raw or flat)
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."


In response to

  • pgsql at 2001-04-26 16:21:53 from Omar Sanchez - Informatica

pgsql-admin by date

Next:From: Christian MarschalekDate: 2001-04-27 15:22:47
Subject: ODBC connection to PostgreSQL
Previous:From: Tom LaneDate: 2001-04-27 12:41:02
Subject: Re: Restoring a pg_dump fails with

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group