pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Web Manager <web@inter-resa.com>
To: pgsql-sql@postgreSQL.org
Subject: Repost: restore from dump problem - query buffer full
Date: Sat, 22 Jan 2000 13:28:10 -0500
Message-ID: <3889F6BA.2512B0C@inter-resa.com> (raw)
(nobody could help me a week ago... any new volunteers?)
Hello,
I am not an expert with Postgres (version 6.4.2) but I never had a
problem with using pg_dump on a remote server and rebuilding a local
database before...
I have this new database working well under the same postgres version
(server side).
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
I.T. supervisor
Le Réseau Touristique INTER-Rés@
The INTER-Res@ tourism network
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message-ID: <3889F6BA.2512B0C@inter-resa.com> Permalink: ../3889F6BA.2512B0C@inter-resa.com/ Also on: postgresql.org/message-id/3889F6BA.2512B0C@inter-resa.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-sql@postgresql.org Cc: web@inter-resa.com Subject: Re: Repost: restore from dump problem - query buffer full In-Reply-To: <3889F6BA.2512B0C@inter-resa.com> References: <3889F6BA.2512B0C@inter-resa.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox