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.kla...@aklaver.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.kla...@aklaver.com > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.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.
