From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
Date: Tue, 18 Feb 2014 17:39:24 +0200
Message-ID: <53037EAC.7050105@matrix.gatewaynet.com> (raw)
In-Reply-To: <20140218142634.GA27808@doctor.nl2k.ab.ca>
References: <20140213233203.GA27689@doctor.nl2k.ab.ca>
<20140215191632.GA27700@doctor.nl2k.ab.ca>
<20140218142634.GA27808@doctor.nl2k.ab.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
In-Reply-To: <53037EAC.7050105@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox