From: | Steve Doerr <sdoerr(at)swbell(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Restore question |
Date: | 2002-08-06 04:06:22 |
Message-ID: | 3D4F4B3E.4010602@swbell.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I've recently had to restore a couple of db's from backup and there were
obsolete employee tables in the dbs.
Now I can't drop or rename this or any other tables to properly load new
ones.
sqltest=# drop table employee
sqltest-#
I used pg_dump on the two dbs, and restored with the following:
psql -f /home/steve/080502sltestdb.out sqltest
Psql is also broken for the next command after one of these failed drops
(when it's showing the - instead of =):
sqltest-# select * from employee;
ERROR: parser: parse error at or near "select"
try again and:
sqltest=# select * from employee;
id | employee_id | name | addr1 | addr2 | addr3 | workphone |
homephone | grade | title_position | salary | salarytype |
exemptcode | gov_id | email | startdate | enddate | notes
Does anyone recognize what's broken here or know what I might be able to
do to fix it?
Thanks for any assistance.
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-08-06 04:12:50 | Re: Restore question |
Previous Message | Mauro | 2002-08-05 23:32:45 | Installing Postgres |