[vwnc] Login to postgreSQL on Ubuntu system from windows

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[vwnc] Login to postgreSQL on Ubuntu system from windows

dtrussardi@tiscali.it
Hello All,
 
i have a server 'monviso' with Ubuntu 64bit OS where run postgreSQL "testdb" store database.
 
Now i have VW 7.5 image in the same system and i can connect to repository with:
 
  Interface :     PostfìgreSQLEXDIConnection
  Enviroment:  testdb
  Username:    guest
  Password:    dario
  Table owner : BERN
and all work fine.
 
But if in the enviroment define monviso:5432_testdb the vw erase the error:
 
Unable to connect to ' store database ' because of the following error:
 
    Peer communications error.
 
 
The same problem is on PC with Windows and VW7.4.1.
( This system work fine when login to cincom repository )
 
What i need to define for login to postgreSQL from Windows PC?
 
Any pointers would be greatly appreciated!

Thanks!

Dario

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: [vwnc] Login to postgreSQL on Ubuntu system from windows

Reinout Heeck
Dario Trussardi wrote:

>  
> Unable to connect to ' store database ' because of the following error:
>  
>     Peer communications error.
>  
>  
> The same problem is on PC with Windows and VW7.4.1.
> ( This system work fine when login to cincom repository )
>  
> What i need to define for login to postgreSQL from Windows PC?
>  
> Any pointers would be greatly appreciated!

Your database server is probably set up such that it only allows
connections from localhost.

You can alter these settings in your 'pg_hba.conf' file.

(Sorry that I cannot be more clear, I have no access to a running
postgresql setup from here - try Google).



R
-



_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: [vwnc] Login to postgreSQL on Ubuntu system from windows

Boris Popov, DeepCove Labs (SNN)
In reply to this post by dtrussardi@tiscali.it
Dario,

1. postgresql.conf

listen_addresses = '*'

2. pg_hba.conf

host  all  all  192.168.0.0/24  md5

You might need to put your own network mask in step two, hope this helps.

Cheers!

-Boris

--
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5
http://tinyurl.com/r7uw4

[hidden email]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that is
private and confidential. If you have received it in error, please
notify the sender and delete the entire message including any
attachments.

Thank you.

> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]] On Behalf
> Of Dario Trussardi
> Sent: Friday, April 18, 2008 8:07 AM
> To: [hidden email]
> Subject: [vwnc] Login to postgreSQL on Ubuntu system from windows
>
> Hello All,
>
> i have a server 'monviso' with Ubuntu 64bit OS where run postgreSQL
> "testdb" store database.
>
> Now i have VW 7.5 image in the same system and i can connect to repository
> with:
>
>   Interface :     PostfìgreSQLEXDIConnection
>   Enviroment:  testdb
>   Username:    guest
>   Password:    dario
>   Table owner : BERN
>
> and all work fine.
>
> But if in the enviroment define monviso:5432_testdb the vw erase the
> error:
>
> Unable to connect to ' store database ' because of the following error:
>
>     Peer communications error.
>
>
> The same problem is on PC with Windows and VW7.4.1.
> ( This system work fine when login to cincom repository )
>
> What i need to define for login to postgreSQL from Windows PC?
>
> Any pointers would be greatly appreciated!
>
> Thanks!
>
> Dario

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc