Re: Sorry, I forgot put the exception in my message... - Mailing list pgsql-general

From Tom Cook
Subject Re: Sorry, I forgot put the exception in my message...
Date
Msg-id Pine.LNX.4.10.10004200851270.17022-100000@frog.adl.ardec.com.au
Whole thread Raw
In response to Sorry, I forgot put the exception in my message...  (Javier Benito <franciscojavier.benito@innosec.es>)
List pgsql-general
On Wed, 19 Apr 2000, Javier Benito wrote:

> I've checked that postmaster is running in Solaris 5.6 with -i option. I
> think the problem may be that i'm not defining users, but in the
> pg_hba.conf file the defaults are that anyone in anywhere can connects
> to any database.
> What can i do?

After some playing around, it seems to me that you do need to connect as
some user. Creating a user is not a strenuous process if you're a DBA; if
not, you need to discover a correct username and password. I can't connect
via _any_ method without a username and password ('psql -u db_name' says
'No postgres username specified in startup packet.' if I don't give it a
username). So I'd try this.

Cheers
--
Tom Cook - Software Engineer

"Christ died for sin, the righteous for the unrighteous, to bring you to God."
    - 1 Peter 3:18

LISAcorp - www.lisa.com.au

--------------------------------------------------
38 Greenhill Rd.          Level 3, 228 Pitt Street
Wayville, SA, 5034        Sydney, NSW, 2000

Phone:   +61 8 8272 1555  Phone:   +61 2 9283 0877
Fax:     +61 8 8271 1199  Fax:     +61 2 9283 0866
--------------------------------------------------


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: PostgreSQL hats, shirts, keychains, mugs
Next
From: Michael Blakeley
Date:
Subject: 7.0RC1: possible query and backend problem