Re: Using BSD/OS with 8.1, 8.4 and 9.3

From: The Doctor <doctor(at)doctor(dot)nl2k(dot)ab(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
Date: 2014-02-18 14:26:35
Message-ID: 20140218142634.GA27808@doctor.nl2k.ab.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)nl2k(dot)ab(dot)ca Ici doctor(at)nl2k(dot)ab(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2014-02-18 15:39:24 Re: Using BSD/OS with 8.1, 8.4 and 9.3
Previous Message Sofer, Yuval 2014-02-18 07:39:54 Postgres service (Windows) running as "local system"