[GNC] RES: SaveAS - postgres 14

[John Ralls]

The userid needs more than “normal access”. It needs “create” and “drop” for *all* entities, database on down, but the error message indicates that you’re not getting that far. Look in the database server logs for messages documented in https://www.postgresql.org/docs/14/client-authentication-problems.html to find out why.

Note that GnuCash supports only plaintext password authentication (https://www.postgresql.org/docs/14/auth-password.html) so make sure that your server is set up for that and that you’ve assigned a password to the user you’re logging in as.

BTW, your screenshot shows you trying to connect using the postgres userid. That’s the equivalent to signing in to a Unix computer as root: A bad idea.

Regards,
John Ralls


> On Mar 30, 2026, at 06:54, eduardo key matsudo <ematsudo at hotmail.com> wrote:
> 
> Agradeço pela gentileza na resposta, porém o acesso ao db é normal para este usuário e senha; inclusive realizei testes com um usuário temporário “sem senha” (trusted) e também não consegui gravar o arquivo.,
>  
> Esqjueci de mencional que ambas as instalações, GnuCach e Postgres, estão no ambiente Windows 11, home Edition
>  
>  
> Eduardo Key Matsudo
> (11) 96702-3407
>