[GENERAL] Un successful Restoration of DATA using WAL files

I am unable to restore data with the use of WAL files by following procedure. I have done following changes in postgres.conf to enable WAL archiving... archive_mode = on # allows archiving to be done archive_command = 'copy %p C:\\archivedir\\%f' I have one database(built

Re: [GENERAL] Cannot start the postgres service

to restore data from the full backup but havn't done anything to restore data from the WAL files...Hopefully I will find the way...If u can emphasize somewhere then it will be a gr8 help :) Please correct me if I am wrong somewhere :) Alvaro Herrera-7 wrote: Mitesh51 wrote: I had 2 approach in my

Re: [GENERAL] Cannot start the postgres service

not from the pg_xlog thus it will be a another direction for solution of inc backup. Moving of files is done my postgres as well so I guess, from the archive dir we can do that. Craig Ringer wrote: On 13/10/2009 2:59 PM, Mitesh51 wrote: Yeah... My query is...Is it the reason y postgres

Re: [GENERAL] Cannot start the postgres service

Yeah... My query is...Is it the reason y postgres stops working?? (Moving files from pg_xlog) John R Pierce wrote: Mitesh51 wrote: If I move any file from the \PostgreSQL\8.4\data\pg_xlog\ then postgres services are stopped I cannot start them. I need to reinstall the postgres

[GENERAL] Cannot start the postgres service

If I move any file from the \PostgreSQL\8.4\data\pg_xlog\ then postgres services are stopped I cannot start them. I need to reinstall the postgres. -- View this message in context: http://www.nabble.com/Cannot-start-the-postgres-service-tp25867194p25867194.html Sent from the PostgreSQL -

[GENERAL] WAL handling issue.

When I set archive_mode = on # allows archiving to be done # (change requires restart) archive_command = 'copy %p C:\\archivedir\\%f' # command to use to archive a logfile segment in postgres...WAL files are created. But I am not

Re: [GENERAL] How to reduce WAL file Size

up lot many space. As I am not having DB knowledge I am just assuming that it will create problems in terms of storage space. That is my concern. If you will explain this thing then it will help me in a good way :) Thank you. Alban Hertroys-3 wrote: On 8 Oct 2009, at 9:35, Mitesh51 wrote

[GENERAL] How to reduce WAL file Size

By setting postgres.conf params...log files are generated of 16 MB each. How can I reduce the size of this files? can I force the log files to switch with any command as we do in mysql like flush log? where we force the new log creation ? -- View this message in context: