postgresql

[Paddy Walker]

Geert,?        You are correct in discovering my typographic error. It should 
be a colon not a semicolon.?        I am using Fedora 13 for this trial.?        
I can connect to postgresql using "psql gnucash" as yarelea (user).?        
Using the same user yarelea in a terminal I can start gnucash. Only one line 
in response "Found Finance::Quote version 1.17"?       When I attempt to "save 
as", I select postgresql from the dropdown box.?The next dialog requests my 
username & password. I do not understand what I ?should do about that. 
Provided the username has a role in Postgresql, surely ?that should be enough. 
I have not tried using gnucash as postgres.?The contents of the gnucash.trace 
file;?* * 14:19:53 DEBUG <gnc.backend.dbi> [enter gnc-backend-
dbi.c:gnc_dbi_postgres_session_begin()]  
* 14:19:53  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:  Ident authentication failed for user "yarelea"

* 14:19:53  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion `dbi_conn != NULL' failed
* 14:19:53  CRIT <gnc.backend.dbi>     [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
* 14:19:53 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]  
* 14:23:23 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_session_end()]  
* 14:23:23 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]  
* 14:25:18 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]  
* 14:25:18  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:  Ident authentication failed for user "0"

* 14:25:18  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion `dbi_conn != NULL' failed
* 14:25:18  CRIT <gnc.backend.dbi>     [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
* 14:25:18 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]  
This would appear to indicate that yarelea is not a role but why in that case 
can I access postgresql using the command line.
I may not be allowed to attach a file. If not I apologise.
Paddy 
-------------- next part --------------
* 14:19:53 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]  
* 14:19:53  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:  Ident authentication failed for user "yarelea"

* 14:19:53  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion `dbi_conn != NULL' failed
* 14:19:53  CRIT <gnc.backend.dbi>     [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
* 14:19:53 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]  
* 14:23:23 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_session_end()]  
* 14:23:23 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]  
* 14:25:18 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]  
* 14:25:18  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:  Ident authentication failed for user "0"

* 14:25:18  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion `dbi_conn != NULL' failed
* 14:25:18  CRIT <gnc.backend.dbi>     [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
* 14:25:18 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]