Best practice

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

Responses

Browse pgsql-general by date

  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?