postgresql 8 - hiqavediwi’s diary

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =========> Download Link postgresql 8 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

E.1. Release 8.0.26. Release date: 2010-10-04. This release contains a variety of fixes from 8.0.25. For information about new features in the 8.0 major release, see Section E.27. This is expected to be the last PostgreSQL release in the 8.0.X series. Users are encouraged to update to a newer release branch soon. Table of Contents; Preface · What is PostgreSQL? A Brief History of PostgreSQL · Conventions · Further Information · Bug Reporting Guidelines. I. Tutorial. 1. Getting Started; 2. The SQL Language; 3. Advanced Features. II. The SQL Language. 4. SQL Syntax; 5. Data Definition; 6. Data Manipulation; 7. Queries; 8. Data Types. Downloads. PostgreSQL Core Distribution. The core of the PostgreSQL object-relational database management system is available in several source and binary formats. Over the past several weeks, Tom Lane has been working on replacing our old Cache Management Alorithm (ARC) with a new, patent free one (2Q). In order to reduce the number of 8.x deployments out there that are using the old manager, we have just released 8.0.2, and encourage adminstrators to. After more than a year of hard work, the PostgreSQL Global Development Group proudly announces the release of version 8.0.0 of the PostgreSQL ORDBMS. This release involves possibly more major changes than any prior version of PostgreSQL since 6.3, including: Native Windows port. This chapter describes the installation of PostgreSQL from the source code distribution. (If you are installing a pre-packaged distribution, such as an RPM or Debian package, ignore this chapter and read the packager's instructions instead.) 14.1. Short Version ./configure gmake su gmake install adduser postgres mkdir. Description. VACUUM reclaims storage occupied by deleted tuples. In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it's necessary to do VACUUM periodically, especially on. Conversions can be defined by CREATE CONVERSION. Also there are some pre-defined conversion names. See Table 9-7 for available conversion names. convert('PostgreSQL' using iso_8859_1_to_utf_8), 'PostgreSQL' in Unicode (UTF-8) encoding. lower (string), text, Convert string to lower case, lower('TOM'), tom. Many informal performance studies of PostgreSQL have been done. Performance improvements aimed at improving scalability started heavily with version 8.1. Simple benchmarks between version 8.0 and version 8.4 showed that the latter was more than 10 times faster on read-only. Since version 8.0, PostgreSQL offers an installer for Windows systems that makes the installation process easier and faster. For development purpose, we will install PostgreSQL version 9.5 on Windows 10. NOTE: If you are running the Windows 8 and 10, you need to create a Windows users with administrator role e.g.,. It moves a bit more slowly than other "distros," but its stability and quality is well recognized. If your application or service needs a database, the combination of Debian 8 and PostgreSQL is one of the best in town. In this article we will show you how to install PostgreSQL on a new Debian 8 Stable instance. But what about generating breadcrumbs based on data stored within a database? For example, consider the following URL: http://www.example.com/books/1590595475/ How would you go about translating this URL into the following breadcrumb trail? Home > Books > Beginning PHP 5 and PostgreSQL 8 At first glance,. When creating a new database (e.g. with createdb blog ) PostgreSQL actually copies a template database. There are two predefined templates: template0 is vanilla, while template1 is meant as an on-site template changeable by the administrator and is. openCRX Installation Guide for PostgreSQL 8. Version 2.5.2. logo_openCRX www.opencrx.org. Table of Contents. 1 About this Book 4. 1.1 Who this book is for 4. 1.2 What do you need to understand this book 4. 1.3 Tips, Warnings, etc. 4. 2 Prerequisites 5. 3 Issue(s) specific to PostgreSQL 6. 3.1 Puzzling behavior of. I'd suggest you not to use an old version like that, but I understand develop circumstances. Digging deeper, I found that only version from 8.2 where official for windows. Probably there was a notice in download page, now you find only post about it like: http://www.postgresql.org/message-id/200909150821. PostgreSQL 8 for Windows (Database Professional's Library) [Richard Blum] on Amazon.com. *FREE* shipping on qualifying offers. The easiest way to set up a PostgreSQL database server on Windows Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples. PostgreSQL, often simply "Postgres", is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. As a database server,.. FROM postgres:9.4 RUN localedef -i de_DE -c -f UTF-8 -A /usr/share/locale/locale.alias de_DE.UTF-8 ENV LANG de_DE.utf8. The directory context for PostgreSQL scripts is found in the install-dir\DirXMLUtilities\jdbc\sql\postgres\install directory on Windows or install-dir/lib/dirxml/rules/jdbc/sql/postgres/install directory on UNIX/Linux platforms. The directory context for executing Postgres commands is postgres-install-dir/pgsql/bin. Create the idm. This is quick guide howto install PostgreSQL 8.4 (current stable 8.4.7) database server on CentOS, Fedora and Red Hat. Fedora 14, Fedora 13, CentOS 5.5 and Red Hat (RHEL) 5.5 has PostgreSQL 8.4 database server as default so extra repositories is not needed. Personally, I like to use Postgres own. Installers are available for PostGIS 2.1.8 for PostgreSQL 9.2 (64-bit), PostgreSQL 9.4 (32/64-bit) (via Application stackbuilder) and windows download. NOTE: the PostgreSQL 9.2 PostGIS 2.1.8 installers and binaries require PostgreSQL 9.2.9 or above. If you had done a micro upgrade from a pre-PostgreSQL 9.2.9 and your. UTF-8'. (Debian/Ubuntu only) Used to generate the locales used by PostgreSQL databases. postgresql_databases: - name: exampledb # required; the rest are optional lc_collate: # defaults to 'en_US.UTF-8' lc_ctype: # defaults to 'en_US.UTF-8' encoding: # defaults to 'UTF-8' template: # defaults to 'template0' login_host:. Resolves: #561010 * Mon May 17 2010 Tom Lane 8.4.4-1 - Update to PostgreSQL 8.4.4, for various fixes described at http://www.postgresql.org/docs/8.4/static/release-8-4-4.html including fixes for CVE-2010-1169 and CVE-2010-1170 Resolves: #593033 * Mon Mar 15 2010 Tom Lane. 1. Yum Install PG9.4 2. wget http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm 3. yum install pgdg-redhat94-9.4-1.noarch.rpm 4. yum install postgresql94-server 5. service postgresql-9.4 initdb 6. chkconfig postgresql-9.4 on. Backup Data 7. su - postgres 8. pg_dumpall. The easiest way to set up a PostgreSQL database server on Windows. Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source. ... JDBC Extensions · JDBC Pools · JPA Implementations · JSON Libraries · JVM Languages · Logging Frameworks · Logging Bridges · Mail Clients · Maven Plugins · Mocking · Object/Relational Mapping · PDF Libraries · Top Categories · Home » postgresql » postgresql » 8.0-312.jdbc3. Note: There is a new version for this. 8. 9. 10. 11. 12. 13. 14. 15. 16. postgres@pgbox:/home/postgres/ [PG954] psql. psql (9.5.4 dbi services build). Type "help" for help. (postgres@[ local ]:5438) [postgres] > create database test;. CREATE DATABASE. (postgres@[ local ]:5438) [postgres] > \c test. You are now connected to database "test" as. If the PostgreSQL server's default collation does not suit your needs, you can provide explicit LC_CTYPE (character classification) and LC_COLLATE. UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8. Timo Goosen. on 8/19/14, 7:04 AM • 6,577 views. I tried installing Odoo on Ubuntu 14.04 LTS with PostGreSQL 9.3 and I kept getting the error: "Skipping database test as its base version is not 9.0.1.3". I find it hard to believe that the Odoo/OpenERP developers would want to restrict users to a specific version of postgresql. Setting up the Service Nodes¶. For service nodes, add the IP address of each service nodes to the postgres configuration file: /var/lib/pgsql/data/pg_hba.conf. If you had the following two service nodes: sn10, ip: 192.168.1.10 with netmask 255.255.255.0 sn11, ip: 192.168.1.11 with netmask 255.255.255.0. You would add. Updated: Comment #118 Problem/Motivation There are a number of significant issues with installing and running Drupal 8 on PostgreSQL. Proposed resolution Identify the major issues and implement workarounds or fixes. This should now be done in each individual related issue rather than tacking onto a. Installation (Runtime Configuration). PostgreSQL related installation topics. Database concepts. PostgreSQL related database concepts topics. Data dictionary. PostgreSQL related data dictionary topics. Data manipulation. PostgreSQL related data manipulation topics. BDL programming. PostgreSQL related programming. UTF-8 locale-gen en_US.UTF-8 dpkg-reconfigure locales; Install PostgreSQL packages: Red Hat $ sudo yum install postgresql-server; SLES $ sudo zypper install postgresql91-server. Note : This command will install PostgreSQL 9.1. If you want to install a different version, you can use zypper search postgresql to search for. Step 4 of 8 Configure PostgreSQL for XNAT. Goal. XNAT uses the PostgreSQL database to store all of its persistent data that's not stored in files on the local storage device. In this step, you'll configure your local database so that XNAT can access it for data storage. The basic configuration for PostgreSQL is very simple:. Download postgresql-8.0-312.jdbc3.jar. Files contained in postgresql-8.0-312.jdbc3.jar: META-INF/MANIFEST.MF org.postgresql.Driver.class org.postgresql.PGConnection.class org.postgresql.PGNotification.class org.postgresql.PGRefCursorResultSet.class org.postgresql.PGResultSetMetaData.class org.postgresql. Insert throughput as a function of table size for PostgreSQL 9.6.2, running with 10 workers on an Azure standard DS4 v2 (8 core) machine with SSD-based (premium LRS) storage. Clients insert individual rows into the database (each of which has 12 columns: a timestamp, an indexed randomly-chosen. None, Remote, Low, Single system, None, Partial, None. PostgreSQL versions before 9.4.13, 9.5.8 and 9.6.4 are vulnerable to authorization flaw allowing remote authenticated attackers with no privileges on a large object to overwrite the entire contents of the object, resulting in a denial of service. 2, CVE-2017-7547 · 285. Npgsql is an open source ADO.NET Data Provider for PostgreSQL, it allows programs written in C#, Visual Basic, F# to access the PostgreSQL database server. It is implemented in 100% C# code, is free and is open source. In addition, providers have been written for Entity Framework Core and for Entity Framework 6.x. Please note: Cookies should be enabled for the download process to function properly. Supported Platforms. Back to Top. Products. EDB Postgres Platform · DBaaS Framework for Hybrid Clouds · EDB Support for PaaS Environments · EDB Public Cloud DBaaS · EDB Postgres Subscriptions. Use Cases. New Application. PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and on standards-compliance. PostgreSQL version. The version currently installed by the add-on is : on shared plans (DEV and S) : PostgreSQL 9.2.8; on newly created dedicated databases (plans M and above). A ColdFusion Server blog about the server itself, OS, ColdFusion Security and some codes. I also specialize in JVM tuning and monitoring.: Installing PostgreSQL 8 on Centos 5. PostgreSQL 9.5. Postgres 9.5.10 (09-Nov-17) [ rpm deb exe dmg ]. Postgres 9.5.9 (31-Aug-17) [ rpm deb exe dmg ]. Postgres 9.5.8 (10-Aug-17) [ rpm deb exe dmg ]. Postgres 9.5.7 (11-May-17) [ rpm deb exe dmg ]. Postgres 9.5.6 (09-Feb-17) [ rpm deb exe dmg ]. Postgres 9.5.5 (27-Oct-16) [ rpm deb exe dmg ]. Postgres. 9.6 (2016-09-29), Postgres 9.5 9.5.10 (2017-11-09) 9.5.9 (2017-08-31) 9.5.8 (2017-08-10) 9.5.7 (2017-05-11) 9.5.6 (2017-02-09) 9.5.5 (2016-10-27) 9.5.4 (2016-08-11) 9.5.3 (2016-05-12) 9.5.2 (2016-03-31) 9.5.1 (2016-02-11) 9.5 (2016-01-07), Postgres 9.4 9.4.15 (2017-11-09) 9.4.14 (2017-08-31) 9.4.13 (2017-08-10) Install Postgres Debian. Install PostgreSQL on Debian 9/8/7. Tutorial for installing PostgreSQL server on Debian, Install PostgreSQL 10 on Debian 9/8/7. Postgres BDR. Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source (more…) Kirk Roybal / Principal Consultant, 2ndQuadrant. 8:30 - 5:30. Broadcasting EDB Postgres and PostgreSQL knowledge from the EDB team - Robert Haas, Bruce Momjian, Korry Douglas, Vibhor Kumar and others can be found here in a growing. Discussions. (8 Items). A place to talk about the tools you use or want to consider in your everyday EDB Postgres or PostgreSQL life. PostgreSQL. The database should be create with a UTF-8 collation, for example by using the following command: createdb typo3 -EUTF-8. After the database has been created the MySQL compatibility operators need to be installed. The necessary SQL dump is included with the TYPO3 source and can be. postgresql-7.4.1.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.2.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.3.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.5.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.6.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.7.tar..> 2015-07-14 15:45, -. [DIR], postgresql-7.4.8.tar. In this data tutorial, learn how to list databases and tables in PostgreSQL using psql.. UTF-8 | en_US.UTF-8 | sales | ubuntu | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US. Symantec NetBackup now provides live backup of PostgreSQL (commonly referred to as Postgres). PostgreSQL Agent for NetBackup from Zmanda is deeply integrated and certified with NetBackup 7.x using the XBSA API.The agent supports backup of PostgreSQL versions 8.x, 9.x and 10.x as well as Postgres Plus®. Announcing Release of 2UDA 9.5.8, 9.6.4 and PostgreSQL 10 Beta 3. 2ndQuadrant announces the release of 2UDA 9.5.8, 9.6.4 and Beta 3 for PostgreSQL 10, now available for download here. 2UDA is the easiest way to install PostgreSQL on Windows, Linux and OSX. This update contains important bug fixes and. 3. Requirements. If you have a freshly installed debian 8 server with root access you are ready to install PostgreSQL 9.4. In this article, We are going to install PostgreSQL and give you some introduction. So let's start with the installation. If PostgreSQL is no longer installed on your computer, open My Computer and browse to your Program Files/PostgreSQL directory. There will be a sub-directory listed which is either 8.x or 9.x depending on the version installed. Always Backup Before You Proceed. PokerTracker 4 makes it very easy to. If your Postgres database doesn't use the recommended collation you can run this procedure to bring them into line with the. You are using an unsupported postgres72 collation: ja_JP.UTF-8. This may cause some functionality to not work. Please use POSIX.UTF-8 or C.UTF-8 or C or POSIX as the. Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. From writing simple SQL queries to developing complex databases, Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote. Hello , I have installed Thingworx 8.0.2 as per the installation guide and used psotgresql database but while launching the application i am getting a. Choosing to use MySQL / MariaDB, PostgreSQL, or Oracle (ownCloud Enterprise edition only) as your database requires that you install and set up the server software first. (Oracle users, see Oracle Database Setup.) Note. The steps for configuring a third party database are beyond the scope of this document. Please refer. Requirements for using a PostgreSQL database with ArcGIS include supported database versions, supported spatial data server, supported operating systems, and. Update 2. Red Hat Enterprise Linux Server 6. Update 8. SUSE Linux Enterprise Server 12. Service Pack 1. SUSE Linux Enterprise Server 11. Service Pack 4. [josh@eddie ~/devel/pg_log]$ ll total 8 -rw------- 1 josh josh 611 Nov 12 16:30 postgresql-2014-11-12_162821.csv -rw------- 1 josh josh 192 Nov 12 16:30 postgresql-2014-11-12_162821.log. The CSV log output looks like this: [josh@eddie ~/devel/pg_log]$ cat postgresql-2014-11-12_162821.csv. Session PostgreSQL #8 le 22 septembre à Lyon. Notre huitième pgsession, dédiée cette année à PostgreSQL et PostGIS, et coorganisée avec Oslandia, s'est déroulée au Cercle de L'Union 27 Place Bellecour à Lyon. Ce programme alliant intervenants français et européens, PostgreSQL et PostGIS, a été articulé pour. PostgreSQL is an enterprise level open source database. This is one of the most reliable, robust, feature-rich, and powerful relational database system. Most importantly, PostgreSQL is well known for its ability to handle heavy load, and deliver high performance. This supports pretty much all the features. VividCortex's founder and CEO, Baron Schwartz, shares improvements for MySQL 8.0 and PostgreSQL 9.6 updates. Easy step by step tutorial with screenshots about how to Install Drupal with PostgreSQL. By HOST1PLUS. The following operation obviously deletes everything you had in cluster databases. Perform this operation right after you have installed the base package. Check the PostgreSQL manual if you need to change locale for an existing database (it is not a trivial operation). pg_createcluster --locale de_DE.UTF-8. What you look to have proved here is that the PATH environment for user root does not have the folder that libssl.so.0.9.8 lives in and the user postgres does. What user does Alfresco start under? Do you log in & start Alfresco manually or does it start when you boot the machine? If it starts on boot, check the. PostgreSQL is een open source relational database management system, dat op diverse besturingssystemen kan worden gedraaid. Hierdoor is het breed inzetbaar in verschillende omgevingen. De ontwikkelaars hebben weer een reeks nieuwe versies uitgebracht, met 9.6.4, 9.5.8, 9.4.13, 9.3.18 en 9.2.22. Old Version of PostgreSQL 9.2.8. Website. http://www.postgresql.org. Developer. PostgreSQL Global Development Group. Selected Version. PostgreSQL 9.2.8. Supported Systems Legacy OS support. Windows XP, Vista, 7, 2003, 2008. License. Open Source. Release Date. 20 March, 2014 (4 years ago ). Sponsored Links. Article comparing the ease of installation between Oracle 10g, MySQL 5.0 and PostgreSQL 8.0. Using Java Servlets,JSP,Apache-Tomcat 6/8 and a PostgreSQL or MySQL database with Linux. This tutorial covers installation, configuration and use. This tutorial explains how to install PostgreSQL 9.5 using Debian 8 (Jessie) as your base system.1. Preliminary stepsFirst, ensure your system and apt packa. PostgreSQL-directory/bin/psql --command \\dp bacula. Also, I had an authorization problem with the password. In the end, I had to modify my pg_hba.conf file (in /var/lib/pgsql/data on my machine in /var/lib/postgresql/8.x on others, and in /etc/postgres/8.x/main on still others - what a mess!) from: local all all ident sameuser to. How to find (log) slow queries in PostgreSQL 8.x, 9.x. One of the most important factors when troubleshooting the performance of an application or website, is the performance of the database. Improper indexing or inefficient SQL queries can kill the performance of your application rendering it useless. HeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use. PostgreSQL uses a fixed page size (commonly 8 kB), and does not allow tuples to span multiple pages. Therefore, it is not possible to store very large field values directly. To overcome this limitation, large field values are compressed and/or broken up into multiple physical rows. This happens transparently. Aqua Data Studio provides a client management tool for the PostgreSQL relational database with administration capabilities and a database query tool. UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (4 rows). Connect, Use, and Develop. Databases are multi-ingress: use them from any cloud, PaaS, or your local computer. It is easy to connect from common languages & frameworks including Rails, Django, PHP, and Java: configuration strings are generated for them automatically. The starter tier provides expected up time of. PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX,. Buy Beginning PHP and PostgreSQL 8: From Novice to Professional (Beginning: From Novice to Professional) 1st ed. by W. Jason Gilmore, Robert H. Treat (ISBN: 9781590595473) from Amazon's Book Store. Everyday low prices and free delivery on eligible orders. PostgreSQL RDBMS for Windows, Version 8.0. If the course you are setting up requires PostgreSQL 8.0, follow these instructions to set it up on the student and instructor machines. If you have questions, please contact your courseware vendor. Debian 8 - Install PostgreSQL 9.x. From Debian Packages (9.4). sudo apt-get install postgresql-9.4 -y Copy to clipboard. The output of psql -V will show you version 9.4.9. In the distant past (pre PostgreSQL 8) DBAs had to vacuum manually. They had to balance the resource consumption of vacuuming against the existing db load to decide when to do it, and potentially when to interrupt it. Nowadays we can configure the “autovacuum” daemon to clean up for us at the most. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19, class { 'postgresql::server': } postgresql::server::role { 'marmot': password_hash => postgresql_password('marmot', 'mypasswd'), } postgresql::server::database_grant { 'test1': privilege => 'ALL', db => 'test1', role => 'marmot', } postgresql::server::table_grant { 'my_table of. NET Data Provider for PostgreSQL 9.x and 8.x. It allows you to access a PostgreSQL database from any .NET application. PostgreSQL 9.x and 8.x Microsoft .NET 4.0 and 3.5 Mono (open source .NET) C# and Visual Basic.NET ASP.NET and Web Services How to Install Npgsql Download the data provider at (BSD License). PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many. Chapter 8. Use a PostgreSQL Database Server with Red Hat Gluster Storage Console. You can manually configure a database server to host the Red Hat Gluster Storage Console database. It can be hosted either locally on the Red Hat Gluster Storage Console server, or remotely on another server where posgresql and. OK, got it from someone else. This query does the trick: select * from pg_stat_activity where datname = 'mydatabasename'. Here are the supported PostgreSQL 8.x database service metrics. Combining the best open-source SQL database engine with our extensive geographical coverage, automatic no-downtime migration between regions and plans, automatic real-time backup and high-availability features allows us to offer you the most advanced, fully-managed PostgreSQL DBaaS hosting on the planet. postgresql-9.5 (9.5.8-0ubuntu0.16.04.1) xenial-security; urgency=medium * SECURITY UPDATE: Update to 9.5.8 to fix security issues - Further restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (CVE-2017-7547) - Disallow empty passwords in all. PostgreSQL LENGTH() function with Example : The PostgreSQL length function is used to find the length of a string i.e. number of characters in the given. 9 Jose Manuel | 11 Alexander | 9 Christopher | 11 Danielle | 8 Harrison | 8 Elizabeth | 9 Jonathon | 8 Kimberely | 9 Jennifer | 8 Jennifer | 8 (11 rows)