Best unofficial Apache Server developers community

Answers

Postgresql log files

⇧

⇩

55 views

hey guys ,

I'm running postgresql 8.4 on ubuntu server. I realiszd that my disk is out of space because the log file had became too huge. Can I adjust what gets written to the log file?

postgresql

asked January 16, 2011 10:48 pm CST

amateur

posted via StackOverflow

1 Answers

⇧

⇩

Edit /etc/postgresql/8.4/main/postgresql.conf and change or disable the various log_* parameters. Then reload.

You might also want to check what gets written to the logs. By default, there should be that much logging. Possibly, your application is throwing lots of errors, which are being logged.

answered January 21, 2011 2:37 am CST

Peter Eisentraut

Your answer

Similar discussion threads

When to use postgreSQL
January 4, 2011 09:37:57 AM
Hi guys, Our company is looking into the possibility of using it. Firstly, we would like to find out what kind of applications are suitable for using postgreSQL. From the internet, it seems like it is good for web development. Is it true ? And…

iPad and Postgresql...
January 16, 2011 06:35:13 PM
Hi, I have an iPad and a small network of macs and fedora/windoze machines at home. I am running pg 8.4.4 on all of the 'real' computers. I have been hoping that some developer would create an iPad app that would allow me to access my home…

Postgresql 9 connection problem
December 26, 2010 11:41:52 PM
I have very strange problem with my application, upon occasions I get following error when connecting to postgres. This happens without any pattern, often happens when I run some extensive tests in my application. Unable to connect to PostgreSQL…

How to delete databases from PostGreSQL?
January 4, 2011 08:23:54 AM
Hi there, I have around 10 databases in my PostGreSQL database, but i want to delete some of those im not using. I've looked, but i have no clue how to delete them? Can you give me any information or a guideline to make this possible for a…

Re: Does Skype outage have anything to do with PostgreSQL?
January 4, 2011 03:25:43 AM
Mladen Gogala wrote: > A colleague of mine told me that he read somewhere that the problem is > actually with Skype's billing database, which is PostgreSQL. Does > anybody have any more information? > This article discusses the…

PostgreSQL refcursor handling
August 25, 2010 02:16:47 AM
I'm trying to help out someone on the PostgreSQL mailing list (and suggested he join this list.) He's trying to return a refcursor from a stored function as shown in an example here: …

MongoDB equivalent to Postgresql LISTEN ?
January 2, 2011 10:08:03 AM
Our system is composed of several servers connected to a MongoDB database. We need a mechanism to allow the application in any of the servers to send events to the applications in the other servers. We are currently inserting a event record in a…

Problem with Clustering Setup (PostgreSQL)
October 28, 2010 07:57:29 AM
Hi, I'm having a problem with a clustered jackrabbit setup, using version 1.6.2 on multiple Tomcats. The Tomcats are using the same repository.xml (see below) and are all started with -Dorg.apache.jackrabbit.core.cluster.node_id=`hostname -s`. I…

password passing between postgresql 8.4 and snort
January 12, 2011 04:35:23 PM
Hi all, I'm running Debian|Squeeze, postgresql8.4, snort and snort-pgsql. The documentation I have read to date suggests that when starting snort it is possible to pass the password for the snort daemon via the commandline. From my…

How to build plperl with PostgreSQL 9 on Windows
January 4, 2011 11:13:26 AM
I has set config.pl to $config->{perl}; 1; and run build.bat, everything is ok, there is plpgsql.dll but don't found plperl.dll. I use strawberry perl 5.10 or must I use ActiveState Perl. Please help me. Thank in advance Tuan Hoang ANh

Can't start ActiveMQ 5.4.2 with PostgreSQL 8.4 as persistence backend
December 13, 2010 12:46:56 PM
Hi. Here is my activemq.xml part for persistence configuration: <persistenceAdapter> <jdbcPersistenceAdapter dataDirectory="${activemq.base}/data" dataSource="#pgsql-ds" /> </persistenceAdapter>…

Implement PostgreSQL full text search
January 12, 2011 03:15:30 AM
Hello everyone. I'm trying to create search with pagination and filters on a website. I stumbled with the search for the words. It could do with ILIKE but the table will have many records, was looking at PostgreSQL full text search, but do not…

Send parameters using Shell script to PostgreSQL
December 27, 2010 02:01:16 PM
Hi.... I'm new using PostgreSQL, and I trying to run a script of shell where I can send parameters to a sentence COPY but always returned an error. This is my sentence in SHELL, where insertar_usuario_archivo.sql contain this sentence SQL: \COPY…

Disable Postgresql startup on boot (Windows XP)
January 4, 2011 09:26:19 PM
Hi. Everytime I boot Windows XP a number of postgres.exe services start and run in the background. As I am only an occasional user of postgresql on my laptop I was wondering how (a) I could disable the auto-start of the service on boot and (b)…

Re: Optimal settings for embedded system running PostgreSQL
January 13, 2011 10:32:01 AM
>

Re: "org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.&q
December 2, 2010 03:26:10 PM
On 12/2/2010 10:18 AM, Emi Lu wrote: >>> Does anyone know what may cause this problem? >>> >>> org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is >>> not yet implemented. >> >> Error…

Re: "org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.&q
December 1, 2010 06:46:42 PM
On 12/1/2010 4:41 PM, Lu Ying wrote: > Good afternoon, > > Does anyone know what may cause this problem? > > org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is > not yet implemented. Error message seems pretty…

Re: Optimal settings for embedded system running PostgreSQL
January 13, 2011 12:39:24 PM
Have you considered switching to embedded Linux instead of XP? This has the potential to help increase performance, as embedded Linux will most likely have a smaller footprint. Give this a read:…

Re: "org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.&q
December 2, 2010 10:14:24 AM
Good morning List, >>> Does anyone know what may cause this problem? >>> org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is >>> not yet implemented. >> >> Error message seems pretty…

Optimal settings for embedded system running PostgreSQL
January 13, 2011 08:13:31 AM
Dear Members, We are currently using PostgreSQL 7.3 on an Embedded System (Based on http://www.msc-ge.com/de/produkte/com/qseven/q7-us15w.html) running Windows XP Embedded / SP3. The onbard flash shows the following performance figures: …

Questions and Answers are licensed under cc-wiki license.

Postgresql log files

1 Answers

Your answer

Join with account you already have