Re: Need Database Backup

On 08/30/2015 06:36 AM, Scott Marlowe wrote:
> OK we're gonna need to keep this on the list, as other folks may be a
> much better choice to help you than me (I'm not a Windows guy.)
>
> OK so we need more info to help. I don't know how to fix the NTLDR
> problem, etc, because it's windows. However, the folks who might be able
> to help need more info.

What I could find:

https://support.microsoft.com/en-us/kb/816793

>
> Specifically, what are you doing to try and load the .sql extension?

My guess is the OP is using pgAdmin and is trying to restore via the
restore wizard. That only handles custom format backups and not
text(plain) formats.

> Are you using a second machine for this?
> Have you made a backup of the files in d:\Program Files\Postgresql and
> put it in a safe place? It's important to NOT mess around with the only
> copy in case things go wrong with it.

Also, how was Postgres initially installed?

> What exactly HAVE you done to try and move the PostgreSQL directory
> elsewhere? What EXACT errors are you seeing.
>
> The more information you provide the more we can help. Right now you're
> asking for help, but you're not helping yourself, because you're not
> showing us what's going wrong. More details gets you more answers.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com