Pg_restore on 7.2 from 7.1 under cygwin
Pg_restore on 7.2 from 7.1 under cygwin
От:
Don Saxton <euphobot@pacbell.net>
Дата:
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
От:
Oliver Elphick <olly@lfix.co.uk>
Дата:
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
От:
Don Saxton <euphobot@pacbell.net>
Дата:
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.