| From: | "Jason Tesser" <JTesser(at)nbbc(dot)edu> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Backup questions |
| Date: | 2004-07-29 16:09:07 |
| Message-ID: | 04875CB4331F0240A0AD66F970978651160AFB@paul |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have 2 questions.
1. What is the best way to back up a production box running Postgres
nightly?
2. I thought the best way was to create a script that would use pg_dump
to
create a dump every night and then use restore if I need to. I did this
but
I am having a problem. Apparently there were a few Primary key Big
Serial
fields that had the name changed on them after they were created. The
backup works fine but during the restore it fails because it thinks
a relation is missing. Before restoring the database with the changed
fields works fine, I just cannot get it to restore. Is there something
in the background that Postgres is hanging on to after I renamed the
fields that is preventing me from restoring? How can I work around
this?
Thank you
Jason Tesser
Software Development
NMI 715-324-6900 x5273
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tesser | 2004-07-29 16:14:09 | Backup questions |
| Previous Message | Doug McNaught | 2004-07-29 16:07:42 | Re: Question about linux filesystem and psql |