| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Apparent Problem With NULL in Restoring pg_dump |
| Date: | 2011-09-15 20:08:20 |
| Message-ID: | 4E725B34.2020909@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/15/2011 2:38 PM, Rich Shepard wrote:
> On Thu, 15 Sep 2011, Andy Colson wrote:
>
>> Can you pg_dump again, but use --inserts? Maybe it'll offer some hints.
>
> Andy,
>
> Only if I restore /usr/local/pgsql/data/* from the backup tape of a few
> days ago. I need to drop the table before trying to insert it.
>
>> Also, do you have the right line endings for your os?
>
> Well, linux uses only \n, and that's the only environment in which I work.
>
>> To restore, you are using: psql dbname < filename
>> correct?
>
> No, I'm running within pgsql and using the \i option. I can try it from
> the command line before restoring from the backup and trying again.
>
> Rich
>
Ah, I see there was a prior thread about this problem. You said you'd
missed the \. and said it was resolved. So is this a same file or a
different one?
-Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2011-09-15 20:09:07 | Re: Apparent Problem With NULL in Restoring pg_dump |
| Previous Message | Rich Shepard | 2011-09-15 19:38:15 | Re: Apparent Problem With NULL in Restoring pg_dump |