Re: Remote login to the database

From: Jared Sulem <jsulem(at)sulem(dot)freeserve(dot)co(dot)uk>
To: PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Remote login to the database
Date: 2001-04-25 19:45:25
Message-ID: 3AE72955.3070402@sulem.freeserve.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

vijayendra mohan agrawal wrote:

> how do I connect to the database.

psql -h host [-p port] [-U username] database_name

OR

psql -h host [-p port] database_name username

psql --help for details of all the options.

One thing to remember - if you try to login from the database machine
and if you have restricted access to the database from localhost
(127.0.0.1) but not from the database machines network IP address, then
you must specify the host option with the local machines network IP address.

Jared

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message benoit.le-dizes@voila.fr 2001-04-25 21:21:27 Problem with postgres
Previous Message Tom Lane 2001-04-25 18:02:12 Re: Can't drop table (repost)