PostgreSQL

[tomx313]

Anybody familiar with PostgreSQL?

I have installed it... everithing: apache, php, postgresql, phpPgAdmin... everithing works fine (i mean it just runs) the only problem is i can't log in postgresql...

is there a default user and password when you install it or something?

Itried almost everithing... benn googling for almost two hours...

oh I'm running Ubuntu 5.10

thanks for any help

[azcodemonkey]

  tomx313 said:

Anybody familiar with PostgreSQL?

I have installed it... everithing: apache, php, postgresql, phpPgAdmin... everithing works fine (i mean it just runs) the only problem is i can't log in postgresql...

is there a default user and password when you install it or something?

Itried almost everithing... benn googling for almost two hours...

oh I'm running Ubuntu 5.10

thanks for any help

Have you tried using postgre as your admin username?

[tomx313]

 
tomas@ubuntu:~$ psql -U postgre
psql: FATAL:  Ident authentication failed for user "postgre"
tomas@ubuntu:~$ psql -U postgres
psql: FATAL:  Ident authentication failed for user "postgres"
tomas@ubuntu:~$ psql
psql: FATAL:  database "tomas" does not exist
tomas@ubuntu:~$

you mean this? :whistle: