pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_xlog
10+ messages / 8 participants
[nested] [flat]
* pg_xlog
@ 2001-06-20 05:05 Jie Liang <jliang@ipinc.com>
0 siblings, 0 replies; 10+ messages in thread
From: Jie Liang @ 2001-06-20 05:05 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql@postgresql.org; pgsql-admin
Tom,
Since our disk is filled full so fast,
Does logs under pg_xlog can be deleted and how to turn off it??
Thanks.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.stbernard.com
www.ipinc.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_xlog
@ 2004-07-07 10:31 Leszek.Dukwicz@brebank.com.pl
2004-07-07 11:34 ` Re: pg_xlog Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-07-07 15:32 ` Re: pg_xlog Scott Marlowe <smarlowe@qwest.net>
0 siblings, 2 replies; 10+ messages in thread
From: Leszek.Dukwicz@brebank.com.pl @ 2004-07-07 10:31 UTC (permalink / raw)
To: pgsql-admin
Hi,
Could you please send me an advice how to configure Postgres database
With non standard pg_xlog directory location i.e. on other (non db) physical
disk ???
Leszek Dukwicz
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2004-07-07 10:31 pg_xlog Leszek.Dukwicz@brebank.com.pl
@ 2004-07-07 11:34 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
1 sibling, 0 replies; 10+ messages in thread
From: Sam Barnett-Cormack @ 2004-07-07 11:34 UTC (permalink / raw)
To: Leszek.Dukwicz@brebank.com.pl; +Cc: pgsql-admin
On Wed, 7 Jul 2004 Leszek.Dukwicz@brebank.com.pl wrote:
> Hi,
>
> Could you please send me an advice how to configure Postgres database
>
> With non standard pg_xlog directory location i.e. on other (non db) physical
> disk ???
One word: symlinks.
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2004-07-07 10:31 pg_xlog Leszek.Dukwicz@brebank.com.pl
@ 2004-07-07 15:32 ` Scott Marlowe <smarlowe@qwest.net>
1 sibling, 0 replies; 10+ messages in thread
From: Scott Marlowe @ 2004-07-07 15:32 UTC (permalink / raw)
To: Leszek.Dukwicz@brebank.com.pl; +Cc: pgsql-admin
On Wed, 2004-07-07 at 04:31, Leszek.Dukwicz@brebank.com.pl wrote:
> Hi,
>
> Could you please send me an advice how to configure Postgres database
>
> With non standard pg_xlog directory location i.e. on other (non db)
> physical disk ???
Easy:
su - postgres
pg_ctl stop
cd $PGDATA
mkdir /mnt/drive2/pg_xlog
cp -p pg_xlog/* /mnt/drive2/pg_xlog/
mv pg_xlog pg_xlog_old
ln -s /mnt/drive2/pg_xlog pg_xlog
pg_ctl start
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_xlog
@ 2008-12-18 01:50 Naomi Walker <nwalker@eldocomp.com>
2008-12-18 02:40 ` Re: pg_xlog Naomi Walker <nwalker@eldocomp.com>
0 siblings, 1 reply; 10+ messages in thread
From: Naomi Walker @ 2008-12-18 01:50 UTC (permalink / raw)
To: pgsql-admin
Everyone,
-
The guys on one of our servers deleted a table and need the data from
it. Somehow, our backup job did not run.
We have the pg_xlog that should (may) contain the deleted data. We
need to know if there is a way to extract the
records that were deleted from the file and write them back into the
table. Is there a way to retrieve the data from
the pg_xlog?
This is a server running x86 Solaris 10, postgres 8.2.4.
Naomi
--
------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc nwalker@eldocomp.com
---An EDS Company 602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2008-12-18 01:50 pg_xlog Naomi Walker <nwalker@eldocomp.com>
@ 2008-12-18 02:40 ` Naomi Walker <nwalker@eldocomp.com>
0 siblings, 0 replies; 10+ messages in thread
From: Naomi Walker @ 2008-12-18 02:40 UTC (permalink / raw)
To: pgsql-admin
I think i'll answer my own question, after. Since this is a write ahead
log, the only thing contained would be the "Drop Table"
statement. Since there are many databases in this instance, we would
have to restore the instance somewhere else, replaying
until just before the drop, then extract what we need.
Sigh.
Naomi
> Everyone,
>
> -
>
> The guys on one of our servers deleted a table and need the data from
> it. Somehow, our backup job did not run.
> We have the pg_xlog that should (may) contain the deleted data. We
> need to know if there is a way to extract the
> records that were deleted from the file and write them back into the
> table. Is there a way to retrieve the data from
> the pg_xlog?
>
> This is a server running x86 Solaris 10, postgres 8.2.4.
>
>
> Naomi
>
>
>
>
>
>
>
>
--
------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc nwalker@eldocomp.com
---An EDS Company 602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_xlog
@ 2010-02-11 22:09 Albert Shih <Albert.Shih@obspm.fr>
2010-02-11 22:20 ` Re: pg_xlog Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-02-11 22:24 ` Re: pg_xlog Joshua D. Drake <jd@commandprompt.com>
0 siblings, 2 replies; 10+ messages in thread
From: Albert Shih @ 2010-02-11 22:09 UTC (permalink / raw)
To: pgsql-admin
Hi all
How can I clean up the pg_xlog directory ?
I've 710 go of those file.
I've archive_mode on but not in the pg_xlog directory
I've something like
archive_mode = on # allows archiving to be done
archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'
so can I just do
postgresql stop
rm f pg_xlog/*
postgresql start
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Jeu 11 fév 2010 23:06:32 CET
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2010-02-11 22:09 pg_xlog Albert Shih <Albert.Shih@obspm.fr>
@ 2010-02-11 22:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-02-11 22:43 ` Re: pg_xlog Albert Shih <Albert.Shih@obspm.fr>
1 sibling, 1 reply; 10+ messages in thread
From: Kevin Grittner @ 2010-02-11 22:20 UTC (permalink / raw)
To: Albert Shih <Albert.Shih@obspm.fr>; pgsql-admin
Albert Shih <Albert.Shih@obspm.fr> wrote:
> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on # allows archiving to be done
> archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'
It will keep each WAL file until your archive command which is
supposed to copy it completes with an exit code of zero. It sounds
like that's not happening. What does that destination directory
look like? What messages are you seeing in your log files?
> so can I just do
>
> postgresql stop
> rm f pg_xlog/*
> postgresql start
No.
-Kevin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2010-02-11 22:09 pg_xlog Albert Shih <Albert.Shih@obspm.fr>
2010-02-11 22:20 ` Re: pg_xlog Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-02-11 22:43 ` Albert Shih <Albert.Shih@obspm.fr>
0 siblings, 0 replies; 10+ messages in thread
From: Albert Shih @ 2010-02-11 22:43 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit
> Albert Shih <Albert.Shih@obspm.fr> wrote:
>
> > How can I clean up the pg_xlog directory ?
> >
> > I've 710 go of those file.
> >
> > I've archive_mode on but not in the pg_xlog directory
> > I've something like
> >
> > archive_mode = on # allows archiving to be done
> > archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'
>
> It will keep each WAL file until your archive command which is
> supposed to copy it completes with an exit code of zero. It sounds
> like that's not happening. What does that destination directory
> look like? What messages are you seeing in your log files?
>
Thanks for the help
In fact you right, they are some problem about the copy (wrong owner of the
/WAL directory), so the WAL is not copied. That's why I got ... 45000 files
in the pg_xlog.
Thanks for your help.
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Téléphone : 01 45 07 76 26/06 86 69 95 71
Heure local/Local time:
Jeu 11 fév 2010 23:42:11 CET
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_xlog
2010-02-11 22:09 pg_xlog Albert Shih <Albert.Shih@obspm.fr>
@ 2010-02-11 22:24 ` Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 10+ messages in thread
From: Joshua D. Drake @ 2010-02-11 22:24 UTC (permalink / raw)
To: Albert Shih <Albert.Shih@obspm.fr>; +Cc: pgsql-admin
On Thu, 2010-02-11 at 23:09 +0100, Albert Shih wrote:
> Hi all
>
> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on # allows archiving to be done
> archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'
>
> so can I just do
>
> postgresql stop
> rm f pg_xlog/*
No.
> postgresql start
>
> Regards.
I strongly suggest using something like walmgr or pitrtools to manage
this. Walmgr is part of skytools, pitrtools can be found here:
https://projects.commandprompt.com/public/pitrtools
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2010-02-11 22:43 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-20 05:05 pg_xlog Jie Liang <jliang@ipinc.com>
2004-07-07 10:31 pg_xlog Leszek.Dukwicz@brebank.com.pl
2004-07-07 11:34 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-07-07 15:32 ` Scott Marlowe <smarlowe@qwest.net>
2008-12-18 01:50 pg_xlog Naomi Walker <nwalker@eldocomp.com>
2008-12-18 02:40 ` Naomi Walker <nwalker@eldocomp.com>
2010-02-11 22:09 pg_xlog Albert Shih <Albert.Shih@obspm.fr>
2010-02-11 22:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-02-11 22:43 ` Albert Shih <Albert.Shih@obspm.fr>
2010-02-11 22:24 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox