Thread: Pg_restore on 7.2 from 7.1 under cygwin
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.
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
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.