Postgres WAL Files

⇧

⇩

58 views

Doing a nightly pushout of data from Oracle to Postgres (EnterpriseDB) on multiple machines. Due to the volume of data we are dropping indexes and constraints, pushing the data and then recreating the indexes and constraints.

This process is creating a lot of pg_xlog files (WAL). I am trying to figure out how to get rid of these files before tarring and transferring the database files to multiple remote servers (replication does not work due to some issues with CLOBs).

If I issue a checkpoint and then force a segment switch using pg_switch_xlog, should I be able to delete all but the newest WAL file? Or will I still have to run pg_resetxlog?

postgresql enterprisedb

asked May 5, 2011 7:04 am CDT

user739866

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

OOO and postgres
January 7, 2011 11:47:20 AM
Hi guys I am using the postgres driver for OOO and just ran into the following error: Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: array value must start with "{" or dimension information LINE 1: ...O "public"."Bladetypes" (…

jdbc postgres
June 2, 2010 10:26:11 PM
Hi All, I hope someone can please assist, we are trying to use postgres as a ds for activemq, but we are getting the following error: snip out of activemq-jdbc.xml <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource"> …

postgres problem
February 9, 2011 03:09:30 PM
This is a multi-part message in MIME format. We are using Postgres as the back end for our Java database program and when we reinstalled it, it created the database with an unknown user and no other users. the previous install it created the…

Postgres in FIPS
January 11, 2011 04:27:22 PM
Hello, My organization is in the process of getting a FIPS certification. I was wondering if anyone who has experience with getting their application FIPS certified using postgres. I have read a little bit about this and saw that you need to…

Postgres-9.x - ADODB - PHP
April 6, 2011 02:36:10 PM
My one PHP application stopped working since I upgraded postgres to -9.0.3. It uses the adodb interface. I can addess the postgres back end using psql. How do I determine if I need to update the adodb-php capabilities? And, what options…

Fwd: Postgres forums ... take 2
December 30, 2010 07:20:52 PM
Sorry folks, this is an old message I forgot to copy pgsql-general on. Begin forwarded message: > From: Elliot Chance <elliotc### @gmail.com> > Date: 21 December 2010 11:48:07 AM AEDT > To: Thom Brown <tho### @linux.com> >…

Re: Postgres forums ... take 2
December 30, 2010 07:43:54 AM
On Mon, Dec 20, 2010 at 7:26 PM, Thom Brown <th### @linux.com> wrote: > I know this topic has gone quiet, I still think it's worth investing > time and resources in. I don't expect any progress to be made until > the new year now, but…

Postgres 9.0 + LDAP
April 12, 2011 10:46:50 PM
Hi, I'm trying to get my database to use LDAP for authentication but whenever I'm adding anything LDAP related to pg_hba.conf, postgres won't start properly but shuts down silently without any error messages. Even using the -d flag doesn't help…

Tablespaces Issue in Postgres
February 2, 2011 12:30:12 AM
Dear all, Few days ago I attached a tablespace to one my databases. Say /hdd-1/database_name is the path for the tablespace. When I attach it has a free space of 100 GB. Now my database size grows to 90 GB. I want to prepare for my upcoming …

a question about row estimation in postgres
March 20, 2011 03:14:21 PM
I have a rankings table and it has 1302 rows in total. I am a bit confused by how postgres (8.2.11) calculates the cardinality for this rankings table based on < predicates on gradrate attribute. select histogram_bounds from pg_stats where…

FreeBSD/Postgres/Apache+PHP
March 31, 2011 02:23:02 PM
Hello Postgres Community, Thank you guys very much for PostgreSQL. To me, its the best database management system under the sun. I am setting up a new jail configuration on FreeBSD with sockets and everything enabled. I can ping localhost fine.…

Postgres Start up Error
April 18, 2011 12:31:50 AM
Dear all, Today I by mistake deleted all the contents of pg_log & pg_xlog directory and my Postgresql refuses to start due to the below error :- 2011-04-18 10:51:39 ISTLOG: database system was interrupted; last known up at 2011-04-18…

Auto-Increment in Postgres
February 11, 2011 05:10:37 AM
This is a multi-part message in MIME format.Dear all, I have an Integer column in Postgres database table. Let's say the column has below values : 1 2 3 4 5 6 7 8 9 10 Now if i deleted some rows where id= 3 ,5 and 8 or it have these type …

Swapping Postgres for Derby
June 11, 2010 03:14:49 PM
I asked for a bit of assistance to help me swap out the Derby persistence manager in Sling for a Database backed system. I was advised to look at the OSGi bundles for JDBC drivers and to get a better understanding of how that driver the Felix…

Re: Moving from SQL Anywhere to PostGres - First Time
January 25, 2011 06:22:32 AM
On 2011-01-20, Robert Paresi <firs### @lastname.net> wrote: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > 1. Very Very…

word wrap in postgres
April 12, 2011 11:32:34 AM
Hi all - Is it possible to to split the data of a column into multiple lines. We are have a column which is text. when the query is excecuted, I wanted to display the text of the column in separate lines. Is it possible ? thanks…

Moving from SQL Anywhere to PostGres - First Time
January 20, 2011 11:10:16 AM
Hello, We have 700 user install base using Sybase SQL Anywhere 9.02 We are looking at migrating these installations over to PostGres 1. Very Very Short Answer Please - why should we? 2. Does anyone have a utility or migration application to…

Memory management in Postgres
April 13, 2011 03:07:52 PM
Hello, I'm very interested in PostgreSQL memory management, specially in the concept "memory context". I've read the official documentation at http://www.postgresql.org/docs/8.4/static/spi-memory.html, but I'd like to learn more about it. Do you…

Re: Moving from SQL Anywhere to PostGres - First Time
January 20, 2011 11:56:35 AM
"Robert Paresi" <firs### @lastname.net> writes: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > > 1. Very Very Short…

Issue with postgres connectivity
January 21, 2011 04:52:50 AM
Hello All, I am facing a big problem in postgres connectivity using php application. It is taking almost 10 sec for connection establishment. All my applications were working perfectly 2 days before. Yesterday just it started giving problem. Using…

Questions and Answers are licensed under cc-wiki license.

Postgres WAL Files

0 Answers

Be the first to answer this question

Join with account you already have