Re: Need Database Backup - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Need Database Backup
Date
Msg-id CAOR=d=1RykJbCBJLnHpQTsnH+9+S-+bbhW24pFNJcdiJ8NfA3w@mail.gmail.com
Whole thread Raw
Responses Re: Need Database Backup
Re: Need Database Backup
List pgsql-general
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.

Specifically, what are you doing to try and load the .sql extension?
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.
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.

On Sun, Aug 30, 2015 at 3:39 AM, Murali N Rao <muralihw03@rediffmail.com> wrote:
Sir,

Suddenly Our system got restarted and we got a msg NTLDR Missing. I tried to repair but not able.

OS: windows 2003 Server

We installed the PGSQL in D:\program files\Postgresql

I have whole folder having capacity of 1.53 GB

and i have recently taken backup on 01st of August with Extension (.sql) even i cant upload that.

Please i request u to do the need ful

Regards

Murali N
System Admin,
CIT, Gubbi


From: Scott Marlowe <scott.marlowe@gmail.com>
Sent: Sun, 30 Aug 2015 09:34:42
To: muralihw03@rediffmail.com
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Need Database Backup
On Fri, Aug 28, 2015 at 11:27 PM, Murali N Rao
<muralihw03@rediffmail.com> wrote:

> Sir,
>
> We were using newgenlib software which is having postgresql as backend.
>
> Suddenly Our Systems OS got corrupted and unable to start and we have taken installed folder as backup from the drive but we are unable to restore and kindly help in this.
>
> and also we have also taken backup 30 days in .sql format but even i am unable to upload.
>
> So, i kindly request u to help in this as the database contains more than 2000 Students data
>

OK let's see what we can do to help you. What OS are you running? How
idd you move the database directory to the new machine? What errors
are you getting when you to start the db? What errors are you getting
when trying to restore from your old .sql backup? What version of
pgsql are you running?

Just kinda imagine one of us is looking over your shoulder and tell us
everything. Details that may seem small and unimportant can be very
important in helping to troubleshoot this kind of thing.

Get your own FREE website, FREE domain & FREE mobile app with Company email.  
Know More >



--
To understand recursion, one must first understand recursion.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Need Database Backup
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: Need Database Backup