Thread: [Windows] Pg_Restore on 8.1.5 and so on...

I am trying to restore from a pg_dump.  Pg_restore is doing some
strange behaviour.

If I open a CMD shell console and execute pg_restore, nothing is
showed.  If I try to do a "with sense" pg_restore, nothing is showed in
spite of I have put --verbose option.

This is my complete command:

pg_restore --verbose --file=c:\dbt.dump --host=127.0.0.1
--username=masteruser --password

Somebody with the same behaviour ?.  I am running 8.1.5 on a Windows XP
sp2 workstation.

Thanks in advance.

--

Terry Yapt wrote:

> I am trying to restore from a pg_dump.  Pg_restore is doing some
> strange behaviour.
>
> If I open a CMD shell console and execute pg_restore, nothing is
> showed.  If I try to do a "with sense" pg_restore, nothing is showed
> in spite of I have put --verbose option.
>
> This is my complete command:
>
> pg_restore --verbose --file=c:\dbt.dump --host=127.0.0.1
> --username=masteruser --password
>
> Somebody with the same behaviour ?.  I am running 8.1.5 on a Windows
> XP sp2 workstation.
>
> Thanks in advance.


Same behaviour on 8.2 rc1.


--

Terry Yapt wrote:

> Terry Yapt wrote:
>
> > I am trying to restore from a pg_dump.  Pg_restore is doing some
> > strange behaviour.
> >
> > If I open a CMD shell console and execute pg_restore, nothing is
> > showed.  If I try to do a "with sense" pg_restore, nothing is showed
> > in spite of I have put --verbose option.
> >
> > This is my complete command:
> >
> > pg_restore --verbose --file=c:\dbt.dump --host=127.0.0.1
> > --username=masteruser --password
> >
> > Somebody with the same behaviour ?.  I am running 8.1.5 on a Windows
> > XP sp2 workstation.
> >
> > Thanks in advance.
>
>
> Same behaviour on 8.2 rc1.

Any help would be very appreciated.

--

Terry Yapt wrote:

> Terry Yapt wrote:
>
> > Terry Yapt wrote:
> >
> > > I am trying to restore from a pg_dump.  Pg_restore is doing some
> > > strange behaviour.
> > >
> > > If I open a CMD shell console and execute pg_restore, nothing is
> > > showed.  If I try to do a "with sense" pg_restore, nothing is
> > > showed in spite of I have put --verbose option.
> > >
> > > This is my complete command:
> > >
> > > pg_restore --verbose --file=c:\dbt.dump --host=127.0.0.1
> > > --username=masteruser --password
> > >
> > > Somebody with the same behaviour ?.  I am running 8.1.5 on a
> > > Windows XP sp2 workstation.
> > >
> > > Thanks in advance.
> >
> >
> > Same behaviour on 8.2 rc1.
>
> Any help would be very appreciated.

Solved.

You must use psq frontend with a plain pg_dump file.

It is on documentation/manual.  :-(

Sorry.

--