Hi Leland, Thanks very much for your help. I'm going to experiment with an old PC but will definitely over-spec it! I'll go for 4Gb at first but make sure the CPU will support 16.
Thanks again. John Weller 01380 723235 07976 393631 > -----Original Message----- > From: profoxtech-boun...@leafe.com > [mailto:profoxtech-boun...@leafe.com] On Behalf Of Leland F. > Jackson, CPA > Sent: 17 November 2009 23:26 > To: profoxt...@leafe.com > Subject: Re: Advice > > Postgresql is a very efficient database and will run using > scant amounts of memory and cpu power in a satisfactory > manner with the right indexes. Postgresql was originally > developed for UNIX, and it will perform much better in a Mac, > Linux, or Unix environment than under windows. It has been > ported to window, but Postgresql's root are in UNIX. > > If the Postgresql database were running under a Mac, Linux, > or Unix environment, you could access it locally using a > socket connection from your windows computer. It can also be > accessed over TCP/IP remotely. Postgresql default > configuration after an install runs over a socket connection > as localhost, so you would need to change settings in the > postgresql.conf file to allow access remotely via > socket/tcp/ip or remotely using tcp/ip. > > Its been some time since I connected to Postgresql using VFP, > but I wrote a simple VFP application some years ago to do > inserts, deletes, updates, and select that worked very well > using Postgresql's ODBC driver to access the postgresql > database on a Linux server from windows XP Pro clients. The > Postgresql folks do a good job of keeping their ODBC drivers > fresh, so all you would need to do is find and install the > Postgresql ODBC driver on the windows clients, and you should > be good to go. > > If you decide to use the default configuration running > Postgresql under windows 7 as localhost, the critical path > for the system spec. would probably be satisfying window 7 > hunger for plenty of resources. LOL > > You could run Postgresql in Ubuntu Linux, for example, and > have your window 7 clients hosted in the Linux box by > Virtualbox, (eg virtualization), so that everything is on the > same computer. If I went this way, I would be sure the > motherboard and cpu supported the new virtualization features > offered in todays motherboards and cpus and had enough > memory. Also, I would over-spec then new computer; because, > after you have things up and running you are like to find new > was to use the computer and Postgresql. > > So far as memory is concerned, I would start with 4gb or > less, and add additional memory if needed, but I would be > sure the motherboard supported at least 16 gb of memory. > Its hard to come up with a minimum computer configuration to > run Postgresql; because, there are too many variables that > come into play. > > Regards, > > LelandJ > > > _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c302f3e66b4445309470185a5b4f2...@wessex1 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
