-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
log in as root and edit the file /var/lib/pgsql/data/postgresql.conf Right on the top there is a line #tcpip_socket=true make sure this line has no # in front (comment) and see that it has "true" as the value. Second check out pg_hba.conf At the end there are entries of who may access the database. Just to make it work (without security considerations) see that the two lines local all all trust host all all 127.0.0.1 255.255.255.255 trust are there and don't have a hash (#) in front. Restart postgresql (as root: /etc/init.d/postgresql restart) or just reboot the machine. If you still have problems connecting as postgres (no password) you might want to give the postgres account a password (Mandrake Controlcenter section users, or just start userdrake manually). Hope that helps. UC On Monday 25 October 2004 03:48 pm, Rick wrote: > i installed mandrake 10 on my pc, and i choose postgresql as db, i > installed it before in windows, but in linux i dont have idea what > happends, i remebered that i should create an user, but in linux the > process is auto and i when i try to connect by pgadmin i dont know user and > password =( > > i wrote in user postgre and trusted server but it says > > Error connecting to the server: could not connect to server: Connection > refused > Is the server running on host 127.0.0.1 and accepting > TCP/IP connections on port 5432? > > and the server is up, the service is running, who can help me please?? =( > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings - -- UC - -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFBfYf0jqGXBvRToM4RAuG1AJ9A5+l3CXcKmRUAuX9GQoYIWN9a8wCfcCEK wwVdZ7d8rxyBguZSmJY9S0g= =7v9S -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster