Hi, I like that "why on earth are you messing about with the data directory when you don't understand what it does and how it works?" Actully I am not a DB person and having almost ZERO knowledge abt it but I am working on an application which takes backup(full & incremental) of diff DB like mysql, postgres... Now I dont have any support who helps me on DB side & still I need to move on with my java code so in current situation I am trying my hands on the DB backups as well since none else has that knowledge so I am doing it by searching on my own :) I had 2 approach in my mind...to sync up transaction log files with specific full backup 1) to keep only time relavent files in pg_xlog dir and move other files to archive dir with code which is not a good idea as u suggest 2) to copy files from pg_xlog & archive dir(which is used by archive_command) and move files from the archive dir & 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 stops working?? (Moving files >> from >> pg_xlog) > > pg_xlog contains transaction logs. These aren't "log files" in the sense > of text logs designed for the administrator to use. They're part of the > critical function of the database and they're what permits Pg to support > transactional rollback, safe crash recovery, point-in-time recovery, and > lots more. > > Deleting them or moving them is just as bad for your database as > deleting or moving the files that store tables. It's a really, really > bad idea. > > A better question might by "why on earth are you messing about with the > data directory when you don't understand what it does and how it works?". > > -- > Craig Ringer > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/Cannot-start-the-postgres-service-tp25867194p25885603.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
