Обсуждение: postgresql 8.1 windows 2008 64 bit

Hy,

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

Thanks,

Daniel.
--

Daniel Schuchardt
/Softwareentwicklung/

/http://www.prodat-sql.de/

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

> Thanks,
>
> Daniel.
> --
>
> Daniel Schuchardt
> /Softwareentwicklung/
>
> /http://www.prodat-sql.de/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

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.

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


 

> 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.