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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
