Pg_restore on 7.2 from 7.1 under cygwin

From: Don Saxton <euphobot(at)pacbell(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Pg_restore on 7.2 from 7.1 under cygwin
Date: 2002-03-13 02:12:04
Message-ID: 06b801c1ca34$789fe720$3225aa40@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Drew Lopucki 2002-03-13 05:22:11 Superuser can't log in after changing 'trust' in pg_hba.conf
Previous Message Gill, Jeffrey L 2002-03-13 01:33:32 client connection