Re: [GENERAL] Gentoo for production DB server?
On Tue, 2004-08-24 at 16:33, Christine Desmuke wrote: > At the risk of starting a flame-war, I'd like some more details on the > use of Gentoo Linux for a production PostgreSQL server. There have been > a couple of comments lately that it is not such a great idea; does > anyone have specific experience they'd be willing to share? I used Gentoo for a long time on my home systems but I recently quit. It's a "fun" distro as far as the options and all, and it has a great user community for support.. but I got tired of the Gentoo developers (whether intentional or not) pushing out new stuff marked as "stable" when it obviously was not. The price was right and I knew going in I wasn't getting a perfectly stable distro, but nevertheless they left me with a broken machine on several occasions. Having a slightly faster machine isn't worth the headaches to me personally. For stability, db/web server usage and such, I'd go with Debian. For features, desktop systems, etc., I'd go with Suse. 9.1 is impressive. For security, firewall, or router usage, I'd go with *BSD. -- Greg Donald ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Gentoo for production DB server?
I've been extremely happy with my gentoo boxes. I switched from Slackware over the past year or so after many years of Slackware zealotry. I have nothing bad to say about using Gentoo other than I personally wouldnt use portage/ebuilds for PostgreSQL. Personally I always have better experiences when I download the source tarball and install things like PostgreSQL the way the developers distribute them. Gavin Greg Donald wrote: On Tue, 2004-08-24 at 16:33, Christine Desmuke wrote: At the risk of starting a flame-war, I'd like some more details on the use of Gentoo Linux for a production PostgreSQL server. There have been a couple of comments lately that it is not such a great idea; does anyone have specific experience they'd be willing to share? I used Gentoo for a long time on my home systems but I recently quit. It's a "fun" distro as far as the options and all, and it has a great user community for support.. but I got tired of the Gentoo developers (whether intentional or not) pushing out new stuff marked as "stable" when it obviously was not. The price was right and I knew going in I wasn't getting a perfectly stable distro, but nevertheless they left me with a broken machine on several occasions. Having a slightly faster machine isn't worth the headaches to me personally. For stability, db/web server usage and such, I'd go with Debian. For features, desktop systems, etc., I'd go with Suse. 9.1 is impressive. For security, firewall, or router usage, I'd go with *BSD. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Gentoo for production DB server?
On Wed, 2004-08-25 at 08:46, Matthew Marlowe wrote: > Gentoo has alot of features, is amazingly customizeable, and can significantly > reduce long term systems maintenance costs -- but it isn't a silver bullet. You have > to take over some QA tasks that redhat/etc would otherwise be doing. > > We currently have about 100 gentoo servers here, and wouldn't think about switching > to any other distro. But just because the gentoo developers release a new ebuild, > doesn't > mean that we deploy it w/o testing. That's exactly my point. They provide a way for you to add unstable packages using ACCEPT_KEYWORDS="~x86". I never used the command because I never _wanted_ unstable packages. Seems I got them anyway. -- Greg Donald ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Gentoo for production DB server?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 25 Aug 2004, Mark Gibson wrote: > We've now switched to RHEL3 (management decision - for support!), > which IMHO is an admin nightmare (but thats just RPM's for you). > We had to download and compile several important packages manually, > the supplied PostgreSQL was very out of date, and PHP didn't even > have PostgreSQL support builtin. RPMS for RHEL 3 is available on PostgreSQL FTP mirrors... Also, if you want PostgreSQL support in PHP, you should install php-pgsql rpm, provided in the CDs. > You also don't have to install tons of unused crap, like X11. Agreed :( Regards, - -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBLLoVtl86P3SPfQ4RAgcfAKDHxpeKui+nsszicPDs8ue59ZN8tgCg2c+j baKHqXdxZH9OXGcxHOgo42w= =HdCI -END PGP SIGNATURE- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Gentoo for production DB server?
On Tue, 2004-08-24 at 15:01, Greg Donald wrote: > when it obviously was not. The price was right and I knew going in I > wasn't getting a perfectly stable distro, but nevertheless they left me > with a broken machine on several occasions. Having a slightly faster > machine isn't worth the headaches to me personally. I too fiddled with it at home for a while. I saw a few benchmarks showing Gentoo was actually slower than Redhat and Mandrake - then I really wasn't sure why I was compiling for days. :) Yes, I know you don't have to compile everything. Yes, I realize those benchmarks weren't the most scientific. We use Redhat in production. When it came to decision time, the only real contenders were Redhat and Suse, because we wanted someone else to QA our operating system (not our business focus - that would cost us more than the OS) and we needed the best hardware vendor support. We picked Redhat over Suse primarily because everyone in our organization had Redhat experience (and on their desktops) but no Suse experience - otherwise I probably would've gone with Suse. I'm really tired of poor file system diversity on Redhat. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Gentoo for production DB server?
Barry S wrote: In article <[EMAIL PROTECTED]>, "Christine Desmuke" wrote: Hello: At the risk of starting a flame-war, I'd like some more details on the use of Gentoo Linux for a production PostgreSQL server. There have been a couple of comments lately that it is not such a great idea; does anyone have specific experience they'd be willing to share? I'm an ex-Gentoo admin, not because gentoo isn't fun, just that you need to really really like to constantly fiddle with it to keep it happy. The worst thing is to have not done an 'emerge world' in 2 months, only to discover that there are now 99 pending updates. Do you was obliged to catch them ? Gaetano ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Gentoo for production DB server?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremiah Elliott wrote: | Gaetano Mendola wrote: | |> Barry S wrote: |> |>> In article <[EMAIL PROTECTED]>, "Christine Desmuke" wrote: |>> |>>> Hello: |>>> |>>> At the risk of starting a flame-war, I'd like some more details on the |>>> use of Gentoo Linux for a production PostgreSQL server. There have been |>>> a couple of comments lately that it is not such a great idea; does |>>> anyone have specific experience they'd be willing to share? |>>> |>> |>> |>> |>> I'm an ex-Gentoo admin, not because gentoo isn't fun, just that you need |>> to really really like to constantly fiddle with it to keep it happy. |>> |>> The worst thing is to have not done an 'emerge world' in 2 months, only |>> to discover that there are now 99 pending updates. |> |> |> |> Do you was obliged to catch them ? |> |> Gaetano | I use gentoo and RHEL. My biggest beef with redhat is that their rpm of | postgres is of a rather old version, so I end up downloading the source | tar and compiling it my self. Also I would really like to be running XFS | on all my databases servers, but the only fs I can run on the redhat | servers is ext3. | -jeremiah And how RH can delivery a Postgres upgrade if it require an initdb ? The reason as already discussed is a leak of pg_upgrade that can permit the upgrade without perform a cicle of: dump-install-initdb-crossedfingers-reload and even if the pg_upgrade was existing for sure I'll not trust my data to an automatic upgrade. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBPidp7UpzwH2SGd4RAtaEAKDSVWqGJyu0QW2XIjPyaLZaQCSpcQCdHOOO ZMkeVbecaZEslFsnNslMAfE= =B1ns -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings