-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 19 February 2003 04:04, Johnny Stork wrote: > ONLY"....I am pretty frazzeled after almost 3 days of rebuilding my main > server and every little thing that didnt work as I expected right away, > just pissed me off even more thinking about how much more time I have lost > with my "other" stuff.
i know feeling and you have my complete sympathies... =/ > local all ident sameuser change this to password > host all 192.168.1.0 255.255.255.0 trust > > TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT > host all 192.168.0.0 255.255.0.0 password looks good, except the trust thing ;-) i don't even trust nobody (unix humour. ha ha. *sigh*) > And when I su to a regular user and try to run postgres command line, I get > a message about "postgres does not know where to find the database......." do you get: psql: FATAL 1: Database "username" does not exist in the system catalog. if so, that's because you need to either create a db for that user or do "psql <dbname>" other things to check: postgresql.conf... if tpip_socket isn't set to true, you will only be able to connect locally ... if your web admin stuff is attempting to connect via a TCP hostname (even localhost IIRC) it won't work unless you have tcpip_socket = true... - -- Aaron J. Seigo GPG Fingerprint: 8B8B 2209 0C6F 7C47 B1EA EE75 D6B7 2EB1 A7F1 DB43 KDE: The 'K' is for 'kick ass' http://www.kde.org http://promo.kde.org/3.1/feature_guide.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+VCB31rcusafx20MRAjwlAJ9ck+qt/kUKeXhcR7ZKOt2QRTA3HQCfeBFI cUt3YGVMWrHa5azgEwIGnTc= =TQBU -----END PGP SIGNATURE-----
