Postgres Pro
Downloads
Home   >   mailing lists

Re: Database recovery. - Mailing list pgsql-general

From Waqar Azeem
Subject Re: Database recovery.
Date
Msg-id AANLkTi==Z85kYHmSVd2zto=mjfCcbL0q=LmL2N_KO3x9@mail.gmail.com
Whole thread Raw
In response to Database recovery.  (Waqar Azeem <waqarazeem.private@gmail.com>)
Responses Re: Database recovery.
Re: Database recovery.
Re: Database recovery.
List pgsql-general
Tree view 
I copy the whole folder 'Data' to another PC where fresh postgresql 8.4 is installed (same as default config. that previous version have had)



when i started the server got following ... 

The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
The service did not report an error.
More help is available by typing NET HELPMSG 3534.
The start command returned an error (2)
Press <return> to continue...

any clue?


On 03/24/11 12:07 AM, Waqar Azeem wrote:
My XP is crashed and now I have to take a full backup of my postgresql 8.4
I am used to get backup of ldf/mdf files in case of SQLServer

Please let me know the right way of doing this for postgresql 8.4.


you need everything in the $PGDATA directory. On my system here, itsD:\Postgres\8.4\data but of course, your mileage may vary.

On Thu, Mar 24, 2011 at 12:07 PM, Waqar Azeem <waqarazeem.private@gmail.com> wrote:
My XP is crashed and now I have to take a full backup of my postgresql 8.4

I am used to get backup of ldf/mdf files in case of SQLServer

Please let me know the right way of doing this for postgresql 8.4.

-- 
Thanks & Best Regards,
Waqar Azeem



-- 
Thanks & Best Regards,
Waqar Azeem

		
	


	

					

					





	

	pgsql-general by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	"Altmann, Sebastian"

	Date:
	



	Subject:
	Re: [RMX:#] Re: Strange loss of data during INSERT
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Karsten Hilbert

	Date:
	



	Subject:
	Re: Database recovery.