Re: Sorry, I forgot put the exception in my message...

From: Tom Cook <tcook(at)lisa(dot)com(dot)au>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sorry, I forgot put the exception in my message...
Date: 2000-04-19 23:25:29
Message-ID: Pine.LNX.4.10.10004200851270.17022-100000@frog.adl.ardec.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Blakeley 2000-04-20 00:16:13 7.0RC1: possible query and backend problem
Previous Message Bruce Momjian 2000-04-19 22:35:00 PostgreSQL hats, shirts, keychains, mugs