Received: from falla.videotron.net (falla.videotron.net [205.151.222.106]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA78858 for ; Sat, 22 Jan 2000 13:29:29 -0500 (EST) (envelope-from web@inter-resa.com) Received: from inter-resa.com ([24.200.100.43]) by falla.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FOR002NU20XZV@falla.videotron.net> for pgsql-sql@postgreSQL.org; Sat, 22 Jan 2000 13:29:21 -0500 (EST) Date: Sat, 22 Jan 2000 13:28:10 -0500 From: Web Manager Subject: Repost: restore from dump problem - query buffer full Sender: www@falla.videotron.net To: pgsql-sql@postgreSQL.org Message-id: <3889F6BA.2512B0C@inter-resa.com> Organization: The INTER-Res@ tourism network MIME-version: 1.0 X-Mailer: Mozilla 4.51 [en] (X11; I; FreeBSD 3.1-RELEASE i386) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 8BIT X-Accept-Language: en (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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~