Re: [GENERAL] Need Database Backup

2015-08-30 Thread Charles Clavadetscher
To: Adrian Klaver adrian.kla...@aklaver.com Cc: Scott Marlowe scott.marl...@gmail.com; muralih...@rediffmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] Need Database Backup Adrian From Murali N Rao 5:43 AM (4 hours ago) now i have installed new os and installed PGSQL again

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Scott Marlowe
:42 To: muralih...@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 muralih...@rediffmail.com wrote: Sir, We were using newgenlib software which is having postgresql

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Charles Clavadetscher
-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe Sent: Sonntag, 30. August 2015 15:36 To: muralih...@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

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:27 AM, Melvin Davidson wrote: Adrian From Murali N Rao 5:43 AM (4 hours ago) now i have installed new os and installed PGSQL again it working now but no data I plead lack of coffee, but where is that message and was there more in it? On Sun, Aug 30, 2015 at 10:21 AM,

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
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

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
Adrian From Murali N Rao 5:43 AM (4 hours ago) now i have installed new os and installed PGSQL again it working now but no data On Sun, Aug 30, 2015 at 10:21 AM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/30/2015 07:13 AM, Melvin Davidson wrote: You need to recreate the database

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
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

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:13 AM, Melvin Davidson wrote: 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; That assumes Postgres is running, which at this point seems not to be the case or at

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:27 AM, Melvin Davidson wrote: Adrian From Murali N Rao 5:43 AM (4 hours ago) now i have installed new os and installed PGSQL again it working now but no data Aaah, missed that, so Postgres is running, thanks. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
Good catch Adrian, Murali, Please change the restore command to C:\PostgresDB\bin\psql.exe -U postgres -d the database name -f your backup file name On Sun, Aug 30, 2015 at 10:40 AM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/30/2015 07:27 AM, Melvin Davidson wrote: Adrian From

Re: [GENERAL] Need Database Backup

2015-08-29 Thread Adrian Klaver
On 08/28/2015 10:27 PM, Murali N Rao 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.

Re: [GENERAL] Need Database Backup

2015-08-29 Thread Scott Marlowe
On Fri, Aug 28, 2015 at 11:27 PM, Murali N Rao muralih...@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

[GENERAL] Need Database Backup

2015-08-29 Thread Murali N Rao
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