Thread: configure password
Hi, How I configure password to postgres user in Linux? I'm using trust, but I needing configure password in database. Thanks!
On 31 out, 07:33, joao_z...@globo.com (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';
>> 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!
João Paulo Zavanela <joao_zava@globo.com> 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
On 10/31/07, João Paulo Zavanela <joao_zava@globo.com> 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.