Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WElfs-0006M9-JU for pgsql-admin@arkaria.postgresql.org; Sat, 15 Feb 2014 20:17:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WElfs-0001uO-45 for pgsql-admin@arkaria.postgresql.org; Sat, 15 Feb 2014 20:17:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WElfr-0001uI-EL for pgsql-admin@postgresql.org; Sat, 15 Feb 2014 20:17:19 +0000 Received: from doctor.nl2k.ab.ca ([204.209.81.1]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WElfn-0001RX-Bc for pgsql-admin@postgresql.org; Sat, 15 Feb 2014 20:17:18 +0000 Received: from doctor by doctor.nl2k.ab.ca with local (Exim 4.82) (envelope-from ) id 1WEkj2-00005k-LB for pgsql-admin@postgresql.org; Sat, 15 Feb 2014 12:16:32 -0700 Date: Sat, 15 Feb 2014 12:16:32 -0700 From: The Doctor To: pgsql-admin@postgresql.org Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3 Message-ID: <20140215191632.GA27700@doctor.nl2k.ab.ca> References: <20140213233203.GA27689@doctor.nl2k.ab.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20140213233203.GA27689@doctor.nl2k.ab.ca> User-Agent: Mutt/1.5.17 (2007-11-01) X-Pg-Spam-Score: -1.8 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Thu, Feb 13, 2014 at 04:32:04PM -0700, The Doctor wrote: > All right, finally compiled more semaphores > into the server to use more recent and supported PostGRESQL version. > > Odd problem is that 8.1 seems to perform better than > > 8.4 compile and 9.3 compiled. > > Question: is their anything I should tweek? > Think I have narrowed the problem to the serendipity blog software. In 8,1 (discontinued) It works well. All I did was a dump based on http://en.wikibooks.org/wiki/Converting_MySQL_TO_PostgreSQL Using the CSV method. Something in the software/tables does not jive when a pg_dump then a normal restore procedure. I need to export the DB into a set of CSV files then restore after using the CSV files. Any method of doing this? -- Member - Liberal International This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca God,Queen and country!Never Satan President Republic!Beware AntiChrist rising! http://www.fullyfollow.me/rootnl2k Look at Psalms 14 and 53 on Atheism He will always be a slave who does not know how to live upon a little. -Horace -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin