pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing BSD/OS with 8.1, 8.4 and 9.3
10+ messages / 4 participants
[nested] [flat]
* Using BSD/OS with 8.1, 8.4 and 9.3
@ 2014-02-13 23:32 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-15 19:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
0 siblings, 2 replies; 10+ messages in thread
From: The Doctor @ 2014-02-13 23:32 UTC (permalink / raw)
To: pgsql-admin
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 perfrom better than
8.4 compile and 9.3 compiled.
Question: is their anything I should tweek?
--
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
He will always be a slave who does not know how to live upon a little. -Horace
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
@ 2014-02-14 01:06 ` Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
1 sibling, 1 reply; 10+ messages in thread
From: Bruce Momjian @ 2014-02-14 01:06 UTC (permalink / raw)
To: The Doctor <doctor@doctor.nl2k.ab.ca>; +Cc: 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 perfrom better than
>
> 8.4 compile and 9.3 compiled.
>
> Question: is their anything I should tweek?
Wow, what version of BSD/OS are you using? We removed BSD/OS support in
Postgres 9.2. I ran BSD/OS until December 2011.
Usually Postgres gets faster so I am unclear why older versions would be
faster.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
@ 2014-02-14 03:16 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 14:39 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 10+ messages in thread
From: The Doctor @ 2014-02-14 03:16 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin
oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian 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 perfrom better than
> >
> > 8.4 compile and 9.3 compiled.
> >
> > Question: is their anything I should tweek?
>
> Wow, what version of BSD/OS are you using? We removed BSD/OS support in
> Postgres 9.2. I ran BSD/OS until December 2011.
>
> Usually Postgres gets faster so I am unclear why older versions would be
> faster.
4.3.1 using 4GB Ram and 3+ Dual 32-bit XEON CPUs.
I wonder if the configuration has something to do
with the proble,
BTW for 93. + FreeBSD does well thank you.
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
--
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
He will always be a slave who does not know how to live upon a little. -Horace
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
@ 2014-02-14 14:39 ` Bruce Momjian <bruce@momjian.us>
2014-02-14 14:52 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Alvaro Herrera <alvherre@2ndquadrant.com>
2014-02-14 15:53 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
0 siblings, 2 replies; 10+ messages in thread
From: Bruce Momjian @ 2014-02-14 14:39 UTC (permalink / raw)
To: The Doctor <doctor@doctor.nl2k.ab.ca>; +Cc: pgsql-admin
On Thu, Feb 13, 2014 at 08:16:19PM -0700, The Doctor wrote:
> oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian 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 perfrom better than
> > >
> > > 8.4 compile and 9.3 compiled.
> > >
> > > Question: is their anything I should tweek?
> >
> > Wow, what version of BSD/OS are you using? We removed BSD/OS support in
> > Postgres 9.2. I ran BSD/OS until December 2011.
> >
> > Usually Postgres gets faster so I am unclear why older versions would be
> > faster.
>
> 4.3.1 using 4GB Ram and 3+ Dual 32-bit XEON CPUs.
>
> I wonder if the configuration has something to do
> with the proble,
Uh, I was not aware of any performance problems when I was running
BSD/OS.
> BTW for 93. + FreeBSD does well thank you.
Yeah, we thought I was the only BSD/OS user left on PG, so when I left,
we removed support for the platform.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 14:39 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
@ 2014-02-14 14:52 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2014-02-14 15:55 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 10+ messages in thread
From: Alvaro Herrera @ 2014-02-14 14:52 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: The Doctor <doctor@doctor.nl2k.ab.ca>; pgsql-admin
Bruce Momjian wrote:
> On Thu, Feb 13, 2014 at 08:16:19PM -0700, The Doctor wrote:
> > oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian wrote:
> > BTW for 93. + FreeBSD does well thank you.
>
> Yeah, we thought I was the only BSD/OS user left on PG, so when I left,
> we removed support for the platform.
There was also the small detail that BSD/OS in its entirety has been out
of support for ten years now. FreeBSD 10.0 was released this year, so
at least that one can claim it's still alive.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 14:39 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-14 14:52 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Alvaro Herrera <alvherre@2ndquadrant.com>
@ 2014-02-14 15:55 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 10+ messages in thread
From: Achilleas Mantzios @ 2014-02-14 15:55 UTC (permalink / raw)
To: pgsql-admin
On 14/02/2014 16:52, Alvaro Herrera wrote:
> Bruce Momjian wrote:
>> On Thu, Feb 13, 2014 at 08:16:19PM -0700, The Doctor wrote:
>>> oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian wrote:
>>> BTW for 93. + FreeBSD does well thank you.
>> Yeah, we thought I was the only BSD/OS user left on PG, so when I left,
>> we removed support for the platform.
> There was also the small detail that BSD/OS in its entirety has been out
> of support for ten years now. FreeBSD 10.0 was released this year, so
> at least that one can claim it's still alive.
Not until Netcraft confirms so.
Sorry couldn't resist!
>
--
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 14:39 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Bruce Momjian <bruce@momjian.us>
@ 2014-02-14 15:53 ` The Doctor <doctor@doctor.nl2k.ab.ca>
1 sibling, 0 replies; 10+ messages in thread
From: The Doctor @ 2014-02-14 15:53 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin
On Fri, Feb 14, 2014 at 09:39:39AM -0500, Bruce Momjian wrote:
> On Thu, Feb 13, 2014 at 08:16:19PM -0700, The Doctor wrote:
> > oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian 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 perfrom better than
> > > >
> > > > 8.4 compile and 9.3 compiled.
> > > >
> > > > Question: is their anything I should tweek?
> > >
> > > Wow, what version of BSD/OS are you using? We removed BSD/OS support in
> > > Postgres 9.2. I ran BSD/OS until December 2011.
> > >
> > > Usually Postgres gets faster so I am unclear why older versions would be
> > > faster.
> >
> > 4.3.1 using 4GB Ram and 3+ Dual 32-bit XEON CPUs.
> >
> > I wonder if the configuration has something to do
> > with the proble,
>
> Uh, I was not aware of any performance problems when I was running
> BSD/OS.
Well I had to tweak the kernel and add more semaphores.
I also noted the 8.4 and 9.2 compiles were slightly different from the
8.1 compile.
>
> > BTW for 93. + FreeBSD does well thank you.
>
> Yeah, we thought I was the only BSD/OS user left on PG, so when I left,
> we removed support for the platform.
No worries. I am the last holdout looking to port everything to more powerful
FreBSD 9.2 or above server.
I just do not have the money.
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
--
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
He will always be a slave who does not know how to live upon a little. -Horace
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
@ 2014-02-15 19:16 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-18 14:26 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
1 sibling, 1 reply; 10+ messages in thread
From: The Doctor @ 2014-02-15 19:16 UTC (permalink / raw)
To: 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@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
He will always be a slave who does not know how to live upon a little. -Horace
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-15 19:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
@ 2014-02-18 14:26 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-18 15:39 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 10+ messages in thread
From: The Doctor @ 2014-02-18 14:26 UTC (permalink / raw)
To: 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@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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Using BSD/OS with 8.1, 8.4 and 9.3
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-15 19:16 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-18 14:26 ` Re: Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
@ 2014-02-18 15:39 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 10+ messages in thread
From: Achilleas Mantzios @ 2014-02-18 15:39 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2014-02-18 15:39 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-02-13 23:32 Using BSD/OS with 8.1, 8.4 and 9.3 The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 01:06 ` Bruce Momjian <bruce@momjian.us>
2014-02-14 03:16 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-14 14:39 ` Bruce Momjian <bruce@momjian.us>
2014-02-14 14:52 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2014-02-14 15:55 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2014-02-14 15:53 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-15 19:16 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-18 14:26 ` The Doctor <doctor@doctor.nl2k.ab.ca>
2014-02-18 15:39 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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