postgresql 8.1 windows 2008 64 bit

2010/1/13 Daniel Schuchardt <d.schuchardt@prodat-sql.de>:

Hy,

can anybody give us a hint if we can use that combination?

first 64bit PostgreSQL on win will be 8.5

regards
Pavel

and besides, I think 8.1 is not supported on win32 anymore.

On 13/01/2010 6:15 PM, Daniel Schuchardt wrote:

Hy,

can anybody give us a hint if we can use that combination?

You can use libpq on 64-bit windows to talk to an 8.1 database if you
really must.

I really wouldn't recommend running the 8.1 database on windows. Win32
releases of Pg see big improvements with every version and 8.1 is really
not recommended or supported anymore. 8.1 was ... deficient ... on Windows.

Run a recent Pg server on 64-bit windows, or run your 8.1 server on a
UNIX machine and connect to it from 64-bit windows using a modern 64-bit
libpq.

Why 8.1, anyway?

--
Craig Ringer

8.1 version doesn't make any sense anyway, on any platform. There's
been so many improvements since, and if one wants to be conservative -
go for 8.3, which has tons of improvements over 8.1, especially in
area of performance.

Am 13.01.2010 16:00, schrieb Craig Ringer:

On 13/01/2010 6:15 PM, Daniel Schuchardt wrote:

Hy,

can anybody give us a hint if we can use that combination?

You can use libpq on 64-bit windows to talk to an 8.1 database if you
really must.

I really wouldn't recommend running the 8.1 database on windows. Win32
releases of Pg see big improvements with every version and 8.1 is
really not recommended or supported anymore. 8.1 was ... deficient ...
on Windows.

Run a recent Pg server on 64-bit windows, or run your 8.1 server on a
UNIX machine and connect to it from 64-bit windows using a modern
64-bit libpq.

Why 8.1, anyway?

--
Craig Ringer

we plan to upgrade to 8.4 the next time but currently everything is
build with 8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.

we did not upgrade because 81 has autocast and later version doesn't, so
we need to check all our statements and triggers/stored procedures wich
is currently in work.

--
Mit freundlichen Grï¿œssen,

Daniel Schuchardt
/Softwareentwicklung/

*CIMPCS GmbH
*Grï¿œnewaldstrasse 19
D-99099 Erfurt

Telefon Fax Mobil
0049 361 6534718 0049 361 6534717 0049 172 7766971

Firmensitz : Erfurt
Geschï¿œftsfï¿œhrer : Herbert Weber; Heinrich Kï¿œhni
Registriert : Amtsgericht Erfurt, HRB 501091
USt-IdNr : DE252754686

www.prodat-sql.de <http://www.prodat-sql.de&gt;

Daniel Schuchardt wrote:

can anybody give us a hint if we can use that combination?

PostgreSQL 8.1 for Windows became unsupported over two years ago due to
technical issues: http://www.postgresql.org/about/news.865
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

There were some major infrastructure changes in 8.3, including building
the software using Microsoft's compiler instead of ported UNIX tools,
that make it (or, even better, 8.4) a far better choice.

There is no specific 64-bit port of PostgreSQL yet, one is in progress
for the next version but it's still missing a few things:
http://blog.hagander.net/archives/160-64-bit-Windows-in-PostgreSQL.html

But you can run the regular 32-bit server just fine on the 64-bit
versions, albeit with some concerns about client apps:
http://blog.hagander.net/archives/73-PostgreSQL-vs-64-bit-windows.html

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com

In response to Daniel Schuchardt :

we plan to upgrade to 8.4 the next time but currently everything is build with
8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.

I'm not expect that 8.5 contains 64 bit for windows...

http://blog.hagander.net/archives/160-64-bit-Windows-in-PostgreSQL.html

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

we plan to upgrade to 8.4 the next time but currently everything is
build with 8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.

we did not upgrade because 81 has autocast and later version doesn't,
so we need to check all our statements and triggers/stored procedures
wich is currently in work.

PostgreSQL 8.3/8.4/8.5 will run just fine on 64bit Windows. Just
understand that PostgreSQL will be running in 32bit mode, which frankly
on windows is not a problem compared to other platforms.

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.

Ok, thats fine for us.

Most of our customers run Debian in 64Bit mode with Postgres 81 64 Bit,
but some won't use a *nix.

Thanks.

Am 13.01.2010 18:49, schrieb Joshua D. Drake:

we plan to upgrade to 8.4 the next time but currently everything is
build with 8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.

we did not upgrade because 81 has autocast and later version doesn't,
so we need to check all our statements and triggers/stored procedures
wich is currently in work.

PostgreSQL 8.3/8.4/8.5 will run just fine on 64bit Windows. Just
understand that PostgreSQL will be running in 32bit mode, which frankly
on windows is not a problem compared to other platforms.

Joshua D. Drake

--
Mit freundlichen Grüssen,

Daniel Schuchardt
/Softwareentwicklung/

*CIMPCS GmbH
*Grünewaldstrasse 19
D-99099 Erfurt

Telefon Fax Mobil
0049 361 6534718 0049 361 6534717 0049 172 7766971

Firmensitz : Erfurt
Geschäftsführer : Herbert Weber; Heinrich Kühni
Registriert : Amtsgericht Erfurt, HRB 501091
USt-IdNr : DE252754686

www.prodat-sql.de <http://www.prodat-sql.de&gt;