Re: postgresql installation
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tom Allison escreveu:
| OK, I'm just getting stuck on something regarding getting this
| postgresql started up.
|
| For starters, there's no way I seem able to make a localhost tcp_ip
| connection.
|
| postgresql.conf
| tcpip_socket = true
| port = 5432
|
| pg_hba.conf
| local all postgres ident sameuser
| local all all
| ident sameuser
| host all all 127.0.0.1 255.255.255.255 md5
| host all all ::1
| ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5
|
|
| I went into the template1 database and set my password for my username
| so that I could make connections from localhost. I'm not certain about
| this 'md5' thing. I set the password to match "foo" and not the md5_hex
| version of "foo". I'm assuming that this is not a problem... But maybe
| it's a bad assumption.
|
Don't know how you did that, but it is *not* what you should do.
| So... nothing really works. pgAccess doesn't work. and perl DBI
| doesn't work.
|
| it's got to be simple. But I don't know what it is and I'm reluctant to
| start tearing up all the configuration files thinking I actually know
| what I'm doing.
|
| help?
|
|
You can find the instructions here:
http://www.postgresql.org/docs/7.4/interactive/client-authentication.html
Anyway, if you are in a hurry, you can try to add this line in pg_hba.conf:
host all all 127.0.0.1 255.255.255.255 trust
this will allow all users on the localhost to connect to the database.
Carlos
- --
MEMÓRIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM: 967 511 762
e-mail: geral@m16e.com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e@amessage.de
Skype.com username (VoIP): m16e.com
GnuPG: wwwkeys.eu.pgp.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFD8vRP90uzwjA1SJURAkifAKCUcnz3oiEXfINUCqn4pDkR8fnETgCfapjS
bff1eqjQJKU9P76zftnu4F8=
=TWEf
-----END PGP SIGNATURE-----
Reply to: