Re: [Server-devel] Want to package PostgreSQL for OLPC

[Devrim GÜNDÜZ]

On Wed, 2008-06-25 at 08:48 -0400, Martin Langhoff wrote:

 How hard is it to get a backport of Pg8.2/8.3, plus some key
 dependencies (php-pgsql, python-pgsql, pam-pgsql) recompiled to use
 the new libpq, all on F7?

http://yum.pgsqlrpms.org ;)

I have already built all PG combinations against Fedora 7-8-9 and RHEL
4,5. 

We have compat packages, and all pam-pgsql, etc in that repository. So,
using those files won't be a problem.

 Also - I see you work at CommandPrompt -- so I'll throw a wishlist
 item I have on my list in your direction. Perhaps you, or someone at
 CommandPrompt has something similar. With Pg packaged, what we will
 need to come up with is ~3 sets of config files tuned for different
 memory footprints. The same XS image will be used in hosts with
 various memory configurations - 256MB RAM on XO hardware, 1GB on the
 recommended config, and high-end hosts may have more RAM.

Sure, it is doable -- I can do it for you.

 Pg cannot take all of that memory, but perhaps 15%-20% is a reasonable
 footprint. The workload for Pg is mainly Moodle and MediaWiki.

Ok.

 One of the key things for the XS is that we should not OOM, and our
 working set _must not_ end up in swap. And we have several services we
 have to run, so it's a bit of a tough diet on RAM usage. We gotta
 sweat every MB :-)

You are right.

So, please let me know when you need the config files, and also how can
I submit those packages to OLPC repository.

Regards,
-- 
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/


signature.asc
Description: This is a digitally signed message part
___
Server-devel mailing list
Server-devel@lists.laptop.org
http://lists.laptop.org/listinfo/server-devel

Re: [Server-devel] Want to package PostgreSQL for OLPC

[Devrim GÜNDÜZ]

On Wed, 2008-06-25 at 09:44 -0400, Martin Langhoff wrote:
 
  We have compat packages, and all pam-pgsql, etc in that repository.
 So,
  using those files won't be a problem.
 
 Fantastic! So python-pgsql and php-pgsql are there too?

python-psycopg2 is there, but not php-pgsql. The question is: Is
php-pgsql already in OLPC package set? If yes, we have compat packages
to satisfy dependencies. If not, I can give it a shot.

 ...
  So, please let me know when you need the config files, and also how
 can
  I submit those packages to OLPC repository.
 
 When? Yesterday ;-)  - but perhaps there is no need for rebuilding the
 packages. What I am wondering about is what the best solution is to
 maintain those alternative configurations long-term.


 Perhaps we could have a postgresql-server-altinit package that
 provides an alternative init script + config files and disables the
 init script from postgresql-server. The alternative init check memory
 size, and starts with the appropriate config files.

Maybe we can solve this issue during initdb process, and copy the
preconfigured config file based on the memory to data directory after we
run initdb.

It may be easier to maintain...

BTW... I must admit that I did not work for OLPC project before, so I
don't know how to do things.

Regards,
-- 
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/


signature.asc
Description: This is a digitally signed message part
___
Server-devel mailing list
Server-devel@lists.laptop.org
http://lists.laptop.org/listinfo/server-devel