On 16.03.2011 17:09, Kevin Grittner wrote:
Tambet Matiisen wrote:
Pre-live database is restored from live database dump every night.
How is that done? A single pg_dump of the entire live database
restored using psql? Are both database servers at the same
PostgreSQL version?
Yes, I use pg
On Thu, Mar 17, 2011 at 12:07 AM, Euler Taveira de Oliveira
wrote:
> Em 16-03-2011 12:25, Frederic Junod escreveu:
>>
>> "Error: Invalid line 502 in /etc/postgresql/8.4/main/postgresql.conf:
>> »listen_addresses '*'«"
>>
> AFAICS it is a Debian bug not a PostgreSQL one. I already hit it once but
On 16.03.2011 22:29, Kevin Grittner wrote:
Tambet Matiisen wrote:
Yes, I use pg_dump on live server and the result is
rdiff-backupped into development server. Whole SQL dump is 12G
without compression and the rdiff delta is about 10-20MB every
day. Then I drop pre-live database on development s
Excerpts from Daniel Popowich's message of mar ene 18 13:30:04 -0300 2011:
> I traced the bug to PLy_result_slice() in src/pl/plpython/plpython.c. That
> function calls the python API function PyList_GetSlice() and erroneously
> increments the reference count before returning the result to the ca
The following bug has been logged online:
Bug reference: 5935
Logged by: Brad Nicholson
Email address: bnichol...@hp.com
PostgreSQL version: 9.0.3
Operating system: CentOS Release 5.5
Description:Log lotation not working for default log format
Details:
PostgreSQL 9.
What would you expect the new log file to be named? Your log_filename is set
to postgresql-%a.log. The %a part expands to the current day of the week. If
it's Thursday and you already have a file for Thursday, what would the new file
name be?
-- Korry
> The following bug has
You could appending something onto the logfile to differentiate it, but I can
understand why you wouldn't want to as that would change the filename format.
If this is the case, the call to pg_rotate_logfile() should return false.
I'd also say that starting up and allowing a file size based rotat
> You could appending something onto the logfile to differentiate it, but I can
> understand why you wouldn't want to as that would change the filename format.
>
> If this is the case, the call to pg_rotate_logfile() should return false.
pg_rotate_logfile() doesn't actually rotate the log file,