From: | Peter Mount <pgsqladmin(at)retep(dot)org(dot)uk> |
---|---|
To: | choiceys(at)hanmail(dot)net |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: your mail |
Date: | 1998-05-17 15:34:11 |
Message-ID: | Pine.LNX.3.95.980517162942.9809A-100000@retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 1998-05-17 15:39:12 | Re: [ADMIN] PostgreSQL questions |
Previous Message | rjreilly | 1998-05-17 14:30:24 | Re: [ADMIN] PostgreSQL questions |