| 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: | Whole Thread | Raw Message | 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.
| 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 |