Re: Remote login to the database - Mailing list pgsql-admin

From Jared Sulem
Subject Re: Remote login to the database
Date
Msg-id 3AE72955.3070402@sulem.freeserve.co.uk
Whole thread Raw
In response to Remote login to the database  ("vijayendra mohan agrawal" <vijayendra.agrawal@wipro.com>)
List 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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't drop table (repost)
Next
From: "benoit.le-dizes@voila.fr"
Date:
Subject: Problem with postgres