Pg_restore on 7.2 from 7.1 under cygwin - Mailing list pgsql-admin

From Don Saxton
Subject Pg_restore on 7.2 from 7.1 under cygwin
Date
Msg-id 06b801c1ca34$789fe720$3225aa40@pacbell.net
Whole thread Raw
Responses Re: Pg_restore on 7.2 from 7.1 under cygwin  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-admin

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.


pgsql-admin by date:

Previous
From: "Gill, Jeffrey L"
Date:
Subject: client connection
Next
From: Oliver Elphick
Date:
Subject: Re: Pg_restore on 7.2 from 7.1 under cygwin