Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 291E22E2EC6 for ; Fri, 28 Dec 2007 23:49:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74342-01 for ; Fri, 28 Dec 2007 23:48:59 -0400 (AST) Received: from weatherbeeta.com.au (unknown [218.214.212.154]) by postgresql.org (Postfix) with ESMTP id 354E52E2ED3 for ; Fri, 28 Dec 2007 23:48:57 -0400 (AST) Received: (qmail 27556 invoked from network); 29 Dec 2007 03:48:54 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;26c508e46a01769daf3f5cb9238cdb63; Received: from mail.weatherbeeta.com.au (10.20.0.2) by network-box.weatherbeeta.com.au with SMTP; 29 Dec 2007 03:48:54 -0000 Received: (qmail 17346 invoked by uid 1166); 29 Dec 2007 14:48:54 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.2386 secs); 29 Dec 2007 03:48:54 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.2386 secs Process 17337) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 29 Dec 2007 14:48:53 +1100 From: "Phillip Smith" To: "'Tom Lane'" Cc: Subject: Re: Restoring pg_dump Backup with psql Fails Date: Sat, 29 Dec 2007 14:48:53 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <004b01c849cd$badabd80$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_004C_01C84A29.EE4B3580" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 In-Reply-To: <27312.1198895166@sss.pgh.pa.us> Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1198900134.836-27550-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.03/0.06 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.23 tagged_above=0 required=5 tests=AWL=-0.330, BAYES_20=-0.74, RDNS_NONE=0.1, SARE_BAYES_5x7=0.6, SARE_BAYES_6x7=0.6 X-Spam-Level: X-Archive-Number: 200712/238 X-Sequence-Number: 27755 This is a multi-part message in MIME format. ------=_NextPart_000_004C_01C84A29.EE4B3580 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Sorry Tom - I should know better :) I've attached the first 512 lines of the output from psql. The whole output is 3mb. Cheers, ~p > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Saturday, 29 December 2007 13:26 > To: Phillip Smith > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Restoring pg_dump Backup with psql Fails > > "Phillip Smith" writes: > > But I get a whole bunch of errors, for example: > > > > ERROR: syntax error at or near "all" > > LINE 1: all orders over $400.00 - freight free Order 10 of any produ... > > ^ > > Please show us the *first* few errors, not some randomly chosen ones. > The above looks like a COPY has failed and psql has started thinking > that copy-data lines are commands, but how or why that happened is > not in evidence. > > regards, tom lane THINK BEFORE YOU PRINT - Save paper if you don't really need to print this *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments e-mail. ------=_NextPart_000_004C_01C84A29.EE4B3580 Content-Type: text/plain; name="errors-short.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="errors-short.txt" SET SET SET SET SET COMMENT CREATE LANGUAGE SET CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT SET SET CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT SET CREATE TABLE ALTER TABLE COMMENT CREATE SEQUENCE ALTER TABLE setval=20 -------- 1 (1 row) SET CREATE TABLE ALTER TABLE COMMENT CREATE VIEW ALTER TABLE CREATE VIEW ALTER TABLE ERROR: relation "grps" already exists ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT COMMENT COMMENT CREATE TABLE ALTER TABLE COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT SET CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE COMMENT ERROR: relation "stock" already exists ALTER TABLE COMMENT COMMENT ERROR: column "wholesale" of relation "stock" does not exist ERROR: column "discount" of relation "stock" does not exist ERROR: column "hl_wholesale" of relation "stock" does not exist ERROR: column "tax_rate" of relation "stock" does not exist CREATE TABLE ALTER TABLE COMMENT ERROR: column s.supplier_code does not exist LINE 2: ... g.category, s.grp, s.brand, s.style, s.supplier, = s.supplier... ^ ERROR: relation "public.stock_full_detail" does not exist CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT COMMENT COMMENT COMMENT COMMENT CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT ERROR: invalid byte sequence for encoding "UTF8": 0x96 HINT: This error can also happen if the byte sequence does not match = the encoding expected by the server, which is controlled by = "client_encoding". CONTEXT: COPY dwh_cust, line 7413 ERROR: invalid byte sequence for encoding "UTF8": 0xe86d65 HINT: This error can also happen if the byte sequence does not match = the encoding expected by the server, which is controlled by = "client_encoding". CONTEXT: COPY dwh_stk, line 323461 ERROR: column "use_barcodes" of relation "grps" does not exist invalid command \ invalid command \ Query buffer reset (cleared). invalid command \nOrders Query buffer reset (cleared). invalid command \n Query buffer reset (cleared). invalid command \n ERROR: syntax error at or near "2007" LINE 1: 2007-08-02 13:16:53.246734+10 28qgb1b6qv7kckgbj2gd2at626 roc... ^ ERROR: syntax error at or near "ID" LINE 1: ID=3D52a2e4941b1b10e7a8575a39fc50f184 true [[B]]=20 ^ ERROR: syntax error at or near "ID" LINE 1: ID=3D52a2e4941b1b10e7a8575a39fc50f184 true [[B]]=20 ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:13:33.285839+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:13:50.308025+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:13:54.394821+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:03.776806+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:06.657096+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:10.704989+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:15.003735+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:17.253273+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:18.64996+10 ovur6bbsklbmsa8ee1ilkpdor3 nath... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:20.186421+10 ovur6bbsklbmsa8ee1ilkpdor3 nat... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:22.202408+10 li0iig5tuajls26cqj37psa132 kar... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:23.477619+10 li0iig5tuajls26cqj37psa132 kar... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-22 11:14:30.680531+10 li0iig5tuajls26cqj37psa132 kar... ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "s_cc" LINE 1: s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:47:39.118013+10 r8sslpmo4tuhsdetl3agc4ji83 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:47:40.337277+10 r8sslpmo4tuhsdetl3agc4ji83 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:47:41.384364+10 r8sslpmo4tuhsdetl3agc4ji83 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:48:06.469591+10 6j319di6vt4erjkva4l000kik7 roc... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:48:26.936489+10 r8sslpmo4tuhsdetl3agc4ji83 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-08-28 16:51:34.442362+10 6j319di6vt4erjkva4l000kik7 roc... ^ ERROR: syntax error at or near "ID" LINE 1: ID=3D52a2e4941b1b10e7a8575a39fc50f184 s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage%7E%5B1%5D; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "[" LINE 1: [[B]]=20 ^ Query buffer reset (cleared). invalid command \n ERROR: syntax error at or near "2007" LINE 1: 2007-09-06 16:00:52.318355+10 s9a7slqt1bjf54vm3cc3798mv7 roc... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] true 8/2007 s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-09-11 16:44:38.081365+10 t88omkoa2v774b3uvbmpa5fuj6 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] true 8/2007 s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-09-11 16:44:39.588316+10 t88omkoa2v774b3uvbmpa5fuj6 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] true 8/2007 s_cc=3Dtrue; ^ ERROR: syntax error at or near "s_refresh" LINE 1: s_refresh=3DHomepage; ^ ERROR: syntax error at or near "s_sq" LINE 1: = s_sq=3Dpaypalglobal%3D%2526pid%253DHomepage%2526pidt%253D1%252... ^ ERROR: syntax error at or near "2007" LINE 1: 2007-09-11 16:44:47.444287+10 t88omkoa2v774b3uvbmpa5fuj6 nat... ^ ERROR: syntax error at or near "[" LINE 1: [[B]] true 8/2007 s_cc=3Dtrue; ------=_NextPart_000_004C_01C84A29.EE4B3580--