Re: Cannot start the postgres service

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(at)postgresql(dot)org)
> 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.