On 03/08/12 4:09 PM, Frank Church wrote:
What are the commands to accomplish that, ie getting PostgreSQL to
erase the logs?
there's two completely different sorts of logs here. 'transaction
logs' in postgres are the write-ahead logs, these are binary files used
internally by postgres, in th
On 8 March 2012 16:23, Guillaume Lelarge wrote:
> On Thu, 2012-03-08 at 10:18 +, Frank Church wrote:
> > How do you purge the postgresql transaction log?
> >
>
> You don't. PostgreSQL does it for you.
>
> > I am creating a virtual machine image and I want to erase any transaction
> > logs tha
On Thu, Mar 8, 2012 at 10:18 AM, Frank Church wrote:
> How do you purge the postgresql transaction log?
>
> I am creating a virtual machine image and I want to erase any transaction
> logs that got built up during development. What is the way to do that?
pg_resetxlog
> I am currently using 8.3 a
On Fri, 2012-03-09 at 00:09 +, Frank Church wrote:
>
>
> On 8 March 2012 16:23, Guillaume Lelarge
> wrote:
> On Thu, 2012-03-08 at 10:18 +, Frank Church wrote:
> > How do you purge the postgresql transaction log?
> >
>
>
> You don't. Post
one ultra dummy way would be to dump, back up, destroy the data dirs,
and any human /var/log files and then re-initdb and restore.
On Πεμ 08 Μαρ 2012 12:18:17 Frank Church wrote:
> How do you purge the postgresql transaction log?
>
> I am creating a virtual machine image and I want to erase any t
On Thu, 2012-03-08 at 10:18 +, Frank Church wrote:
> How do you purge the postgresql transaction log?
>
You don't. PostgreSQL does it for you.
> I am creating a virtual machine image and I want to erase any transaction
> logs that got built up during development. What is the way to do that?
How do you purge the postgresql transaction log?
I am creating a virtual machine image and I want to erase any transaction
logs that got built up during development. What is the way to do that?
I am currently using 8.3 and 8.4.
Is there the possibility that the logs saved in /var/log also contai
