Re: Backup questions
От | Jason Tesser |
---|---|
Тема | Re: Backup questions |
Дата | |
Msg-id | 04875CB4331F0240A0AD66F970978651011379FB@paul обсуждение исходный текст |
Ответ на | Backup questions ("Jason Tesser" <JTesser@nbbc.edu>) |
Ответы |
Re: Backup questions
|
Список | pgsql-general |
Does anyone know what is going on with my 2nd question below? > -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of Jason Tesser > Sent: Thursday, July 29, 2004 11:09 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Backup questions > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: