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