PostgreSQL 8.1.9 on Jupiter

[Ergo]

Also, will the upgrade to 8.2 be reflected in phpinfo and phpPgAdmin?

it will.

Would it be possible for you to set the default encoding to utf-8 or unicode when you upgrade postgres, please?

for language like mine utf-8 is a must ;-) should be default for all

I believe the default locale is C, which is ideal for me.

locales are for server messages iirc ? C is for "system settings right ?

[hal]

Hi Ergo

Here's some information about locales, which is interesting. Basically they provide locale-specific collation order, number formatting, translated messages, and other aspects. For an database-driven application to be portable, it is best to use the C locale, as it is always available regardless of platform, and is typically already set as the default at installation time.

http://www.postgresql.org/docs/8.2/i...e/charset.html
http://www.cs.utah.edu/dept/old/texi...library_7.html

Cheers
Hal

[Ergo]

Hi Eros

mauhahaahhahaa ! ;-)
i read a bit of that earlier , but since i develop apps and have little to do with systems administration im just concerned if DB is UTF most of time ;-)

[hal]

haha - sorry for the typo, Ergo! ;-)

Actually, the locale can affect DB indexing and ORDER BY commands, but I see your point.

[Dotable Steve]

I'm scheduling a php upgrade for next week, possibly early the week after. So I'm holding off upgrading postgresql until then foks, may as well kill all the birds with the 1 stone, as php needs to be recompiled for this postgres upgrade. Been doing some testing with php of late and come up against some segfault problems, so I need to find out whats causing that prior to the upgrade.

There will be an announcement made (24 hours at least) before that is done.

[hal]

I apologise for the delay, Steve; I thought I had answered this.
Your plans for the upgrade are absolutely fine with me, and I appreciate you doing it.
Just a reminder, would you mind sending me a list (privately) of any of my clients who have created a postgre DB or, even better, if there is a way I can do this via the WHM, I would be glad if you could help me with it.
Many thanks
Hal

[Ergo]

btw. postgresql 8.3 had been released a few days ago. And looking on comparison chart and its new features, this is the most incredible open source database system currently available. After some discussions with my fellow programmers we decided its probably the best thing after Oracle .

[hal]

Ergo, I agree, jumping straight to postgresql 8.3 would be ideal!
Like you say, it seems to have almost everything that a small to medium web-based app would need.
See the news release here http://www.postgresql.org/about/news.918

Is there any chance for you to upgrade to 8.3 instead of 8.2 Steve?

[Ergo]

well i think that according to this :
http://www.nabble.com/PostgreSQL-8.3...d15281830.html
they have centos rpms build, debian for example doesnt have it in stable repo.

I would risk saying that its suitable even for big apps - it has replication + i think it can handle 400gb databases without a problem :]

[hal]

Steve
Do you have have an idea when the Postgresql upgrade will happen?
Thanks
Hal