Re: [GENERAL] configure password
On 31 out, 07:33, [EMAIL PROTECTED] (João Paulo Zavanela) wrote: 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'; ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] configure password
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
Re: [GENERAL] configure password
On 10/31/07, João Paulo Zavanela [EMAIL PROTECTED] wrote: 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! First, connect with the pg_hba.conf set to trust. change the password. then change the pg_hba.conf to md5 / password. Note that if you're talking about a unix/linux type account that's a whole nother kettle of fish. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] configure password
João Paulo Zavanela [EMAIL PROTECTED] writes: 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! Set pg_hba.conf to 'trust', connect and use ALTER USER to set the password, then change pg_hba.conf to use 'md5' for your database. -Doug ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster