Thread

1. How to connect to a remote database

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-09-07T11:21:57Z

   Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 2
   The lower the number the more severe it is.
   
   Short Description
   How to connect to a remote database
   
   Long Description
   This may be a dumb question, but how do I connect to a remote database
   using postgresql, or rather psql?
   
   I have  trouble connecting to the remote host, to access the database what command should use to connect to the database in remote host in the prompt, Thanks again.
   
   Thanks
   
   Martin
   
   
   
   Sample Code
   
   
   No file was uploaded with this report
   
   
   

2. Re: How to connect to a remote database

   Jerome Alet <alet@unice.fr> — 2000-09-07T11:29:29Z

   Hi,
   
   this is probably not a bug.
   
   with psql you have to use the -h option
   
   e.g.: psql -h mypgserver.mydomain [mydatabase]
   
   and on mypgserver.mydomain computer you have to launch postgresql with 
   the -i option, telling it to listen for TCP/IP connections, and check
   pg_hba.conf for possible restricitions.
   
   bye,
   
   Jerome ALET - alet@unice.fr - http://cortex.unice.fr/~jerome
   Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 
   28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE
   
   On Thu, 7 Sep 2000 pgsql-bugs@postgresql.org wrote:
   
   > Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 2
   > The lower the number the more severe it is.
   > 
   > Short Description
   > How to connect to a remote database
   > 
   > Long Description
   > This may be a dumb question, but how do I connect to a remote database
   > using postgresql, or rather psql?
   > 
   > I have  trouble connecting to the remote host, to access the database what command should use to connect to the database in remote host in the prompt, Thanks again.
   > 
   > Thanks
   > 
   > Martin
   > 
   > 
   > 
   > Sample Code
   > 
   > 
   > No file was uploaded with this report
   > 
   
   
   

3. Re: How to connect to a remote database

   Vasileiadis Spyros <ace@northlink.gr> — 2000-09-07T11:55:26Z

   USE:
   psql -h <host> -p <port> -u <database>
   psql -h <host> -p <port> -U <username> -W <password> <database>
   
   read the man page
   
   SV
   
   ----- Original Message -----
   From: <pgsql-bugs@postgresql.org>
   To: <pgsql-bugs@postgresql.org>
   Sent: Thursday, September 07, 2000 2:21 PM
   Subject: [BUGS] How to connect to a remote database
   
   
   > Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 2
   > The lower the number the more severe it is.
   >
   > Short Description
   > How to connect to a remote database
   >
   > Long Description
   > This may be a dumb question, but how do I connect to a remote database
   > using postgresql, or rather psql?
   >
   > I have  trouble connecting to the remote host, to access the database what
   command should use to connect to the database in remote host in the prompt,
   Thanks again.
   >
   > Thanks
   >
   > Martin
   >
   >
   >
   > Sample Code
   >
   >
   > No file was uploaded with this report
   >
   
   
   

4. Re: How to connect to a remote database

   Sean Kelly <s.kelly@ncl.ac.uk> — 2000-09-07T12:28:09Z

   On Thu, 7 Sep 2000 07:21:57 -0400 (EDT), pgsql-bugs@postgresql.org
   said:
   
   > Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 2
   >  The lower the number the more severe it is.
   >  
   >  Short Description
   >  How to connect to a remote database
   >  
   >  Long Description
   >  This may be a dumb question, but how do I connect to a remote database
   >  using postgresql, or rather psql?
   
   	This isn't really a bug, is it? :)
   
   	"man psql" shows your options - you need "-h hostname_here". 
   See "man psql" for more.
   
   	You'll probably have to edit /path/to/pgsql/lib/pg_hba.conf
   on the remote machine to get permission.
   
   	Thanks,
   
   -- 
   Sean Kelly <S.Kelly@ncl.ac.uk>
   "The best way to predict the future is to invent it" - Alan Kay