sources.redhat.com/rhdb/ PostgreSQL - Red Hat Edition Project
 PostgreSQL - Red Hat Edition
Project Home
More News
How-Tos and Whitepapers
FAQ
Utilities
Download
CVS / Contributing
Mailing Lists
Reporting Bugs (Bugzilla)
 Graphical Tools Suite
Administrator
Visual Explain
Control Center
 Latest Documentation
Current Version
Prior Versions
 PostgreSQL Community
PostgreSQL.org
CVS / Contributing
Mailing Lists
User Documentation
Technical Documentation
PostgreSQL To-Do List
 Related Links
Who are we?
sources.redhat.com
administrator
visual-explain
control-center

Frequently Asked Questions About
PostgreSQL - Red Hat Edition

General

1. What is PostgreSQL - Red Hat Edition?

2. What are the differences between PostgreSQL - Red Hat Edition and PostgreSQL?

3. What is the difference between PostgreSQL - Red Hat Edition and the PostgreSQL bundled with the Red Hat Linux distribution?

4. What's included in the PostgreSQL - Red Hat Edition 3.0 ISO image?

5. How do I obtain a copy of PostgreSQL - Red Hat Edition 3.0?

6. What operating systems does PostgreSQL - Red Hat Edition 3.0 install on?

7. What do I do if I'm getting a 'V3 DSA signature: NOKEY' warning?

Functionality

8. Is PostgreSQL - Red Hat Edition SQL92 compliant?

9. Does PostgreSQL - Red Hat Edition support ODBC and JDBC?

10. What other language interfaces are available?

11. Is there support for large objects in PostgreSQL - Red Hat Edition?

12. What backup and restore functionality is available?

13. Does PostgreSQL - Red Hat Edition have stored procedures?

14. Is there any limit on the maximum number of connections to a PostgreSQL - Red Hat Edition server?

15. Does PostgreSQL - Red Hat Edition have tablespaces?

16. Is PostgreSQL - Red Hat Edition multibyte enabled?

Graphical Tools

17. What GUI tools are included in PostgreSQL - Red Hat Edition?

18. Where can I get more information about the Graphical Tools?

19. Why do I keep getting notified about a lock file when starting Administrator or Visual Explain?

20. Why won't Visual Explain run?

21. Why, on a multiprocessor system, does Visual Explain hang? (IBM JRE Only)


If this FAQ did not answer your question, please try the PostgreSQL Community FAQ.
 



General


1. What is PostgreSQL - Red Hat Edition?
PostgreSQL - Red Hat Edition is an open source, object-relational database management system (ORDBMS). Tested and verified on Red Hat Linux, PostgreSQL - Red Hat Edition is a scalable, ACID-compliant data management solution for mid-sized businesses and enterprise workgroups.


2. What are the differences between PostgreSQL - Red Hat Edition and PostgreSQL?
PostgreSQL - Red Hat Edition is a database offering from Red Hat that is built on the community project PostgreSQL. PostgreSQL - Red Hat Edition includes a stable/enhanced/tested version of PostgreSQL, additional documentation, graphical installer, and the PostgreSQL - Red Hat Edition Graphical Tools (Administrator, Visual Explain and Control Center).


3. What is the difference between PostgreSQL - Red Hat Edition and the PostgreSQL bundled with the Red Hat Linux distribution?
PostgreSQL - Red Hat Edition is a stand-alone package as mentioned above, and is fully tested by Red Hat. The PostgreSQL that ships with Red Hat Linux is simply the current community release of PostgreSQL packaged for installation.


4. What's included in the PostgreSQL - Red Hat Edition 3.0 ISO image?
The PostgreSQL - Red Hat Edition 3.0 ISO contains an enhanced, tested and verified version of PostgreSQL 7.3.4, the PostgreSQL - Red Hat Edition Graphical Tools Suite, an installer and addition documentation.


5. How do I obtain a copy of PostgreSQL - Red Hat Edition 3.0
The PostgreSQL - Red Hat Edition ISO image is freely downloadable from the project download page.


6. What operating systems does PostgreSQL - Red Hat Edition 3.0 install on?
The PostgreSQL - Red Hat Edition Installer supports installation on Fedora and Red Hat Linux 9.


7. What do I do if I'm getting a 'V3 DSA signature: NOKEY' warning
The PostgreSQL - Red Hat Edition 3.0 ISO image comes with a Red Hat GPG key, RPM-GPG-KEY, in the top directory of the iso. You can import the key using:
rpm --import /mnt/cdrom/RPM-GPG-KEY
This will let you install the PostgreSQL - Red Hat Edition packages properly.


Functionality


8. Is PostgreSQL - Red Hat Edition SQL92 compliant?
While not yet fully SQL92 compliant, PostgreSQL - Red Hat Edition supports core SQL92 constructs.


9. Does PostgreSQL - Red Hat Edition support ODBC and JDBC?
Yes, PostgreSQL - Red Hat Edition ships with ODBC and JDBC drivers.


10. What other language interfaces are available?
Interfaces for C, C++, Perl DBI, PHP, Python, Tcl, Embedded SQL are available.


11. Is there support for large objects in PostgreSQL - Red Hat Edition?
Yes, PostgreSQL - Red Hat Edition has support for large objects. Both text and binary objects are supported.


12. What backup and restore functionality is available?
PostgreSQL - Red Hat Edition features online backup and restore of full and partial database images.


13. Does PostgreSQL - Red Hat Edition have stored procedures?
PostgreSQL - Red Hat Edition features server-side stored functions. These functions can be called from the client and they execute on the server.


14. Is there any limit on the maximum number of connections to a PostgreSQL - Red Hat Edition server?
There is no specific upper limit. There is a configuration parameter that limits the number of connections, but it can be set as high as available machine resources will support.


15. Does PostgreSQL - Red Hat Edition have tablespaces?
PostgreSQL - Red Hat Edition does not currently support tablespaces.


16. Is PostgreSQL - Red Hat Edition multibyte enabled?
Yes, PostgreSQL - Red Hat Edition features support for numerous multibyte character encodings, including Unicode.


Graphical Tools


17. What GUI tools are included in PostgreSQL - Red Hat Edition?
The PostgreSQL - Red Hat Edition Graphical Tools, Administrator and Visual Explain, are the first in a suite of graphical tools being developed by the project engineering team. The Graphical Tools source code is freely available on the RHDB 2.1 ISO image and from the cvs repository on this site.

Tools developed by the PostgreSQL community are also available. Visit the PostgreSQL community website for details.


18. Where can I get more information about the Graphical Tools?
The Graphical Tools Guide describes how to install and use Administrator, Visual Explain, and Control Center. HTML and PDF versions of this manual are also available in the PostgreSQL - Red Hat Edition 3.0 ISO image.


19. Why do I keep getting notified about a lock file when starting Administrator or Visual Explain?
The Graphical Tools are designed to run only as a single instance. The first instance creates a lock file that prevents other instances from saving configuration data. All other functions behave normally. Abnormal termination of the Graphical Tools may cause the lock file to remain after exit. The lock file may be deleted by hand in this case.


20. Why won't Visual Explain run?
Visual Explain requires a Java JRE and the PostgreSQL JDBC driver to be installed and available. The Installer does not check for the existence of a suitable JRE.


21. Why, on a multiprocessor system, does Visual Explain hang? (IBM JRE Only)
To run the IBM JRE on a multiprocessor system with Red Hat Linux, you first need to kill any Java processes currently running, then set the LD_ASSUME_KERNEL environment variable to 2.2.5
(for example, export LD_ASSUME_KERNEL=2.2.5).