On 18/02/2014 16:26, The Doctor wrote:
> On Sat, Feb 15, 2014 at 12:16:32PM -0700, The Doctor wrote:
>> 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?
>>
>
> Found out the real problem.
>
> The main Serendipity Developer , Garvin Hicking, said
>
> "I remember PGSql at soem point dropping some OID-related feature, which
> s9y (serendipity) requires for autoincrements".
>
> Is their any way of resolving this matter?
>
> Also can I encourage Gavin to join one of the PGsql Groups?
>
> Why am I asking this?
>
> Serendipity is easier than Wordpress and Serendipity does support
> PostgreSQL unlike Wordpress which is strictly MySQl only.
try playing with default_with_oids :
set default_with_oids TO true;
or set it in your postgresql.conf
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt