Hi Pawel: On Thu, 2002-07-11 at 08:34, Pawel Krasucki wrote: > I was going to setup a test environment and was trying to figure what db > to setup as well. You mentioned using Postgres, have you ever worked > with MySQL? Although I've installed Postgres, I haven't worked with it > at all, is it hard to pick up and work with? I had it running on Linux, I guess my comparison would be Oracle or Sybase. Getting Postgres working is not difficult. It is easy if you are installing from rpms. If you are building it yourself (I do recommend this for larger usage patterns), make sure you configure it to allow a large number of connections. Most RPM's by default are configured for 32 to 40 connections at max. This is great for most small/tiny projects, but not so great for larger projects. Also make sure you build in SSL support, as well as increasing various other constants. You have to modify the pg_hba.conf file to allow users on remote machines/clients to access the database. You need a line that looks like this: host all x.y.z.t a.b.c.d password where x.y.z.t (a.b.c.d) is the net (netmask) address. Make sure you add the -i option to the /etc/init.d/postgresql startup code. Mandrake and a few others needed adjustment. Change the postgresql.conf file to turn on the enabled (-i on the postmaster) tcpip support. tcpip_socket = true will allow remote clients to connect. As far as GUI admin, there are several tools, but I havent used any of them. You can use phpPgAdmin (http://freshmeat.net/projects/phppgadmin/?topic_id=68%2C67) or the Java SQL Admin Tool (http://freshmeat.net/projects/sql-admin/?topic_id=68%2C66%2C45%2C259). > and was using GUI utility with Linux to administer Postgres, is that a > common way to administer that db? I do things by hand. Gui tools are nice, but they dont work so well from 2000+ miles away (~3300 km). > > Paul Krasucki > IT Supervisor > Professional Solutions STAT Inc., > St. Louis, MO 63114 > (314) 428-8335 ext 129 > > > -----Original Message----- > From: biodevelopers-admin at bioinformatics.org > [mailto:biodevelopers-admin at bioinformatics.org] On Behalf Of Joe Landman > Sent: Wednesday, July 10, 2002 09:55 PM > To: biodevelopers > Subject: [Biodevelopers] what databases are you using? > > A few years ago, the db of choice was some sort of Oracle implementation > for many people I spoke to/worked with at a variety of pharmas and > biotechs. I am curious what people are using now (if anything). I do > know people using flat files for a variety of reasons as well. > > Just curious. I use/like Postgres for my own development/testing. > > -- > Joe Landman, > email: landman at scientificappliance.com > web : http://scientificappliance.com > > _______________________________________________ > Biodevelopers mailing list > Biodevelopers at bioinformatics.org > http://bioinformatics.org/mailman/listinfo/biodevelopers > > _______________________________________________ > Biodevelopers mailing list > Biodevelopers at bioinformatics.org > http://bioinformatics.org/mailman/listinfo/biodevelopers -- Joe Landman, email: landman at scientificappliance.com web : http://scientificappliance.com