From: | The Doctor <doctor(at)doctor(dot)nl2k(dot)ab(dot)ca> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Using BSD/OS with 8.1, 8.4 and 9.3 |
Date: | 2014-02-15 19:16:32 |
Message-ID: | 20140215191632.GA27700@doctor.nl2k.ab.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)nl2k(dot)ab(dot)ca Ici doctor(at)nl2k(dot)ab(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mohamed MANSOUR | 2014-02-16 21:38:49 | Error when installing Postgres in Windows 8.1 64bit |
Previous Message | Sebastien Douche | 2014-02-14 17:16:02 | Re: Can't upgrade a DB from 8.4 to 9.3 with pg_uprade: pg 9 not started |