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.
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 |