Re: [GENERAL] postmaster(server) and psql(client) question.

From: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
To: Albert Chen <chen6178(at)hotmail(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] postmaster(server) and psql(client) question.
Date: 1999-05-08 16:14:30
Message-ID: Pine.LNX.4.04.9905081210070.17859-100000@dragosani.lan2wan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 7 May 1999, Albert Chen wrote:

> I have two machines; one is server, another is client.
> I run postmaster on server, could I run psql on client?
> If I can, would anyone tell me how to do, thanks.

If you are running the postmaster on the server this way:

postmaster -i

You can start up psql on a client machine like this:

psql -h <server hostname> <dbname>

However, you will need to edit your pg_hba.conf file under pgsql/data to
allow connections to your data from remote connections. There are
detailed instructions in the samples provided in the PostgreSQL
installation. You'll probably want to only allow certain clients to
connect, rather than just leaving it wide open to the world.

Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Prosperity makes friends, adversity tries them.
-- Publilius Syrus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Werachart Jantarataeme 1999-05-08 16:24:22 Function return tuples
Previous Message Simon Drabble 1999-05-08 14:54:39 Re: [GENERAL] postmaster(server) and psql(client) question.