>> Hi, >> >> How I configure password to postgres user in Linux? >> I'm using trust, but I needing configure password in database. >> >> Thanks! >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match > >For database roles, you can change the password by ALTER ROLE command. >For example, change the pwd for user postgres to 123 : > >ALTER ROLE postgres PASSWORD '123'; Thanks, but I need configure password to connect to server! Now the pg_hba.conf is trust, I need change to passwd. Changing the file to passwd, I don't know how configure password to connect! Thanks! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
