Hi everyone
i am working on php and posgresql, i designed a database system web oriented
on windows at first on template1 default database. I used a password and a
loggin
loggin=postgres
password=13177337
this info is requested when installing postgresql on windows.
Know i trying to migrate to suse linux...i moved my scripts to
srv/www/htdocs/prototipo as root. I installed apache2 server, and i
configured both apache and posgtresql to start running when starting the
computer.
The problem is, i have not been able tu run properly the system on linux...i
receive the following message when conecting to postgresql:
"Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: la
autentificación Ident falló para el usuario «jufl» in
/srv/www/htdocs/Prototipo/opciones.php on line 51"
I didnt create any user when installing postgres, it didnt request during
installation...so i wonder....how can i manage this? the extrange thing is
that i can modify tables from console as follows;
...............................................................................................................................................................
su root
enter password
su postgres
psql prototipo
Bienvenido a psql 8.0.3, el terminal interactivo de PostgreSQL.
Digite: \copyright para ver los términos de distribución
\h para obtener ayuda sobre comandos SQL
\? para obtener ayuda sobre comandos internos
\g o punto y coma (;) para ejecutar consulta
\q para salir
prototipo=#
.....................................................................................................................................................................................
so i dont understand what the problem is.....
Thaks for your help...
---------------------------(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
