. There was a deadlock with another process trying to recreate
a table. This caused the dump file to be incomplete.
--
Bryan White
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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 h
I have any results.
> How many cores are available on the new server?
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.
--
Bryan White
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
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
1
It seems to run if I ommit the -j2 option. (Though as of this moment
is has not completed). Is there a known problem with using parallel
loading in 8.4 from a file created with an 8.1 database?
--
Bryan White
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
> Basically, I have a web tracking application that must quickly and
reliably
> store massive amounts of tracking data. Later, I run complex queries to
>
