Thanks very much for the advice, Kevin. I'll be raising a request with our
sysadmins to upgrade to 8.3.10.
Sam
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Saturday, 17 April 2010 1:36 AM
To: Samuel Stearns
Cc: pgsql-admin@postgresql.org
Subject: R
On Sat, Apr 17, 2010 at 5:53 PM, Steve Crawford
wrote:
> Bryan White wrote:
>>
>> ...
>> The new server is a dual socket Nahalem. 8 cores, 16 threads, 48 GB
>> ram, 2 WAL drives in RAID1 and 12 database drives in RAID10.
>>
>
> I would try setting -j higher - in your case try 8 for starters. Also
Bryan White wrote:
...
The new server is a dual socket Nahalem. 8 cores, 16 threads, 48 GB
ram, 2 WAL drives in RAID1 and 12 database drives in RAID10.
I would try setting -j higher - in your case try 8 for starters. Also
turn off fsync and autovacuum (and turn them back on !!!). See these a
> It was unclear from your email how you are creating the dump. Did you create
> the dump with the 8.1 or the 8.4 version of pg_dump? When upgrading, the
> docs recommend using the newer version of the dump utility: "It is
> recommended that you use the pg_dump and pg_dumpall programs from the newe
On Sat, Apr 17, 2010 at 2:46 PM, Tom Lane wrote:
> Bryan White writes:
>> I get this error:
>> pg_restore: [custom archiver] dumping a specific TOC data block out of
>> order is not supported without ID on this input stream (fseek
>> required)
>
> I can't duplicate that here using latest 8.1.x pg
Bryan White writes:
> I get this error:
> pg_restore: [custom archiver] dumping a specific TOC data block out of
> order is not supported without ID on this input stream (fseek
> required)
I can't duplicate that here using latest 8.1.x pg_dump and 8.4.x
pg_restore ... what versions are you using
Bryan White wrote:
I am trying to load a data base using pg_restore.. Is there a known
problem with using parallel
loading in 8.4 from a file created with an 8.1 database?
It was unclear from your email how you are creating the dump. Did you
create the dump with the 8.1 or the 8.4 ver
I am trying to load a data base using pg_restore. We are migrating to
a new server and I want to see if I can make the load go faster if I
load with pg_restore instead of psql.
The old server is:
CentOS upgraded to 5.4 64bit with the stock PostgreSQL 8.1.
The dump file was created with:
pg_d
