Re: [GENERAL] Cannot start the postgres service

2009-10-15 Thread Mitesh51
Let me clarify bit more so I can do thing in proper manner... I take base backup(full). at fixed interval I need to take incremental backup and for that... I use following commands. psql -U postgres -c select pg_switch_xlog() psql -U postgres -c SELECT pg_stop_backup() after that the WAL

Re: [GENERAL] Cannot start the postgres service

2009-10-14 Thread Scott Marlowe
On Tue, Oct 13, 2009 at 11:24 PM, Craig Ringer cr...@postnewspapers.com.au wrote: 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?. Not that anyone wants to discourage exploring. It's just there are

Re: [GENERAL] Cannot start the postgres service

2009-10-14 Thread Mitesh51
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

Re: [GENERAL] Cannot start the postgres service

2009-10-14 Thread Scott Marlowe
On Tue, Oct 13, 2009 at 11:40 PM, Mitesh51 mit_b...@yahoo.com wrote: 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

Re: [GENERAL] Cannot start the postgres service

2009-10-14 Thread Craig Ringer
On 14/10/2009 2:29 PM, Scott Marlowe wrote: On Tue, Oct 13, 2009 at 11:24 PM, Craig Ringer cr...@postnewspapers.com.au wrote: 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?. Not that anyone

Re: [GENERAL] Cannot start the postgres service

2009-10-14 Thread Alvaro Herrera
Mitesh51 wrote: 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 Postgres is prepared to (and assumes it can) reuse

Re: [GENERAL] Cannot start the postgres service

2009-10-13 Thread John R Pierce
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. well, then don't move any file from pg_xlog while postgres is running! (was there a question here?) -- Sent via

Re: [GENERAL] Cannot start the postgres service

2009-10-13 Thread Scott Marlowe
On Tue, Oct 13, 2009 at 12:14 AM, John R Pierce pie...@hogranch.com 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. well, then don't move any file from pg_xlog while

Re: [GENERAL] Cannot start the postgres service

2009-10-13 Thread Mitesh51
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.

Re: [GENERAL] Cannot start the postgres service

2009-10-13 Thread Craig Ringer
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

[GENERAL] Cannot start the postgres service

2009-10-12 Thread Mitesh51
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 -