Re: Connecting to Postgres

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Connecting to Postgres
Date: 2003-12-27 19:36:21
Message-ID: 200312271636.21660.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

El Sáb 27 Dic 2003 16:08, Nailah Ogeer escribió:
> How do you connect to postgres if it is running on a different machine. I
> am looking for a telnet command in place of postmaster -D data

Depends on what you want to do.
One way arounf would be:

1) Edit the pg_hba.conf where the PG server is running so that you can
actually connect to the DB.
2) Run this:

$ psql -d database -h host -U user

where database, host and user are self explained. :-)

If what you want is something different please explain yourself.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Mariani 2003-12-27 20:26:57 Re: Is my MySQL Gaining ?
Previous Message Tom Lane 2003-12-27 19:10:26 Re: Strange permission problem regarding pg_settings

Browse pgsql-hackers by date

  From Date Subject
Next Message A E 2003-12-27 19:48:43 Error with returning SETOF Record
Previous Message Tom Lane 2003-12-27 19:10:26 Re: Strange permission problem regarding pg_settings

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-12-27 21:11:55 Re: update i386 spinlock for hyperthreading
Previous Message Nailah Ogeer 2003-12-27 19:08:16 Connecting to Postgres