From: | Art Fore <art(dot)fore(at)comcast(dot)net> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: backup-restore does not work |
Date: | 2005-02-09 04:39:08 |
Message-ID: | 420993EC.1090609@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Tried a refresh again and the table and views were gone. Then the
restore worked. I do not understand why I do a refresh after dropping
the table and views, they are still there, then a little later, do a
refresh, they are gone. WHY?
How does one do an update to a table that is completely changed other
than dopping it and restoring it? Seems like there should be an easier
way that backup-restore.
Art
Art Fore wrote:
> Using PGadminIII, I backup my database on linux machine (Postgresql
> 7.4), and try to restore it on the windows machine (Postgresql 8.0
> beta5). Alway comes up with duplicate key on the first item. I drop all
> views and the only table in the database and try again. Still same
> thing. I do a refresh, none of the views or table were dropped.
>
> What is the secret of backup-restore is pgadmin?
>
> Art
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-02-09 14:25:28 | Re: backup-restore does not work |
Previous Message | Art Fore | 2005-02-09 04:20:32 | backup-restore does not work |