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

-----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:
- --
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+l3CXcKmRUAuX9GQo YIWN9a8wCfcCEK
wwVdZ7d8rxyBguZSmJY9S0g=
=7v9S
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster