ZFS has an option to use an SSD as cache for the spinning drives. ZFS
under Solaris has turned in some really good IO numbers. The problem is
with the new Sun I am not feeling so good about the open nature of
Solaris. ZFS performance under BSD I have read does not match ZFS under
Solaris.
On 11/11
I would say that if you pick any of the big four you will be fine.
CentOS
Ubuntu Server LTS
Red Hat
Suse
Debian can also be a good choice.
We used to be an OpenSuse shop but we are now moving everything to
Ubuntu Server LTS. I can not say enough good things about CentOS as far
as stability and long
I'm more a fan of centos, but have to give grudging respect to the
latest couple of versions of ubuntu server. Once you learn the new
way of doing things, it's quite easy to keep happy.
The version of Ubuntu Server I looked at one one of the first versions.
I am sure that Ubuntu has improved
wanted but that was a while ago.
I guess it is compile from source. yeckkk.
Scott Marlowe wrote:
On Tue, Aug 12, 2008 at 12:51 PM, David Siebert <[EMAIL PROTECTED]> wrote:
I am setting up a new server and I am using OpenSuse. OpenSuse only has
8.3.1 in the repositories so I am wondering just
I am setting up a new server and I am using OpenSuse. OpenSuse only has
8.3.1 in the repositories so I am wondering just how critical is the
need to update? I checked out the changed and there looks like a lot of
them in 8.3.2. so I am wondering if I should just install from source or
live with t
Well that is the rub. I am currently using Postgres everyday. It runs
like a champ and even on an old PIII 600 MHZ machine with a single old
and slow IDE drive and 256 megs of ram it is fast enough for what we do.
This is more for me to do some testing with.
I think it would useful as a tunning to
I am interesting in finding a good Postgres benchmark. I an not
interested in seeing how fast Postgres is compared to MySql, Firebird,
or any other SQL database.
What I am interested in is how file systems, memory, and X-64 vs X-32
effects the performance of Postgres.
It is more for my own curiosi
real server with dual Xeons and a gig
of ram. That should keep it happy for a decade or two. Did I mention
that I love the performance of Postgres and Linux?
Greg Smith wrote:
On Tue, 24 Jun 2008, David Siebert wrote:
Which disto is best for running a Postgres server?
You didn't define
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Which disto is best for running a Postgres server?
I just installed OpenSuse and downloaded and compiled the latest version
of Postgres. It isn't that big of a hassle but I noticed that almost
none of the big distros keep all that up to date with Pos
I set up a test server using the latest 8.2 as suggest by the list and
did pg_dump of the old data base.
I created a new empty database with the same name an created a user with
the same name as was on the old server.
I then tried to do a restore using webmin just as a test and got errors.
I am see
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am using CentOS 5 and would like to update to 8.2.5. Does anyone know
of a repository that carries it? RedHat 5 should work as well.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Mozilla - http://eni
I have a very old postgres server that I am trying to move the data off
of. It is running 7.1 and has been trouble free for 6 plus years.
I am trying to move the data base off to a server running 8.1.
I have managed to back up the data using PG_Dump using like this.
" pg_dump -b -Fc -h stan.somepla
I have a very old postgres server that I am trying to move the data off
of. It is running 7.1 and has been trouble free for 6 plus years.
I am trying to move the data base off to a server running 8.1.
I have managed to back up the data using PG_Dump using like this.
" pg_dump -b -Fc -h stan.somepla
Richard Huxton wrote:
Zlatko Matić wrote:
Hello.
Till now I've been working with Postgres only through pgAdminIII.
Postgres is installed on WIndows XP. Now I need to use pg_dumpall. I
have found folder with different Postgres aplications, placed in
C:\Program Files\PostgreSQL\8.0\bin. When I d
I have three scripts that I am running to do pg_dumpall and a vacuum on
my server.
one is run every night except Sundays.
one is run every Sunday night.
one is run the first of each month.
After I ftp the backup to a standby server the vacuum is run.
The database is pretty small it only grows by
Thanks for the help but it was an SELinux policy problem.
I turned it off for now. I just do not have the time to learn SELinux
right now and my server is located behind a fire wall, contains not
sensitive data, and is just a test box for now.
Tom Lane wrote:
David Siebert <[EMAIL PROTEC
Richard Huxton wrote:
David Siebert wrote:
Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
I SSH into the server and try and run pg_dump all and get a stream of
errors on the server screen but not on my ssh.
Any suggestions?
Um - post some of the errors?
There are
Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
I SSH into the server and try and run pg_dump all and get a stream of
errors on the server screen but not on my ssh.
Any suggestions?
---(end of broadcast)---
TIP 9: the planner w
I have tried to do an update to Postgresql 8.0.3 and got an error saying
this package targets the 686!
I am trying to install it on a celeron 733 for a test machine which last
time I checked was a 686.
Any suggestions besides using a tar ball?
By any chance has 8.0.3 made it into a YUM repositor
Windows XP SP2
Java SDK V1.4.2_08
JDBC 7.4.216.jdbc3
When I use now in an update it is giving me a very odd value in the
database. This is what PGAdminIII shows 2005-06-09 13:52:46.259715
I am not expecting the decimal seconds. I am getting an out of range
error in java when I read the column.
I am trying to add records to a table in DBI and I keep getting an error 7
The exact error is DBD::Pg::st execute failed: at connect.pl line 107.
ERROR!!! (7) INSERT INTO phonegroups VALUES ('TECHIES',1, 1)
I included the statement and when I try it in pgpadmin it works fine.
Any suggestions?
-
year but postgres has
never lost a call and the server keeps chugging away.
Tom Lane wrote:
David Siebert <[EMAIL PROTECTED]> writes:
I also know that somewhere
their is a version of bugzilla that runs on Postgres but I have not had
much luck finding it.
Red Hat runs their bugzilla on Po
"at the time, everybody bought Microsoft's IAS; it was the dominant web
server around—85% share, something like that. And Apache just utterly
crushed them"
What I want to know is when did Microsoft have 85% of the web server
market? I sure don't remember that. Maybe he means 85% of the Windows
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Anyone using Activestate Perl and DBD-Pg?
I am using perl 5.8.3 ppm does not seem to work. I downloaded the DBD-Pg
.zip file I found through google but ppm could not seem to install that.
Any suggestions?
There has been
Anyone using Activestate Perl and DBD-Pg?
I am using perl 5.8.3 ppm does not seem to work. I downloaded the DBD-Pg
.zip file I found through google but ppm could not seem to install that.
Any suggestions?
---(end of broadcast)---
TIP 2: you can get
25 matches
Mail list logo
