Date: Tue, 18 Feb 2014 07:26:35 -0700
From: The Doctor <doctor@doctor.nl2k.ab.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
Message-ID: <20140218142634.GA27808@doctor.nl2k.ab.ca>
References: <20140213233203.GA27689@doctor.nl2k.ab.ca>
 <20140215191632.GA27700@doctor.nl2k.ab.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20140215191632.GA27700@doctor.nl2k.ab.ca>
User-Agent: Mutt/1.5.17 (2007-11-01)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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.

-- 
Member - Liberal International	This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.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
We regret the past we cannot fix at the expense of the now which we can.-unknown 


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