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
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
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
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
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
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
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
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
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.
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
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 -
11 matches
Mail list logo