Re: Need Database Backup

You need to recreate the database to reload the data into so

from the windows command line:
C:\PostgresDB\bin\createdb.exe -U postgres <your db name>;

Then to restore the data from the sql backup
C:\PostgresDB\bin\pg_restore.exe -U postgres <the sql backup file>

On Sun, Aug 30, 2015 at 10:06 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.