Re: Connecting to Postgres - Mailing list pgsql-general

From Martin Marques
Subject Re: Connecting to Postgres
Date
Msg-id 200312271636.21660.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Connecting to Postgres  (Nailah Ogeer <ogeer@cs.queensu.ca>)
List pgsql-general
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@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange permission problem regarding pg_settings
Next
From: Gianni Mariani
Date:
Subject: Re: Is my MySQL Gaining ?