Skip site navigation (1) Skip section navigation (2)

Re: psql won't accept pg_dump

From: Michael Hipp <Michael(at)Hipp(dot)com>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql won't accept pg_dump
Date: 2004-11-08 21:37:51
Message-ID: 418FE72F.6050601@Hipp.com (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:

> Michael Hipp <Michael(at)Hipp(dot)com> writes:
> 
>>######### CASE #1
>>psql:test.psql:18: ERROR:  unrecognized configuration parameter 
>>"default_with_oids"
> 
> Apparently you're trying to use an 8.0 pg_dump with a 7.4 backend.
> 
> 
>>######### CASE #2
>>psql:test.psql:42: ERROR:  invalid input syntax for type timestamp: 
>>"2004-10-30
>>21:11:00  501   so3   Test Sat morning  CMH   2004-10-30 11:11:43.25 
>>michael  unknown"
>>CONTEXT:  COPY dailylog, line 1, column enttime: "2004-10-30 21:11:00 
>>501   so3
>>    Test Sat morning  CMH   2004-10-30 11:11:43.25  michael  unknown"
> 
> This looks to me like something has changed the tab separators between
> columns into spaces.
> 
> 			regards, tom lane

You were right on both counts. Thank you!

Michael


In response to

pgsql-admin by date

Next:From: David BearDate: 2004-11-08 22:36:26
Subject: using oids as primary keys and foreign keys
Previous:From: Carlos LopezDate: 2004-11-08 21:28:41
Subject: Re: [PERFORM] poor performance in migrated database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group