Message-ID: <53037EAC.7050105@matrix.gatewaynet.com>
Date: Tue, 18 Feb 2014 17:39:24 +0200
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:24.0) Gecko/20100101 Thunderbird/24.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
References: <20140213233203.GA27689@doctor.nl2k.ab.ca>
 <20140215191632.GA27700@doctor.nl2k.ab.ca>
 <20140218142634.GA27808@doctor.nl2k.ab.ca>
In-Reply-To: <20140218142634.GA27808@doctor.nl2k.ab.ca>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin