And whilst I said I don't know anything about PostgreSQL (which I don't) I'd gather from what you've done that security isn't an issue!? It looks like it would allow anyone to connect. Is that what you intended? I guess if you have a password then there is at least some security, but not much! Unless you use a secure tunnel (eg SSH) then  all someone would need to do to hack in would be to listen in to your password being handed across (an unencrypted connection) then they would be able to log in themselves.

One other thing, the IP you are using (192.168.0.43) looks like a LAN IP. That's fine if the connection is only within your LAN (in which case security is much less of an issue too). But if you want to connect over the net you'd need to use the static WAN IP of where you are connecting from (if you have a dynamic IP you'd need to consider adding your ISPs IP range - still a little insecure but at least you could only get hacked by someone who is usng the same ISP - although obviously using an encrypted connection would mitigate that to a degree).

I guess bottom line is that it depends on your usage scenario and how important the data is to you. Personally I'd still want to at least encrypt the connection if its travelling over the net. If you can clarify a few more details, I'm happy to give you a vague idea of what you'll want/need to do to make it a little more secure (I don't know exactly what you'll need to do but i can give you some ideas on search terms etc).

PS thanks for posting back too :)

I assume you are using NoIP because you have a dynamic IP at home?

So where is the PostgreSQL appliance installed (locally or remotely)? Is is running on hardware or VM? Do you have a router that uses NAT or a direct connection? Where about is your VB6 app running from (locally or remote)? What OS is it running on? When you say your app runs over the net, do you mean it runs locally and needs to be accessed via the internet?