I want to understand how Postgres organizes data and handles IO
operations so that I will better know how to optimize a Postgres
database server. I am looking for answers to specific questions and
pointers to where this stuff is documented.
How does Postgres organize its data? For example, is it
I upgrade from PG 7.1.3 to 7.2, and I am trying to restore my dbs but I
keep getting:
[nsadmin@roam backup-20020622]$ pg_restore all-good.dmp
pg_restore: [archiver] input file does not appear to be a valid archive
---(end of broadcast)---
TIP 2:
Tom Lane wrote:
That really should be impossible --- it says that a rename() failed for
a file we just created.
I judge from the spelling of the error message that you are running 7.1.
7.1.3
However, given that you state a system reboot is necessary and
sufficient to make the problem go
Tom Lane wrote:
James Thornton [EMAIL PROTECTED] writes:
I am not running NFS on this system.
Oh well, scratch that theory. Perhaps you should tell us what you *are*
running --- what OS, what hardware? I still believe that this must be
a system-level bug and not directly Postgres
Postmaster is eating my CPU -- see ps and top output at
http://jamesthornton.com/misc/postgres.txt or below (it wraps too much
when posting to Google, but my server keeps getting overloaded).
As you can see from the ps output, there are several INSERT statements
-- these return after restarting