Server to run Postgresql

On Sat, Nov 3, 2012 at 8:08 PM, Bob Pawley <rjpawley@shaw.ca> wrote:

Hi

I have an unused computer which I am considering turning into a server to
run my Postgresql database.

Is this even possible to do?

If so, can someone suggest an open source server that is relatively easy
to set up? Windows based would be ideal.

Bob

If by "Windows based" you mean "that has a graphical windowing system",
then any U*IX/Linux distribution applies.
For supported platforms, check:
http://www.postgresql.org/docs/9.2/static/supported-platforms.html

Or perhaps you might consider an all-in-one solution
(apache+php+postgresql+pgadmin) like the stacks by Bitnami:

http://bitnami.org/stack/wappstack [for MsWindows]
http://bitnami.org/stack/lappstack [for Linux]

which are self-contained and easy to install/uninstall at will.

Best regards,
Thalis K.

On 04/11/12 12:08, Bob Pawley wrote:

Hi
I have an unused computer which I am considering turning into a server
to run my Postgresql database.
Is this even possible to do?
If so, can someone suggest an open source server that is relatively
easy to set up? Windows based would be ideal.
Bob

If you are setting up a dedicated server for Postgres, then I recommend
using Linux based distribution, as Linux is more secure and generally
performs better than Microsoft O/S's (to be honest, I don't know
anything that runs better on a Microsoft O/S that also runs on Linux)-
note that Steve Balmer (currently Microsoft's CEO) already admitted over
a year ago that Linux now dominated the sever space. Especially as
Postgres will likely to perform better on a Linux box - and
professionally, it is becoming more and more advantageous to have Linux
experience on your CV.

Cheers,
Gavin

You can build PG based on the source code of the latest release. <br>Or you can install PG9.2.1 via the installer.&nbsp; All you need do is build it or download it and install.<br>See:<br>installer: http://www.enterprisedb.com/products-services-training/pgdownload#windows&lt;br&gt;sourcecode: http://www.postgresql.org/ftp/source/v9.2.1/&lt;br&gt;&lt;br&gt;As for the stability,&nbsp; it depends on the real environment.&nbsp;&nbsp; I believe PG can run well on windows environment. <br><br><div><div style="color:#909090;font-family:Arial Narrow;font-size:12px">------------------</div><div style="font-size:14px;font-family:Verdana;color:#000;"><div><div style="font-family: 'lucida Grande', Verdana; font-size: 12px; line-height: 18px; ">Thanks&amp;Regards,</div><div style="font-family: 'lucida Grande', Verdana; font-size: 12px; line-height: 18px; ">Xiong He<br><br></div></div></div></div><div>&nbsp;</div><div><includetail><div><br></div><div><br></div><div style="font-size: 12px;font-family: Arial Narrow;padding:2px 0 2px 0;">------------------&nbsp;Original&nbsp;------------------</div><div style="font-size: 12px;background:#efefef;padding:8px;"><div><b>From: </b>&nbsp;"Bob Pawley"&lt;rjpawley@shaw.ca&gt;;</div><div><b>Date: </b>&nbsp;Sun, Nov 4, 2012 07:08 AM</div><div><b>To: </b>&nbsp;"Postgresql"&lt;pgsql-general@postgresql.org&gt;; <wbr></div><div></div><div><b>Subject: </b>&nbsp;[GENERAL] Server to run Postgresql</div></div><div><br></div>

<div dir="ltr">
<div style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<div>Hi</div>
<div>&nbsp;</div>
<div>I have an unused computer which I am considering turning into a server to
run my Postgresql database.</div>
<div>&nbsp;</div>
<div>Is this even possible to do?</div>
<div>&nbsp;</div>
<div>If so, can someone suggest an open source server that is relatively easy to
set up? Windows based would be ideal.</div>
<div>&nbsp;</div>
<div>Bob</div>
<div>&nbsp;</div>
<div>&nbsp;</div></div></div></includetail></div>

On 03/11/2012 23:08, Bob Pawley wrote:

Hi

I have an unused computer which I am considering turning into a server
to run my Postgresql database.

Is this even possible to do?

Hi Bob,

Of course.

If so, can someone suggest an open source server that is relatively easy
to set up? Windows based would be ideal.

Is this for home use? - if so I'd go for Ubuntu or Linux Mint, which are
both very easy to set up and have comprehensive software repositories.
Linux Mint has a more traditional desktop interface; Ubuntu has its new
Unity interface which you may or may not like.

If you really want MS Windows and have a spare licence for it, there's
no problem installing PG on it with the EDB installer.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On Sun, Nov 4, 2012 at 9:37 AM, Raymond O'Donnell <rod@iol.ie> wrote:

On 03/11/2012 23:08, Bob Pawley wrote:

Hi

I have an unused computer which I am considering turning into a server
to run my Postgresql database.

Is this even possible to do?

Hi Bob,

Of course.

If so, can someone suggest an open source server that is relatively easy
to set up? Windows based would be ideal.

Is this for home use? - if so I'd go for Ubuntu or Linux Mint, which are
both very easy to set up and have comprehensive software repositories.
Linux Mint has a more traditional desktop interface; Ubuntu has its new
Unity interface which you may or may not like.

If you really want MS Windows and have a spare licence for it, there's
no problem installing PG on it with the EDB installer.

Also note that there are real connection and kernel limits on a
non-server version of Windows as well. While these won't likely show
up in home usage they're there.

For Ubuntu on an older machine, Xubuntu might be a better choice as
the GUI is much lighter weight. That said I recently installed Ubuntu
12.04 on a 512MB / Pentium D 32 bit machine from back in the day and
it works. Slower than my netbook, but it works.