From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Using BSD/OS with 8.1, 8.4 and 9.3 |
Date: | 2014-02-18 15:39:24 |
Message-ID: | 53037EAC.7050105@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Murthy Nunna | 2014-02-18 16:58:27 | pg_basebackup |
Previous Message | The Doctor | 2014-02-18 14:26:35 | Re: Using BSD/OS with 8.1, 8.4 and 9.3 |