Re: [GENERAL] Restore problem
On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote: > We are running 8.1 on Windows 2003 server and have had a server crash > over the weekend. A virus is suspected - we maintain an app server on > someone else's network, though we do have anti-virus running, the > symptoms were worrying - so we had to wipe and reinstall the OS and all > programs. We had recovered the 8.1 folder and the data off the crashed > computer prior to the wipe, but the last good .backup file is a few days > older than that. > > Are there step by step instructions on restoring from the folder itself > instead of a backup file? Is it even possible? Trevor Talbot wrote: >I would try installing 8.1 again, stop the service, _copy_ your data >and config over the top of it, then start it again and see what >happens. Any problems with that should show up immediately in the >logs. >And if all else fails, you can just nuke the attempt and restore from >the older backups. I did this - it took a couple of tries, but it worked. For the record, here's a description of the problem and solution: Problem (before I became involved): Someone had turned off RPC service while trying to fix something. Someone else rebooted the server and all the windows services failed on restart. Panicked and suspecting a virus they reinstalled the OS, but had the wit to savethe postgres folders but couldn't make a .backup file. And the last backup file was the night before, and they had done a lot of work that would be lost if that was used. Solution: It wasn't a simple matter of just copying over the data folder. There are reasons having to do with not letting the client see you sweat and to do it in the BG. So on a fresh system we did as suggested above, copied over the files. One step that seems to be required (at least in this case) was a clean new install of postgres, stopping it immediately after the install, not one that had been used in any way. Required: The postgres files from the crashed server. Step 1. Clean install of same version of Postgres (8.1) on second computer using same superuser and password. Step 2. Stop postgtres service Step 3. Copy over Data folder replacing the one that was created on install Step 4. Start postgres Step 5. Log in to pgadmin, confirm that the data is there Step 6. Create a .backup that can be restored on the live site. Step 7. Create the database on the live site and restore from the .backup file. Thanks for your suggestion. We had tried it and failed, but this reinforced that it might work, so we then tried with a fresh install as well, and were delighted to have our data back. Regards, Keith ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Hijack!
Thank you for your response. What may be obvious to some isn't always to others. It's never a bad idea to remind users how you want your data formatted if there are roadblocks that are not obvious on the surface. Thanks again... K. -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 6:58 AM To: Keith Turner Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Hijack! Keith Turner wrote: > Someone scolding wrote: > > Please don't hijack other threads, the original thread was 'TIMESTAMP > difference'. I think it was probably intended as a *gentle* scolding. We try to be as polite as possible on the PG lists. Particularly important given their international nature of course. > (don't answer to an arbitrary other mail and change the subject. Every > mail contains references-header) Yep - Thunderbird (for example) threads messages by this header. Your original question was hidden two layers down and I'd never have seen it if I hadn't been reading the one you replied to. That's the reason why people say not to do it - if you reply to an existing question many people will miss yours. > I apologize; I had assumed that the threads were simply grouped by > subject. If this is such a problem, probably it should be laid out on > the list information page, otherwise how is anyone to know? It's one of those "common knowledge" things that are obvious to everyone who's done it once themselves. It's just part of the nature of how email works. Google around "mailing list etiquette" and you should see plenty of guidelines. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] Hijack!
Someone scolding wrote: Please don't hijack other threads, the original thread was 'TIMESTAMP difference'. (don't answer to an arbitrary other mail and change the subject. Every mail contains references-header) I apologize; I had assumed that the threads were simply grouped by subject. If this is such a problem, probably it should be laid out on the list information page, otherwise how is anyone to know? Putting this information here would be a good thing: http://www.postgresql.org/community/lists/ Keith (not scolding, but Hijack is an accusative term)
[GENERAL] Restore problem
Hi first post here, I hope you can help. We are running 8.1 on Windows 2003 server and have had a server crash over the weekend. A virus is suspected - we maintain an app server on someone else's network, though we do have anti-virus running, the symptoms were worrying - so we had to wipe and reinstall the OS and all programs. We had recovered the 8.1 folder and the data off the crashed computer prior to the wipe, but the last good .backup file is a few days older than that. Are there step by step instructions on restoring from the folder itself instead of a backup file? Is it even possible? Thanks, Keith ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/