Connecting GNUCash to a Remote Postgres Database under Windows 7

[Klaus Dahlke]

Hi David
here is the link to the manual

http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
 
Cheers,
Klaus

On Wed, 14 Nov 2012 11:01:42 +0800
David Vitali <vitalida at msn.com> wrote:

> Hello Klaus,
> 
> I've had a look at the pg_hba.conf file. I'm not sure what I need to add to
> it and where. My PostgreSQL configuration is as follows:
> 
> Server:
> 
> Sever: PostgreSQL 9.2
> Host: localhost
> Database: gnucash
> Windows name: DAVID-PC-PHEN2
> 
> Remote:
> 
> Windows name: DAVID-LT-I7
> 
> Can you please help me, by letting me know what I need to add to the file
> such that GNUCash running on DAVID-LT-I7 can access the GNUCash database on
> DAVID-PC-PHEN2?
> 
> Thank you very much for your help,
> 
> David. 14th November 2012.
> 
> -----Original Message-----
> From: Klaus Dahlke [mailto:klaus.dahlke at gmx.de] 
> Sent: Wednesday, 14 November 2012 3:23 AM
> To: vitalida at msn.com
> Cc: gnucash-user at gnucash.org
> Subject: Re: Connecting GNUCash to a Remote Postgres Database under Windows
> 7
> 
> On Tue, 13 Nov 2012 11:11:08 +0800
> David Vitali <vitalida at msn.com> wrote:
> 
> > Good day,
> > 
> >  
> > 
> > I've searched the online documentation for an answer to this question, 
> > but couldn't find suitable help. If you could please assist it would 
> > be most appreciated. The problem is fairly urgent as our accounting 
> > system has been down ever since I migrated the postGres server and 
> > GNUCash database from one of the workstations to the main server.
> > 
> >  
> > 
> 
> > 
> > (ii) Status: unable to connect to remote database 'gnucash' on
> > DAVID-PC-PHEN2
> > 
> >  
> > 
> 
> Hi David,
> did verify the settings of teh postgres server so that the server allows
> connections other than localhost? See pg_hba.conf.
> 
> Cheers,
> Klaus 
>