Thread: Pg_restore on 7.2 from 7.1 under cygwin

Pg_restore on 7.2 from 7.1 under cygwin

From
Don Saxton
Date:

Having restored to 7.2 under cygwin from a 7.1 cygwin on another computer, I
get this chilling response to \dt from psql:
"less:not found", I had hoped for more...

The pg_dump was
pg_dump -b -Fc gbap | gzip > gbap.gz

The pg_restore was
gzip -c -d | pg_restore -c -d gbap -v

I had created gbap database before the restore.

The pg_restore seems to happily complete, although it doesn't end with
anything I could call a confirmation, except the return to cygwin prompt.
It's when I try to "psql gbap" and either \dt or select * from any table
that I expect, that I get "less: not found".

I have searched and read every posting on pg_restore without finding
anything like this.  Could I have screwed up something before the restore in
the postges 7.2 install? It seemed to create the database well.
thanks.


Re: Pg_restore on 7.2 from 7.1 under cygwin

From
Oliver Elphick
Date:
On Wed, 2002-03-13 at 02:12, Don Saxton wrote:

> The pg_restore seems to happily complete, although it doesn't end with
> anything I could call a confirmation, except the return to cygwin prompt.
> It's when I try to "psql gbap" and either \dt or select * from any table

'less' is a pager program, like 'more' but with more capabilities.  Just
tell psql to use a different pager:

  $ PAGER=more psql ...

or install 'less'.


According to the psql man page, 'more' is used by default, but this no
longer seems to be the case.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Who is like Thee among the gods, O Lord? Who is like
      Thee, majestic in holiness, awesome in praises,
      working wonders?"
                              Exodus 15:11


Re: Pg_restore on 7.2 from 7.1 under cygwin

From
Don Saxton
Date:
Thanks Oliver.
installing 'less' fixed it up.
> 'less' is a pager program, like 'more' but with more capabilities.  Just
> tell psql to use a different pager:
>
>   $ PAGER=more psql ...
>
> or install 'less'.
>
>
> According to the psql man page, 'more' is used by default, but this no
> longer seems to be the case.