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
Hi All,
I am facing an error on executing the below command
dump name: pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing
databae name: pnqd_test
$pg_restore -U postgres -p 5433 -d pnqd_test
pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing
pg_restore: [archiver (db)] Error while PROCESSING
On Dec 13, 2007 10:06 PM, Kevin Kempter <[EMAIL PROTECTED]> wrote:
> Hi list;
>
> We're seeing this error whern trying to restore a pg_dump file:
>
>
> -
> pg_restore: ERROR: invalid byte seque
Am Donnerstag, 13. Dezember 2007 18.06:23 schrieb Kevin Kempter:
> Hi list;
>
> We're seeing this error whern trying to restore a pg_dump file:
>
> ---
>-- pg_restore: ERROR: invalid byte sequence f
Hi list;
We're seeing this error whern trying to restore a pg_dump file:
-
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0x9f CONTEXT:
COPY log_customer_api, line 4551 pg_res
After running pg_dumpall on my database cluster like this:
$PGBIN/pg_dumpall -c -U ipscdb | gzip > /var/db/pgsql_bkp/pg_dump_file.gz
I subsequently delete the PGDATA directory for the backed up database and
initialize a new database. Next I attempt to run the restore using
initialized data
, but a
stable production system should be relatively OK. Just my experience anyway.
regards
Iain
- Original Message -
From: "Lee Wu" <[EMAIL PROTECTED]>
To: "Düster Horst" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 1:39 AM
: Friday, October 29, 2004 7:52 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] pg_restore error
OK, the manual talk about this solution, but I do have more than 2000
objects in my DB. What is the reason that pg_dump/pg_restore are not able to
create an correct order ob DB objects with respect to
OBS because the
> restauration of single objects will not restore BOLBS.
>
> Horst Düster
>
> -Ursprüngliche Nachricht-
> Von: Vishal Kashyap @ [Sai Hertz And Control Systems]
> [mailto:[EMAIL PROTECTED]
> Gesendet am: Freitag, 29. Oktober 2004 11:33
> An: Düs
g, 29. Oktober 2004 11:33
An: Düster Horst
Cc: [EMAIL PROTECTED]
Betreff: Re: [ADMIN] pg_restore error
Hi
I thought, that pg_restore will organize the restore-prozess in an optimal
order. This seems not work correct!!?? I would be grateful to hear any
hints.
pg_restore does not priortize till n
üster
-Ursprüngliche Nachricht-
Von: Vishal Kashyap @ [Sai Hertz And Control Systems]
[mailto:[EMAIL PROTECTED]
Gesendet am: Freitag, 29. Oktober 2004 11:33
An: Düster Horst
Cc: [EMAIL PROTECTED]
Betreff: Re: [ADMIN] pg_restore error
Hi
> I thought, that pg_restore will organize the restore-pr
Hi
> I thought, that pg_restore will organize the restore-prozess in an optimal
> order. This seems not work correct!!?? I would be grateful to hear any
> hints.
pg_restore does not priortize till now idealy it must be like
restoring the functions >> tables >> views >> seqences so on...
This
Hallo
I try to restore a large DB with BLOBS. I created the dump file with:
pg_dump -Fc -b > dump.file
During the restore process startet with the following command:
pg_restore -d dump.file
the process breakes with the error message that a table couldn't be found.
So I started the pg_restore
Hallo
I dumped a database with large objects with the command pg_dump -Fc -b
dbname > dbname.dmp
To restore the DB I use pg_restore -d newdb dbname.dmp.
The restore process breakes with the following error message:
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"tablename"
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
>> There are a lot of situations where pg_dump fails to pick a safe reload
>> order at the moment (that's why pg_restore has that wild and woolly set
>> of options for manual adjustment of the reload order).
> Is this considered a bug, or a generally a
> You could check this by running pg_restore with query logging
> turned on, to see what commands it's actually issuing -- or just do
> "pg_restore -s" into a text file and eyeball the generated script.
I did this, and there is a view created before the table it refers to.
> There are a lot of
On Mon, 2002-12-02 at 14:47, Nick Fankhauser wrote:
> Apparently my first problem is the result of plpgsql already being defined
> in template1. I haven't touched template1 since my install, but it may be
> that template1 comes with this already defined, or it may be that template1
> is set up thi
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> It appears that in the process of creating the schema, pg_restore attempted
> to create an object that required the existence of actor, which wasn't
> restored yet. My conjecture is that the objects are just being created in
> the wrong order.
Probab
Hi-
Thanks for the helpful suggestions on this problem last Wednesday morning- I
spent the rest of the day in a meeting, and I'm now returning to the problem
post-holiday. I apologize for the slow response to your ideas.
Tom- You were correct, I was restoring the wrong database in my example with
If I have to take a guess, it is that you have a language defined in
template1 (and hence in the new db) or in the database you are loading
into and that is conflicting with the load of the dump.
---
Nick Fankhauser wrote:
>
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> We've never touched template1, but just to make sure, I tried using
> template0 to ensure an empty DB with the same results:
> nickf@morgai:~$ createdb -D PG_ALPHA -T template0 test
> CREATE DATABASE
> nickf@morgai:~$ pg_restore -dalpha test.dump.ta
On Wed, 2002-11-27 at 14:28, Nick Fankhauser wrote:
> Oliver-
>
> Thanks for the idea. Unfortunately, it still won't go.
>
> We've never touched template1, but just to make sure, I tried using
> template0 to ensure an empty DB with the same results:
Does the same happen with a plain text dump (r
Oliver-
Thanks for the idea. Unfortunately, it still won't go.
We've never touched template1, but just to make sure, I tried using
template0 to ensure an empty DB with the same results:
nickf@morgai:~$ createdb -D PG_ALPHA -T template0 test
CREATE DATABASE
nickf@morgai:~$ pg_restore -dalpha tes
On Wed, 2002-11-27 at 13:16, Nick Fankhauser wrote:
> Hi-
>
> I'm trying to do a dump & restore of a complete database using tar archive
> format. I've previously used the text dump approach, so I'm very new to this
> method.
>
> I created the dump using:
>
> pg_dump -Ft alpha > alpha.dump.tar
>
Hi-
I'm trying to do a dump & restore of a complete database using tar archive
format. I've previously used the text dump approach, so I'm very new to this
method.
I created the dump using:
pg_dump -Ft alpha > alpha.dump.tar
I'm trying to restore into an empty db using:
pg_restore -d alpha2
31 matches
Mail list logo
