Thread: ...

===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-admin@postgresql.org
===================================================================


Hello!

I'm a developer who is developing an Internet Search Engine.
Gladly, We've decided to use your product, PostgreSQL v.6.3.2.
But there are some problems to use it.
Please let me know the solutions.

First, We cannot connect the database from the other machine.
i.e, it is not permitted the remote access from other machine.

I read several documentions you provided, and followed the directions.
The directions are the following:

1. change the account into 'postgres'.
2. change the 'pg_hba.conf' file in the path /usr/local/pgsql/data.
    host    all    0.0.0.0        0.0.0.0        trust
    --> this means everyone can access every database from everywhere, right?
3. kill the postmaster and delete the '/tmp/.s.PGSQL.5432=' file
4. restart postmaster with -i -D$(PGDATA) options.

Are there any mistake? or something else?
We intalled postgreSQL in RedHat Linux 5.0.

We are pretty pleased and surprised at postgreSQL's performance.
You are the great team!! Thanks if answer me.

* please NOT EMAIL TO THIS EMAIL ADDRESS. We don't have POP3. :-)
Instead, email me to 'choiceys@hanmail.net'

On Sat, 16 May 1998, The Hermit Hacker wrote:

> I read several documentions you provided, and followed the directions.
> The directions are the following:
>
> 1. change the account into 'postgres'.
> 2. change the 'pg_hba.conf' file in the path /usr/local/pgsql/data.
>     host    all    0.0.0.0        0.0.0.0        trust
>     --> this means everyone can access every database from everywhere, right?
> 3. kill the postmaster and delete the '/tmp/.s.PGSQL.5432=' file
> 4. restart postmaster with -i -D$(PGDATA) options.
>
> Are there any mistake? or something else?

If you already have the postmaster running with -i then you don't have to
kill it for the changes to pg_hba.conf to take affect.

Also, I'd advise you tighten it up a little bit - giving everyone trust
permissions means they can log in as the DBA, and create their own
databases, users, etc.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk