From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, muralihw03(at)rediffmail(dot)com, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need Database Backup |
Date: | 2015-08-30 14:13:53 |
Message-ID: | CANu8FiwabytMX0ZYSMOpfvHiZJbuUr0tBZG_SkCUKGxOigsQkQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-08-30 14:21:14 | Re: Need Database Backup |
Previous Message | Adrian Klaver | 2015-08-30 14:06:03 | Re: Need Database Backup |