How to find out superuser 'postgres' password. How to change the password
Thanks in advance
Bijoy
On Sat, Mar 28, 2009 at 10:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
bijoy <bijoy.franco@gmail.com> writes: > when i tried creating database using 'createdb', following error occuered. > createdb mydb > createdb: could not connect to database postgres: FATAL: Ident > authentication failed for user "root"
You didn't say whose packaging of Postgres this is, but it looks like you're using a setup that has ident authentication selected. That means the only user that can get in initially is user "postgres". (Well, actually, whatever the initial superuser is, but the odds are just about 100% that it's named "postgres".) Your first step should probably be to create a postgres account for your regular userid (not root), say via
su - postgres createuser joe
If you don't want authentication to work this way, you can change the setup in pg_hba.conf. See the manual under "Client Authentication". If you're the only person using the machine and you're unworried about someone cracking into it, you could just as well use "trust" mode and not bother with restrictions.
