From: | Web Manager <web(at)inter-resa(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | retore from dump problem - query buffer full |
Date: | 2000-01-17 17:45:06 |
Message-ID: | 38835522.9A46EE56@inter-resa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am not an expert with Postgres (version 6.4.2) but I never had a
problem with using pg_dump and rebuilding a database before...
I have this new database working well under the same postgres version.
I make a dump:
pg_dump -d -o -z -f dump_db_name db_name
I then copy the file on my computer. I make:
createdb db_name
psql -f dump_db_name db_name
2 things:
I tried without the -o but I got many error on some tables like:
INSERT INTO "typehotel" values (0,'camping','camping site');
query buffer max length of 20000 exceeded
query line ignored
this db uses sequence for the first time. I read that the dump file
needed -o
So I did that...
the same restore command made:
box:~/data/base>$ psql -f dump_db_name db_name
CREATE TABLE pgdump_oid (dummy int4);
CREATE
COPY pgdump_oid WITH OIDS FROM stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>>
Since I don't know what this is... I put "\."
the file is read...
The result was the same as with no -o
The only difference I see between this new db and the other ones is the
sequence and some text field (quite big).
Any ideas?
Thank's!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Marc Andre Paquin
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-01-17 20:39:35 | Re: [GENERAL] cgi with postgres |
Previous Message | Trevor Astrope | 2000-01-17 17:27:21 | High Availability? |