X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 15A09D1D313 for ; Wed, 11 Feb 2004 11:30:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62804-03 for ; Wed, 11 Feb 2004 07:29:46 -0400 (AST) Received: from linux.griegspo.com.br (wall.griegspo.com.br [200.212.93.130]) by svr1.postgresql.org (Postfix) with SMTP id 47CE2D1B4DE for ; Wed, 11 Feb 2004 07:29:42 -0400 (AST) Received: (qmail 9267 invoked by uid 505); 11 Feb 2004 12:28:32 -0000 Received: from paulorz@grieg.com.br by mailspo.griegbr.com.br by uid 502 with qmail-scanner-1.16 (uvscan: v4.2.40/v4244. Clear:. Processed in 0.498096 secs); 11 Feb 2004 12:28:32 -0000 Received: from unknown (HELO paulorz) (172.16.12.3) by linux.griegspo.com.br with SMTP; 11 Feb 2004 12:28:32 -0000 Reply-To: From: "Paulo Rogerio Zimolo" To: Subject: Dumping from version 7.3.4 to 7.4.1 Date: Wed, 11 Feb 2004 09:28:29 -0300 Message-ID: MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0024_01C3F081.6877B970" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/185 X-Sequence-Number: 12359 This is a multi-part message in MIME format. ------=_NextPart_000_0024_01C3F081.6877B970 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0025_01C3F081.687AC6B0" ------=_NextPart_001_0025_01C3F081.687AC6B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I'm trying to do pg_dump an old version (7.3.4) to a new one (7.4.1) with the following command: pg_dump -U username -h server -i -o database | psql -U username -h newserver newdatabase As a result I got: pg_dump: server version:PostgreSQL 7.3.4 on i586-pc-linux-gnu, compiled by GCC 2.95.3; pg_dump version:7.2 pg_dump: proceeding despite version mismatch pg_dump: query to obtain list of data types failed error: attribute "typprtlen" not found" What is this attribute? Am I doing something wrong? Is there any better way to dump the database to another version? Any help will be welcome Many thanks Paulo Zimolo ------=_NextPart_001_0025_01C3F081.687AC6B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I'm trying to do pg_dump = an old version (7.3.4) to a new one (7.4.1) with= the=20 following command:
 
    pg_dump -U username -h server -i -o database | ps= ql -U=20 username -h newserver newdatabase
 
As a result I got:
 
    pg_dump: server=20 version:PostgreSQL 7.3.4 on i586-pc-linux-gnu, compiled by GCC=20 2.95.3;
    pg_dump version:7.2
    pg_dump: proceeding despite v= ersion=20 mismatch
 
    pg_dump: query to = obtain=20 list of data types failed
    error: attribute= =20 "typprtlen" not found"
 
What is this  attribute?<= /DIV>
Am I doing something wrong?
Is there any better way to dump the d= atabase=20 to another version?
 
Any help will be welcome
 
Many=20 thanks
Paulo=20 Zimolo

 
------=_NextPart_001_0025_01C3F081.687AC6B0-- ------=_NextPart_000_0024_01C3F081.6877B970 Content-Type: image/jpeg; name="Notebook.jpg" Content-Transfer-Encoding: base64 Content-ID: <351480112@11022004-08f1> /9j/4AAQSkZJRgABAgEASABIAAD/7QSyUGhvdG9zaG9wIDMuMAA4QklNA+kA AAAAAHgAAwAAAEgASAAAAAADBgJS//f/9wMPAlsDRwUoA/wAAgAAAEgASAAA AAAC2AIoAAEAAABkAAAAAQADAwMAAAABJw8AAQABAAAAAAAAAAAAAAAAYAgA GQGQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4QklNA+0AAAAA ABAASAAAAAEAAQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoA AAAAAAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2Zm AAEAbGZmAAYAAAAAAAEAL2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYA AAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklNA/gAAAAAAHAAAP////////// //////////////////8D6AAAAAD/////////////////////////////A+gA AAAA/////////////////////////////wPoAAAAAP////////////////// //////////8D6AAAOEJJTQQAAAAAAAACAAA4QklNBAIAAAAAAAIAADhCSU0E CAAAAAAAEAAAAAEAAAJAAAACQAAAAAA4QklNBAkAAAAAAqIAAAABAAAAgAAA AAIAAAGAAAADAAAAAoYAGAAB/9j/4AAQSkZJRgABAgEASABIAAD//gAnRmls ZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcKggNC4wAP/uAA5BZG9iZQBk gAAAAAH/2wCEAAwICAgJCAwJCQwRCwoLERUPDAwPFRgTExUTExgRDAwMDAwM EQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwBDQsLDQ4NEA4OEBQODg4U FA4ODg4UEQwMDAwMEREMDAwMDAwRDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM DAwMDP/AABEIAAIAgAMBIgACEQEDEQH/3QAEAAj/xAE/AAABBQEBAQEBAQAA AAAAAAADAAECBAUGBwgJCgsBAAEFAQEBAQEBAAAAAAAAAAEAAgMEBQYHCAkK CxAAAQQBAwIEAgUHBggFAwwzAQACEQMEIRIxBUFRYRMicYEyBhSRobFCIyQV UsFiMzRygtFDByWSU/Dh8WNzNRaisoMmRJNUZEXCo3Q2F9JV4mXys4TD03Xj 80YnlKSFtJXE1OT0pbXF1eX1VmZ2hpamtsbW5vY3R1dnd4eXp7fH1+f3EQAC AgECBAQDBAUGBwcGBTUBAAIRAyExEgRBUWFxIhMFMoGRFKGxQiPBUtHwMyRi 4XKCkkNTFWNzNPElBhaisoMHJjXC0kSTVKMXZEVVNnRl4vKzhMPTdePzRpSk hbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2JzdHV2d3h5ent8f/2gAMAwEAAhED EQA/APROif0Kv6X81T9Lj+ar/m/5K0F8rJJIfqlJfKySKn6pSXyskkp+qUl8 rJJKfqlJfKySSn6pSXyskkp+qUl8rJJKfqlJfKySSn//2ThCSU0EBgAAAAAA BwABAAAAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBBZG9iZSBQaG90b3Nob3Co IDQuMAD/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgNCQ0VDAwVGhQQFBogGxoa GyAiFxcXFxciEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM AQ0NDREOERsRERsUDg4OFBQODg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwM DAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAYBaADASIAAhEBAxEB/90ABABa /8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEBAQAA AAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVB UWETInGBMgYUkaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRF wqN0NhfSVeJl8rOEw9N14/NGJ5SkhbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2 N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQACEQMhMRIEQVFhcSIT BTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RF VTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dn d4eXp7fH/9oADAMBAAIRAxEAPwCv0T+n4/8AxrP+qavW15J0U/r+P/xrP+qa vWg8eKElsWSHZfXWYe4A+ZUMjIFTJBE/Fc1kXbg63mJP+amk0uesGqdc19Su p2ZrLmWGQxwLR4B35v8A0V0qKlJJJIqUkkkkpSSSSSlJJJJKUkkkkpSSSSSl JJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkk kpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJ JJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkk pSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJ JJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkp SSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJ JKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpS SSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSn/0J9G6oKn04zKKXOdYA6x 7d1kOP8Ag/3Hs/MXY/sOl/0hYfCT/wCQavnZJArQ/S1HTXVN21+weYa7/vqz croeQ+Q3XcYOn/mbF89pIaJfpboXRK+k1uDQPUsILyONPotZ/JatRfKqSSX6 qSXyqkip+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp +qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl 8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6 qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp +qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl 8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn/2Q== ------=_NextPart_000_0024_01C3F081.6877B970--