From: | geustace(at)godzone(dot)net(dot)nz |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Best practice |
Date: | 2001-04-20 10:41:20 |
Message-ID: | 20010419222120.8A3441B46B@agree-6.godzone.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Now that 7.1 has arrived, I would appreciate some feed back on the
following comments.
We use Ingres where I work and when setting up a server we always
try to ensure that the log and data files are on different spindles.
From both experience and advice from CAI, one can always recover a
database after a hardware failure or system crash, if any two of the
following are in good condition
Backup, Logfile, Datafiles.
I know that PostgreSQL isn't Ingres but there must be some useful
experiences from both experts and users alike. Is there any recommended
'placement' for the respective postgresql files.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-04-20 10:48:36 | Re: problems with pg_dumplo (was Re: backup with blobs) |
Previous Message | Peter T Mount | 2001-04-20 10:37:21 | Re: Storing Photographs in Postgres? |