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-15 19:16:32
Message-ID: 20140215191632.GA27700@doctor.nl2k.ab.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

--
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
He will always be a slave who does not know how to live upon a little. -Horace

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mohamed MANSOUR 2014-02-16 21:38:49 Error when installing Postgres in Windows 8.1 64bit
Previous Message Sebastien Douche 2014-02-14 17:16:02 Re: Can't upgrade a DB from 8.4 to 9.3 with pg_uprade: pg 9 not started