Re: troubled by pg_dump and pg_restore

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Tena Sakai <sakaitena(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: troubled by pg_dump and pg_restore
Date: 2010-05-18 23:20:53
Message-ID: AANLkTilV7fYkvcYmMzHT2H87oafT8638YISrkADOUej6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 18, 2010 at 5:14 PM, Tena Sakai <sakaitena(at)yahoo(dot)com> wrote:

>
> Can someone please tell me (1) if there is anything wrong with my
> invocation
> of pd_dump? (I want to generate a file pd_restore can use to feed to
> musket database.) (2) Why pg_restore wouldn't give me listing? And (3)
> why the second pg_restore command is upset?
>

Someone please correct me if I'm wrong, but I believe -l only makes sense in
the context of a dump created with -Fc. For SQL format dumps, I usually
just cat or \i them into psql.

rls

--
:wq

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-05-18 23:24:52 Re: troubled by pg_dump and pg_restore
Previous Message Tena Sakai 2010-05-18 23:14:49 troubled by pg_dump and pg_restore