On Mon, 2010-11-08 at 21:12 +0000, [email protected] wrote: > Two points: > > 1. No backup tools for Postgres? pg_dump, pg_dumpall, log shipping and > lots of scripts and third-party utilities. Have *you* looked?
Yes, and they are not the same. How do you do a dump against a live db with active transactions? Is there any transaction cleanup, sweeps happening during backup? What about restoring that backup? http://www.destructor.de/firebird/gbak.htm http://www.firebirdsql.org/manual/gbak.htm http://www.firebirdsql.org/manual/nbackup-overview.html I have looked and researched database backup tools extensively and it blows me away still. How you can have an enterprise database without such tools as part of the RDBMS software. But seems there are several :) > 2. Yes, I have looked. No need for condescension. Well when you say documentation does not exist, yet it has for close to a decade now... ;) Like this outdated site I could not recall before, running like InterBase 4.0 or something. http://www.cvalde.net People get confused that in many senses like with past documentation Firebird == InterBase. So you might have been looking for Firebird specific documentation, and not finding any. Because its been covered already under InterBase documentation. Which there is countless amounts of stuff on InterBase on the net. > Yes, there is documentation for both, and we could split hairs of an > angel on a pinhead all day :) Sure and when I first started out with Firebird/InterBase, it was on a Cobalt that also had PostgreSQL. But Cobalt was promoting use of InterBase which had just become free. PostgreSQL is part of the Ingress family of databases. Since the mid-1980s, Ingres has spawned a number of commercial database applications, including Sybase, Microsoft SQL Server, NonStop SQL and a number of others. Postgres (Post Ingres), a project which started in the mid-1980s, later evolved into PostgreSQL http://en.wikipedia.org/wiki/Ingres_%28database%29 > , but IMO Postgres is more polished, more documented and has a bigger > breadth of material available. Those are pure opinions > It's also more prevalent with a bigger community, all of which > (should) matters a lot to someone learning SQL and databases. Again more opinions and speculations. Do not assume because Firebird is not big in FOSS its not big. Its been in use before there was a PostgreSQL. Keep that fact in mind. http://en.wikipedia.org/wiki/PostgreSQL#History http://en.wikipedia.org/wiki/InterBase#History The Blob and many other things that are common in all databases came from InterBases creators and history. Facts not opinions. Blobs were originally just amorphous chunks of data invented by Jim Starkey at DEC, http://en.wikipedia.org/wiki/Blob_%28computing%29 http://www.cvalde.net/misc/blob_true_history.htm Again Jim Starkey created Groton, later renamed InterBase, and now morphed into Firebird. Jim worked for MySQL, along with his wife Ann Harrison. http://en.wikipedia.org/wiki/Jim_Starkey -- William L. Thomson Jr. Obsidian-Studios, Inc. http://www.obsidian-studios.com This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. --------------------------------------------------------------------- Archive http://marc.info/?l=jaxlug-list&r=1&w=2 RSS Feed http://www.mail-archive.com/[email protected]/maillist.xml Unsubscribe [email protected]
