I think if you have existing application with older version then i suggest
you edit GROUP BY statements..
somehow group by statement doesn't work like it did in older version in new
version.. i don't know why but when i use group by statement it returns
different result in old and new version...
well I have no idea why...
;)
-----Original Message-----
From: Tom Lane <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, August 18, 1999 10:18 AM
Subject: [ADMIN] Re: (no subject)
>munyh <[EMAIL PROTECTED]> writes:
>> Hello, I'm a korean who has used "Postgres 6.0" in UNIX.
>> Yesterday, I download "Postgres 6.5.1".
>> May I ask you someting?
>
>> 1.Let me know how to install it without removing or breaking the old
>> data(Postgres 6.0).
>
>You can either leave the old server alone (cf. your point 4) or do a
>pg_dump and then reload the data into 6.5. (Did 6.0 have a pg_dump?
>That was way before my time...)
>
>> 3.If exchange a new one, Should I re-compile or fix all programs which
>> used the old?
>
>You should recompile, I think. The current server might still accept
>connections from client libraries that old, but 6.0 is a long time and
>a lot of bug fixes ago.
>
>> 4. Can two daemons -that are Postgres6.0 and 6.5.1 in my same UNIX -
>> rule well concurrently?
>
>Sure, if you give them separate installation/database directories and
>separate connection port addresses. Assuming you want to leave the
>old one where it is, just make sure you specify non-default settings
>for --with-pgport and --prefix while configuring the new code.
>
> regards, tom lane
************
