Whats missing from postgresql - PostgreSQL Database

Anthony_Barker

Aberdeen has a review of open source rdbms. The overall review was
quite positive but mentioned a few things missing.
Features desired according to users:
Gui control centre
Improved Replication
Two-phase commit
They list what they think is missing from postgresql compared with
Oracle/db2/MSSQL

PostgreSQL does not offer the following key features typically
provided in enterprise databases(accor ding to Aberdeen):
• Incremental and parallel backup/restore
• Encryption (security)
• Deadlock detection
• Row-level locking (typically required by large packaged
applications) —
although PostgreSQL does offer alternative sub-table locking schemes
• Bit-mapped indexing (for large data warehouses)
• A single GUI administrative interface
• View update/insert/delete
I was pretty sure that NETAPP offers incremental backup of Postgresql
- but perhaps I'm wrong.

What about the row level locking or the other features. Are they
issues for anyone?

http://www.sleepycat.com/aberdeenwp/

Anthony
http://xminc.com/mt/

Nov 23 '05 #1

Subscribe Reply

1964

Frank Finner

On 31 Mar 2004 17:00:52 -0800 an************@ hotmail.com (Anthony_Barker ) sat down, thought long and
then wrote:

PostgreSQL does not offer the following key features typically
provided in enterprise databases(accor ding to Aberdeen):
_ Incremental and parallel backup/restore
If you do several backup jobs for several databases on one engine at the same time, isn´t that
"parallel backup"? But incremental would be really a nice thing for big databases.
_ Encryption (security)
_ Deadlock detection
_ Row-level locking (typically required by large packaged
applications) _
although PostgreSQL does offer alternative sub-table locking schemes
_ Bit-mapped indexing (for large data warehouses)
_ A single GUI administrative interface
I would call PgAdmin such a thing.

_ View update/insert/delete
I was pretty sure that NETAPP offers incremental backup of Postgresql
- but perhaps I'm wrong.

What about the row level locking or the other features. Are they
issues for anyone?

http://www.sleepycat.com/aberdeenwp/

Anthony
http://xminc.com/mt/

What I am still _really_ missing is a simple reliable way for replication. I really would appreciate
a good eager master-master-replication for failover purposes (eg. Heartbeat). Although once an
Oracle consultant told me, that even for Oracle it is not simple and they do not recommend it. They
prefer "lazy" replication.

Regards, Frank.

---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #2

Similar topics

1763

Missing system views?

by: Bjorn T Johansen | last post by:

I am trying to check performance in out database but I seem to be missing something. I try to run : select relname, idx_tup_fetch + seq_tup_read as total from pg_stat_all_tables but all the tables have total = 0, shouldn't these be numbers > 0? And shouldn't there be views like pg_statio and pg_stat? (they do not exist in my database...)

PostgreSQL Database

1787

Whats missing from range of licenses?

by: Annette Massie | last post by:

I have a park permit tracking database where I was thinking of having the user enter all the park permits individually, however realized that in a day, a park could host many daily users. So if 100 daily permits were issued, the data entry would consist of 100 entries with only the permit number changing. If I changed the database to collect beginning and ending permit number would I be able to find the missing permit numbers? Say an...

Microsoft Access / VBA

1582

Whats the error:- System.NullReferenceException:

by: Patrick.O.Ige | last post by:

What could cause the error:- System.NullReferenceException: Object reference not set to an instance of an object. Any ideas?

ASP.NET

4485

Adding missing FROM clause - thanks or no thanks?

by: John Siracusa | last post by:

I recently had a problem where a bunch of postgres backends were taking up huge amounts of CPU time. I found a bunch of log messages like this: NOTICE: adding missing FROM-clause entry for table "b" Which I eventually tracked to an improperly constructed query that reduced to something like this: select a1, a2 FROM a WHERE a1 = '...' AND b.b1 = '...';

PostgreSQL Database

2035

Missing OID rant

by: John Sidney-Woollett | last post by:

<rant> Please can someone explain why Postgres cannot recognize that objects (referenced by pl/pgsql functions) whose OID no longer exists could in fact be found (as new objects) if the function was reparsed and compiled again. Here's an example: Create table t1 (f1 integer);

PostgreSQL Database

1465

How do I disable: Adding missing FROM-clause

by: terry | last post by:

I know that PSQL has the cool feature of doing: Adding missing FROM-clause But I want to disable it, because its silent adding can allow a bad SQL statement to execute a cartesian select (when in fact it should error out). I searched and found references to changing the postgresql.conf with: add_missing_from = false enable_implicited_join = false But neither one of these seems to disable the functionality (I did a reload after making...

PostgreSQL Database

1652

GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5

by: Greg Sabino Mullane | last post by:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for following PostgreSQL versions: 7.4.5 7.4.4 7.3.7

PostgreSQL Database

3272

pg_dump backup doesnt restore everything - things missing... restore howto required

by: glubber | last post by:

I have a cronned perl script that runs on a different server. when I try to restore it to the server below things dont copy across correctly. the target server is described below. debian 4.0 - Linux testbox.jumboentertainment.com.au 2.6.18-4-686 #1 SMP Mon Mar 26 17:17:36 UTC 2007 i686 GNU/Linux with the latest apt-get installation of postgres

PostgreSQL Database

3933

Whats wrong with this class template? (compilation errors)

by: (2b|!2b)==? | last post by:

template <typename T1, typename T2> struct MyDbInfo { MyDbInfo():m_pEnv(0), m_tran(0), m_db(0), m_idx(0) {} MyDbInfo(CDbEnv *env, DbTxn* tran, T1* db_ptr, T2 *idx_ptr):m_pEnv(env), m_tran(tran), m_db(db_ptr), m_idx(idx_ptr) {}

C / C++

8402

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8315

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8829

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8508

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8608

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7341

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4164

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4323

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2733

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp