Horton

Thread

  1. postmaster(server) and psql(client) question.

    Albert Chen <chen6178@hotmail.com> — 1999-05-07T23:18:06Z

    Hi,

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.

-Albert


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

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

    Sergei Chernev <ser@nsu.ru> — 1999-05-08T10:15:44Z

    Hi,
> 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.

You have to run postmaster with -i key, to allow tcp connections and
edit pg_hba.conf file to allow your client machine to connect (this file is
well commented).
On client machine, start psql -h server.name -u database
-----------------
Sergei Chernev
Internet: ser@nsu.ru
Phone: +7-3832-397354

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

    Simon Drabble <simond@foxlink.net> — 1999-05-08T14:54:39Z

    On Fri, 7 May 1999, Albert Chen wrote:

> Hi,
> 
> 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.
> 
> -Albert
> 
> 

psql -h <host> -p <port> <dbname or other commands>


Simon.


-- 
  "When a German dwarf dances with the butcher's son.." -- Tom Waits
   
   Simon Drabble                      Somewhere in cyberspace
   simond@foxlink.net

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

    Brett W. McCoy <bmccoy@lan2wan.com> — 1999-05-08T16:14:30Z

    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