Search Postgresql Archives

Re: Cannot start the postgres service

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux