Connecting to another Database

[ted creedon]

It should work fine with remote databases.
1. Check out Save As postgres:/localhost/foo
2. If that works, fire up a sniffer and see whats going on between hosts. If
it doesn't work with a local database, troubleshoot as required.
3. My gnucash asks me if I want to create a new database. Select yes.
(Haven't tried remote databases).
4. If I get time I'll check out the remote connection but its just a socket.
Gnucash shouldn't know or care where the physical database is.
5. Did you recompile using ./configure --enable-sql ...etc,etc?

tedc

-----Original Message-----
From: gnucash-user-bounces at gnucash.org
[mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Derek Atkins
Sent: Tuesday, March 08, 2005 8:29 AM
To: vincent at kenic.or.ke
Cc: GnuCash
Subject: Re: Connecting to another Database

It's certainly possible that the gnucash PG code does not handle remote
databases.  The code certainly is not well maintained at this point, and it
IS being redone for the next major release.

-derek

Vincent Ngundi <vincent at kenic.or.ke> writes:

> Hi All,
> I'm trying to save my GnuCash data on a remote server.
>
> If I save to the template1 database, it's OK but when I try to save to 
> another database that I have created, it gives me the following error:
>
> "FATAL:  No pg_hba.conf entry for host X.X.X.X, user vincent, database 
> 'the_data_base_I_created'
>
> FATAL:  No pg_hba.conf entry for host X.X.X.X, user vincent, database 
> template1"
>
>
> In the pg_hba.conf file I have:
>
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK	METHOD
> local   all         all
> host    all         all         127.0.0.1	255.255.255.255	trust
> host	all	    all	::1	ffff:ffff:ffff:ffff:ffff:ffff	trust
> host    all         all         X.X.X.X         255.255.255.255 trust
>
> Is there somewhere where you can specify or enable  the use of 
> multiple databases. It seems the default database is template1.
>
> Please help me out.
>
> Vincent.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user