AH == Alvaro Herrera [EMAIL PROTECTED] writes:
AH On Wed, Aug 27, 2003 at 12:21:53PM -0400, Vivek Khera wrote:
GS == Greg Stark [EMAIL PROTECTED] writes:
GS Vivek Khera [EMAIL PROTECTED] writes:
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of 24x7
On Wed, Aug 27, 2003 at 12:21:53PM -0400, Vivek Khera wrote:
GS == Greg Stark [EMAIL PROTECTED] writes:
GS Vivek Khera [EMAIL PROTECTED] writes:
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of 24x7 operation. Still I would be interested.
Well,
GS == Greg Stark [EMAIL PROTECTED] writes:
The DB is currently about 27Mb on disk (including indexes) and
processes several million inserts and updates daily, and a few million
deletes once every two weeks.
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of
DG == Dennis Gearon [EMAIL PROTECTED] writes:
DG With the low cost of disks, it might be a good idea to just copy to
DG disks, that one can put back in.
Your file system copies will be broken, since they only work if
PG is shut down. For this very reason I don't even bother doing a
file system
I meant,use disks as the medium. Put DUMP's on it.
Vivek Khera wrote:
"DG" == Dennis Gearon [EMAIL PROTECTED] writes:
DG With the low cost of disks, it might be a good idea to just copy to
DG
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
One of our sysads sent this link ... wondering if there is any comment on it from
the world of actual users of linux and a database.
http://story.news.yahoo.com/news?tmpl=storycid=1738ncid=738e=9u=/zd/20030825/tc_zd/55311
Weak points
On Tue, 2003-08-26 at 03:06, Shridhar Daithankar wrote:
On 26 Aug 2003 at 2:55, Ron Johnson wrote:
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
One of our sysads sent this link ... wondering if there is any comment on it
from the world of actual users of linux and a
On Tue, Aug 26, 2003 at 09:15:14AM -0700, Al Hulaton wrote:
Perhaps the PostgreSQL team bidding for the job, if any were even consulted,
didn't frame the project as IBM did -- a product joint venture. It's a good
tactic and I don't blame Sourceforge one bit for the opportunity.
Well, since
Vivek Khera [EMAIL PROTECTED] writes:
I run a 24x7x365 db on FreeBSD which has *never* crashed in the 3
years it has been in production. Only downtime was the upgrade from
PG 7.1 to 7.2 and once for a switchover from RAID5 to RAID10.
I would be interested to know what backup strategy you
Online backups with archived transaction logs are the next big killer feature
(the last one remaining?) for 24x7 operation I think.
I believe this is at least theoretically possible using Linux device layer
tricks. Using network block devices, you can have a network RAID1, with
the transaction
Don't think of this as a troll, because I really don't know, even
though I do know that MVS, OpenVMS Solaris can. (I won't even
ask about toys like Windows and FreeBSD.)
What so toy in Windows?
With some experience on huge DBs,
one on Windows ( MS SQL 2K ) works x1.5/2 faster, than one on
11 matches
Mail list logo