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>
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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
