From: | Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | PostgreSQL Hackers <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Authentication Woes |
Date: | 1998-01-21 08:35:27 |
Message-ID: | Pine.SUN.3.91.980121093246.5322A-100000@dutepp0.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 20 Jan 1998, James Hughes wrote:
>
>
> On Tue, 20 Jan 1998, The Hermit Hacker wrote:
>
> >
> > v6.1.0 would have used TCP/IP for communications exclusively...
> > v6.3 moved to using Unix Domain Sockets as default, with TCP/IP disabled
> > by default. To "mirror" the old behavior, add the -i option to your
> > startup script and youshould be okay...
> >
> >
>
> OK, I should have said that the only way I can run psql is after making
> an entry in pg_hba.conf to enable passwords, starting the postmaster
> with the "-i" option then using the "-u" option with psql. The
> createuser and createdb scripts will not run regardless.
>
> Maybe I have other problems?? I am going to dig a little bit deeper :)
I have the same problem with 6.2.1. Authentication using passwords works,
but createuser (and probably the other scripts) fail. 'createuser -a
password' fails to use -u to actually ask for username/password. To
prevent having to type this 10 times during createuser, you could get it
from the script and then do 'echo "username\npassword" | psql ...'. I
tried this on another program (one of mine which uses the
prompt_for_password function from psql) and it works.
Maarten
_____________________________________________________________________________
| Maarten Boekhold, Faculty of Electrical Engineering TU Delft, NL |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas DBT | 1998-01-21 08:42:52 | Re: subselects |
Previous Message | Bruce Momjian | 1998-01-21 04:22:42 | Re: [HACKERS] Re: subselects |