PostgreSQL 9.0 is here! The PostgreSQL Global Development Group announces the availability of our most eagerly awaited release. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers.
9.0 includes more major features than any release before it, including:
Hot standby
Streaming replication
In-place upgrades
64-bit Windows builds
Easy mass permissions management
Anonymous blocks and named parameter calls for stored procedures
New windowing functions and ordered aggregates
… and many more. For details on the over 200 additions and improvements in this version, developed by over a hundred contributors, please see the release notes.
"These kinds of feature additions continue to make a strong case for why mission-critical technology tasks can continue to depend on the power, flexibility and robustness of PostgreSQL,” said Afilias CTO Ram Mohan.
Actually, we can’t just dish aside MySQL. It seems that PostgreSQL’s replication does not allow for multiple slave servers yet. And this is probably a good thing. PostgreSQL is very conservative with its releases, and I am sure that they want to make sure that all of it works fine before releasing a version with additional replication capabilities.
Because PostgreSQL is very good about new realease (not bugs), I was thinking to go ahead and use this new release as the ‘server_repository.’ PostgreSQL experts: what do you think?
jcarlos:
Because PostgreSQL is very good about new realease (not bugs), I was thinking to go ahead and use this new release as the ‘server_repository.’ PostgreSQL experts: what do you think?
Like you said, PostgreSQL is very good about releases. They had a pretty good test period and even before any patches are even committed to the project they are being reviewed by multiple people (that is per patch!). And not only for code quality but also if such a patch (and how it’s implemented) should be in the project at all.
Like you said, they are pretty conservative. Get it done right or don’t do it at all.
So yes, using Pg 9.0 for your servoy repository is a pretty safe bet.
And by the way, now 9.0 is out the door version 7.4 and 8.0 of PostgreSQL will be End-Of-Life pretty soon. Which means that no more new security releases will be available for these versions.
Version 8.1, 8.2, 8.3, 8.4 and of course the new 9.0 will continue to be supported.
If you are still using one of these older releases (in any installation) I suggest you upgrade as soon as possible.
Although 9.0 now has an upgrade-in-place option let me tell you how keep your old environment and move all your data over to the new version.
First of all if you installed 8.4 using the one-click installer of EnterpriseDB then your data and binaries are located under /Library/PostgreSQL/8.4/ (Mac) or C:\Program Files\PostgreSQL\8.4\ (windows).
When you install PostgreSQL 9.0 using the EDB one-click installer then it will simply install it next to the 8.4 installation in your PostgreSQL directory (PostgreSQL/9.0/) and will use the port number 5433 since 5432 is used by your 8.4 install.
After closing the installer you have both 8.4 and 9.0 running in their own directories.
Open PgAdmin from your 9.0 install and connect to your 8.4 instance. After this right-click on the Server node and select “Backup Server”.
This will allow you to create one big SQL file of all objects in you database cluster.
After you have done this you connect to your 9.0 instance with PgAdmin, double click on the postgres database under the Databases node. So make sure the red X is from that Postgres node name and it’s selected. Now select from the Menubar > Plugins > PSQL Console.
This will launch the commandline tool psql and connect it to the postgres database. Now type the following:
\i /path/to/your/backupfile.sql
or in windows
\i C:\path\to\your\backupfile.sql
Hit enter and you will see how it recreates all your database objects. After it’s done you can exit psql using \q .
Now you can repoint your database connections in Servoy to your 9.0 instance (port 5433) and you are set.
If you want you could of course stop 8.4 and 9.0, change the port number in your 9.0 installation (postgresql.conf) to 5432 (default port) and launch only 9.0 so your current connection settings in Servoy will connect to 9.0.
You give me one question, I raise you two!
Faster than what ? Faster how ?
There are plenty of things better optimized in this version so I guess you can say 9.0 is faster than 8.4. Just read the release notes if you want to know the specific areas things are faster.
jcompagner:
P.S. its a pity that you just cant copy from one db to the other in PgAdmin in one command! (backup database to database) ;(
Well yes you can, just select the database as template when you create a new database. It will copy the whole database (including data, functions, etc) into the newly created database inside your database cluster.
But I think you meant between database clusters…right ? Then no you can’t. Just backup (dump) the database (right-click on database node) and restore in other Pg instance.
jcarlos:
Actually, we can’t just dish aside MySQL. It seems that PostgreSQL’s replication does not allow for multiple slave servers yet. And this is probably a good thing. PostgreSQL is very conservative with its releases, and I am sure that they want to make sure that all of it works fine before releasing a version with additional replication capabilities.
Actually, that’s incorrect. You can have as many hot standby servers as you want. In fact, one of the benefits of the new binary replication is its extremely low overhead on the master, allowing you to support large numbers of standbys. The one caveat is that standby promotion is currently somewhat hackish.
What we’re working on for 8.1, in addition to better administration for HS/SR, is synchronous standby.
jcarlos:
Because PostgreSQL is very good about new realease (not bugs), I was thinking to go ahead and use this new release as the ‘server_repository.’ PostgreSQL experts: what do you think?
[/quote]
Especially now that 9.0.1 is out, go ahead. I beleive the next major release of Servoy will be based on Postgres 9, anyway.
I have now upgraded from PSQL 8.4.4 to 9.0.1… not without any trouble and small problems…, but with help (especially from Robert I., Mr. PSQL) and success at the end.
The backup of the databases of PSQL 8.4 and restore in 9.0.1 was easy and is working well. Also all my indices are still existing…, so I could save time I lost in troubleshooting. I have learned a lot and next I will first take a look into the Servoy forum topics for the really great hints to do things we have to do .
Finally I can say for me PSQL 9.0.1 is the better SQL server. My problems in password issues on Mac Servers are gone and I could make the experience for a better performance as on vers. 8.4.4. (Performance Data on servoy-admin are much better) without any change e.g. on indices.