PostgreSQL Inc. Open Sources Replication Solution 383
Martin Marvinski writes "PostgreSQL Inc, the commercial company providing replication software and support for PostgreSQL, open sourced their eRServer replication product. This makes PostgreSQL one step closer to being able to replace Oracle as the de facto RDBMS standard. More information can be found on PostgreSQL's website."
Re:Excellent (Score:5, Informative)
PostgreSQL fanboy (Score:5, Informative)
plPHP (Score:5, Informative)
PostgreSQL has made some pretty nice advancements post version 7+, performance and feature wise. I worked on a intranet where the company spent lots of money trying to get an Oracle solution to work, but found it was way to slow. The suggestion of PostgreSQL, and MS SQL came up. We tested PostgreSQL, and it was acutually faster, and easier to maintain then our Oracle database. The best part was, it was free!
Re:Postgre sucks! (Score:5, Informative)
For how many server computers you want to order an evaluation copy, or 1-year licenses (390 euros or 450 US dollars each), or perpetual licenses (990 euros or 1150 US dollars each); discounts are available for large volume orders.
This is from http://www.innodb.com/hotbackup.html
Re:mySQL gets more publicity (Score:3, Informative)
+----------+
| count(*) |
+----------+
| 80081227 |
+----------+
No, it's not true. (This is just a quick example I pulled out, we have larger tables).
OOS vs. Oracle (Score:5, Informative)
Please! While this may help win the hearts and minds of OOS geeks, it does little to improve their standing in the business world.
Oracle is as established in the database world as Microsoft is on the desktop. This alone would doom any OOS wannabe to quiet places like web server back ends where they already do well anyway ( e.g. mySql ).
Put aside the technical considerations, support, client base, etc and PostgreSQL still offers as much of a threat to Oracle as mySql or dBase. The only real threat I've seen to Oracle supremacy is Microsoft's SQL Server but, of course, that's only in MS shops.
SAPDB relicenced to MySQL (Score:3, Informative)
This will probably mean that PostgreSQL will have a very hard time competing with MySQL ! (also see the info [sapdb.org] on the SAPDB webpage)
At the same time the licencing will change to pure GPL (no more LGPL libraries !!!)
Re:The defacto standard (Score:5, Informative)
No source code packages. You can't create a library, like you would in oracle.
When you have an sql error, it tells you the char it occured at, and not much more. Quite annoying if oyu miss a , in a multiline query and have to paste it back.
You can't network two instances so to speak. You can't say.. "select * from slashdot.messages, freshmeat.list where..." Bloody useful for running remote queries over a dedicated line, w/o dump-replicationg stuff.
Not easy to see, verbatim, what queries are running. Well, nothing i've seen so far.
But you know what, I use it, and I like it. 'cuz it doesn't require a java installer and it is simple. But it doesn't hold a light to oracle in some ways
Re:Good Thing(tm) (Score:5, Informative)
you can not pull the data out of table and stuff it into another table under even a reasonable workload.
but i understand this is slashdot and technical relevance need not necessarily apply.
Re:Good Thing(tm) (Score:3, Informative)
In my day job we use Oracle because
1.- Management is using the Powered by Oracle (or something like that) to sell the products to our clients
2.- Replication
But in my freelance company we use PostgreSQL exclusively and have experienced the burden of not having a reliable replication software. This is Good News for us small shops.
Re:mySQL gets more publicity (Score:4, Informative)
Version 4.0 of the MySQL server includes many enhancements and new features:
* The InnoDB table type is now included in the standard binaries, adding transactions, row-level locking, and foreign keys. See section 7.5 InnoDB Tables.
Re:IANADBA (Score:5, Informative)
But it is also true that wast majority of Oracle installations are poorely implemented (due to enourmous and unjustyfiable complexity), Oracle's management software sucked (getting better recently), support far from stellar (telephone support hardly usable), yearly costs are sky-high.
I started looking at PostgreSQL and the more I look the more I like what I see - it is conceptually simple, seems to have adequate performance with large tables, JDBC seems to work well too, stored procedures language is very close to Oracle's (I wish for better exceptions handling), and the whole thing is more than adequate replacement for 80% of Oracle installations I have personally seen.
And I have to add that I tried very hard to like MySQL but it did not work for me.
Everything above is IMHO and the usual disclaimers apply.
Re:Postgre sucks! (Score:2, Informative)
Have you actually used MySQL and tried to break it? The damn thing is hopeless in comparison to PostgreSQL, Oracle and even SQL Server:
InnoDB transactions don't include the DDL so your create table/index etc... WON'T roll back when you cancel a transaction - so really mysql transactions are for inserts, updates and deletes ONLY. Don't give me this crap about innodb being the be all and end all..
it will not perform validation checking on dates correctly, inserting 29/02/2003 works! It allows you to insert 00/00/0000 when that doesn't even EXIST!
it doesn't obey the datatypes you tell it to use and will happily insert 100.00 into a numeric(4,2) field but no -100.. why? cause the programmers use an extra bit for signing and instead you'll wind up with -99.99. This is correct (although your data is fucked) but whats with 100 being legal?? It will even allow you to insert a CHARACTER into a numeric field WITHOUT complaints - I want my database to tell me when something is wrong and enforce my business rules.
You should always try and build as much of your rules into the db app server - thats what it is - an application server, don't put all your logic in your client app. I'm not surprised that Slashdot is fine and all - all the logic is probably in the perl.
I'm sorry for the trollish tone but I could NEVER recommend someone use MySQL. Now MaxDB might be different and I'm all for it if it is but lets just hope it doesn't inherit to much from the MySQL codebase...
Re:Is this only a partial solution? (Score:3, Informative)
C-JDBC may take care of this [objectweb.org]
Re:mySQL gets more publicity (Score:3, Informative)
4 billion rows.
And yes, I've got other tables with more than 1 billion rows.
Re:The defacto standard (Score:5, Informative)
Try adding
stats_command_string = true to your postgresql.conf
then, "select * from pg_stat_activity" for a list of users pids and queries
-Mark
Re:Postgre sucks! (Score:2, Informative)
Allows to backup a running PostgreSQL database.
No locks.
Does not disturb normal database processing.
Consistent copy.
Free.
Re:PostgreSQL is a non-entity... (Score:2, Informative)
Re:WOOHOO!! (Score:3, Informative)
In addition, you can't really take it for a test drive, because it takes MONTHS to set up, even for small installations (it was a year process for a 300-employee company I used to work for, but we also had customizations as well).
Also, they never feel a need to actually ship a _working_ product. The version we used would not let you enter an order quantity over 9. 9??? Was this tested by ANYONE? I've heard worse stories from their salesforce management software. They basically ship code straight from the developers to the end-users, and allow YOU to test it. And, when you discover a bug, it may take several months for them to get around to a fix, even if you have it escalated to SEV-1 (okay, maybe SEV-1s are fixed within a few weeks, but still...).
And their consulting staff... Ahhh!! We were paying hundreds of dollars and hour for someone who had only used Oracle for 8 months! This was from Oracle headquarters. The guy had only done COBOL programming before, and had never clued into the concept of local variables. We had to recode everything he did.
And, on top of that, we paid a HUGE amount of money for this privilege.
It's not really the money that's the problem. It's that you might expect such service from a two-bit company that charged you $10/hour, but to be charged hundreds an hour for a totally crappy product, you just feel screwed in the end.
Re:The defacto standard (Score:3, Informative)
I'm not sure what you mean here. You can certainly create
The main feature I see missing from Postgres is tablespaces.
MySQL and PostgreSQL Compared (Score:2, Informative)
Re:Top Five Components (Score:1, Informative)
Point in Time Recovery
Two-Phased Commit
Win32
Nested Transactions
Re:IANADBA (Score:3, Informative)
We've recently sold appliances to some high volume customers and I must say that PostgreSQL has had no issues. It's fast for small, medium, and large installations serving up thousands to millions of documents.
We have our own system for redundancy since the database is only one piece, but we may switch over if their new offering turns out to be better for the database piece.
Re:PostgreSQL fanboy (Score:4, Informative)
So with some trepidation I used PostgreSQL instead. I was concerned with the setup time taking away from the time I learnt actual SQL but after a few hours of learning and tweaking I now have a spanking server running in RedHat and ODBC drivers so I can access it from Win32. I was thrown off to begin with because the 'postmaster' daemon was set to run without enabling TCP/IP support (-i option). But after I figured that out the rest was reasonably easy. I even installed a wonderful util called pgAdminIII which offers hierarchical configuration from a Windows box and was a doddle to use.
So now I have a nice DB that I can play with and pgAdmin has a nice user friendly GUI that I can type SQL in with.
What impressed me most was how *complete* support for SQL seemed to be. MySQL has a big list of gotchas but PostgreSQL seems to be aiming for completeness. This might not be everyone's cup of tea, especially if you want maximum speed but I appreciated the completeness - if something didn't work it was probably my fault! It also has a very complete and thorough manual which surprised me considering how shockingly awful most documentation is for open source.
Anyway, top marks to PostgreSQL. I have no idea if it sucks in a performance environment but it feels very slick to use on a casual basis. With what I know of it so far, I would be seriously consider using it instead of reaching for a commercial (and horribly expensive) option. I suspect for all but the most demanding applications, something like Oracle is just massive overkill.
Re:MS SQL Server - Re:The defacto standard (Score:3, Informative)
> low or mid range solution
Is it?
> it improves with each iteration.
As does Postgres.
> Our needs aren't high-end, but it handles
> our 300GB databases
That's a lot higher-end than where I'm at
Re:eRServer and PG Replicator (Score:3, Informative)
eRServer has fail over of the master to the primary slave, which makes it just fine for HA applications
Replication in postgres is still quite alive. The website is dead, but the mailing list and development is pretty active.
They were trying to get replication code into the main line 7.4, but that got pushed back. However people are still hgacking away at it.
Re:The defacto standard (Score:1, Informative)
No need to paste it back, if you're using psql. Just type \e right after you get the error and you're in $EDITOR looking at the query as entered. Make your tweaks to it, :wq, and it runs again automatically.
Re:plPHP (Score:1, Informative)
Re:Top Five Components (Score:3, Informative)
It already has them. You have to write the rule yourself, so it's not nearly as convenient as in Oracle, but it's possible. It's something like:
Now, I could see why you'd really want these to be automatic, as updating the definition of these rules manually is a maintenance headache. But you can do it.
Re:The myth of transactions (Score:3, Informative)
Re:The defacto standard (Score:2, Informative)
I'm not sure what this means. You can create everything from basic queries to languages that are used to implement stored procedures and ship them with your product.
When you have an sql error, it tells you the char it occured at, and not much more. Quite annoying if oyu miss a , in a multiline query and have to paste it back.
If you find this to be inappropriate, perhaps you should file a bug or offer a better error message handler. The source code is available, and they do amazing things with it.
You can't network two instances so to speak. You can't say.. "select * from slashdot.messages, freshmeat.list where..." Bloody useful for running remote queries over a dedicated line, w/o dump-replicationg stuff.
That sounds like dblink, which is included in the distribution (contrib).
Not easy to see, verbatim, what queries are running.
Check out all of the pg_stat views. In particular (slightly modified to avoid lameness filter):
cms_log=# select usename, current_query from pg_stat_activity;
usename | current_query
dustin | <IDLE>
cms13 | select count(*) from gateway_log;
cms37 | <IDLE>
Re:PostgreSQL fanboy (Score:3, Informative)
Did you try their web site? The little "Downloads" link on their main web page?
Seriously, both 8i and 9i are available as downloads, as long with a ton of other stuff. You'll want a fast link, 9i is a couple or 3 CDs. (I DL'd the developer version with a lot of extra stuff)
installation would be easy.
Well, that's a relative term. I had problems with 8i (because of my configuration) but 9i worked fine.
Oh, and that download link goes to here [oracle.com].
Re:The defacto standard (Score:5, Informative)
Oracle runs vacuum as well -- it just has a different name. It's what the undo / redo logs are for, to allow MVCC while maintaining an overwriting storage manager.
Re:But (Score:3, Informative)
believe cross transaction cursors is the most recent.
Re: Excellent... not quite... use FIREBIRD (Score:4, Informative)
Just to clear up any confusion:
Re: Excellent... not quite... use FIREBIRD (Score:2, Informative)
This is better than a lock, which another poster suggested, as a lock will block all writers, while a transaction need not block anybody.
Re:OraSlave (Score:2, Informative)
* RMAN/hot backup (yes)
* Log Miner (no)
* rollback (yes)
* PL/SQL (plPgSQL similar but not same)
* triggers (yes)
* archive log mode (no)
* duplex control, redo and archive log files (no)
* buffer cache (yes)
* row-level locking (yes)
* automatic undo management (more info?)
* constraints (yes)
* inline views, WHERE EXISTS, subqueries, et. al. (yes)
Re:OraSlave (Score:2, Informative)
Re:MS SQL Server - Re:The defacto standard (Score:3, Informative)
It's not as scalable as oracle or db/2 but at the same time it costs 15K per processor which is a hell of a lot of money.
I don't want to defend MS too much, but last month we bought Small Business Server [microsoft.com] for about $1500. That included Win2k Server, SQL Server 2000 and a lot of other things.