Re: Need Database Backup - Mailing list pgsql-general

Hi

I agree with all upthreads mentioning that the amount of information you (Murali) deliver is much too little to help.
Neverthelessmy thoughts. 

- NTLDR Missing is obviously a Windows problem and I don't think that it has to do with PostgreSQL. You may find better
helpon a Windows forum or mailing list. 
- If you have produced a SQL file dumping your whole clusterv (pg_dumpall), then you should only need to reinstall
PostgreSQLand run the file as a script (from command line or psql). There is no upload of sql file, unless I don't
understandwhat you mean. 

Bye
Charles

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Scott Marlowe
Sent: Sonntag, 30. August 2015 15:36
To: muralihw03@rediffmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need Database Backup

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
Windowsguy.) 
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
folkswho 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
messaround 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
butwe 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.