On Wed, Nov 07, 2001 at 04:52:19PM -0600, Brady Hegberg wrote:
> I think mySQL is somewhat easier to setup and use at first but then this
> is based on the fact that I installed postgresql last week and I still
> haven't figured out how to log into it.

PostgreSQL crash course:

$ su -
# su - postgres
$ createuser <foo> -P
enter password
$ createdb <baz>
$ logout
<muck with /var/lib/postgres/data/pg_hba.conf to allow encrypted logins *>
# logout
$ psql -u foo -P baz
....

florin

(*) like this, for instance: 
#local        all                                           peer sameuser
#host         all         127.0.0.1     255.0.0.0           ident sameuser
host         all         10.0.0.0      255.255.255.0       crypt

-- 

"If it's not broken, let's fix it till it is."

41A9 2BDE 8E11 F1C5 87A6  03EE 34B3 E075 3B90 DFE4
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 230 bytes
Desc: not available
Url : http://shadowknight.real-time.com/pipermail/tclug-list/attachments/20011107/34b55faa/attachment.pgp