Re: Orbitz dumps RAC for better reliability

Hello?? He reboot the machine without shutting down the database or had a system crash. I have done this on test machines many times and came back without data corruption, however. Also use a journaling file system or use Postgresql replication. The newer versions of PGSQL are better than ever and only getting better. I don't think this was a PGSQL issue at all. Having run PGSQL for 2 1/2 years with PGSQL acting as a database   for syslog and apache logs for many machines, I have never experienced curruption or failure. It is rock solid. I am sure .ORG will tell you the same.

He also was not doing WAL http://www.postgresql.org/docs/7.3/static/wal.html

A few smart things like journaling FS, WAL and UPS with isolation transformers can go a long way in mitgating stupid problems.

Orville wrote:
> Truth in advertising.
>
> Postgresql.
> The free database for the business whose data is worth
> even less.
>
> Customer testimonials:
> "100% of the data was gone!"
>
> Support and service:
> This is the only article in this thread
>
> The full story here:
>
> http://groups.google.com/groups?selm=a8uqet%241vr7%241%40jupiter.hub.org
>
> Subject: database crash w/missing data [urgent]
> This is the only article in this thread
> View: Original Format
> Newsgroups: comp.databases.postgresql.general
> Date: 2002-04-09 06:31:17 PST
>
> Hello,
> Yesterday I had a crash that cost me a week's worth of data.
> Please not this may not be the fault of postmaster, but I'm
> still in a bad way. We had some network problems and had
> to reboot the computer, using /sbin/reboot. When the computer
> started up and we ran the postmaster startup script, all of
> our databases were acting funny.
>
> 100% of the data was gone! From the shell if you went
> select * from company, postgres reports 0 tuples! (but returns
> the schema). The funny thing was, if you went \d company, I
> would get the message 'relation company does not exist'. Also,
> \d would not list the relations. This was true for all the
> relations for all the databases.
>
> Please not I was running fsync off for this database.
>
> Because this database was running our customer management
> system, I had no choice but to restore from backup.
>
> Is there any possibility of restoring the missing data?
Received on Thu Jul 17 2003 - 22:26:23 CDT