[GENERAL] pgstat wait timeout

Hello everyone Our system: Windows Server 2008 R2 Foundation PostgreSQL 9.0.1 64 bits Days ago, the following message began to appear in the logs every 50 seconds: 2011-03-15 00:07:06 BRT AVISO: pgstat wait timeout I searched the mailing lists. but couldn't find any useful information. Som

[GENERAL] Continuous recovery stopping

Hi all I have a hot standby replication setup. But for no apparent reason, it stops the recovery. Here is a part of the log: 2011-02-21 11:07:03 BRT LOG: restored log file "00010009001B" from archive 2011-02-21 11:07:33 BRT LOG: restored log file "00010009001C" from a

[GENERAL] Canceling a DELETE query

Hi What are the effects of canceling a DELETE command before it completes execution? Something will be deleted at all? Norberto -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] WAL Archiving Stopped

Em 3/1/2011 18:39, Filip Rembiałkowski escreveu: archiver process will retry later; it never stops trying, sleep time is just longer. 2011/1/3, Norberto Delle: Hi all I have a PostgreSQL 9.0.1 instance, with WAL Archiving. Today, after some failed tries to archive a WAL file, it stopped

[GENERAL] WAL Archiving Stopped

Hi all I have a PostgreSQL 9.0.1 instance, with WAL Archiving. Today, after some failed tries to archive a WAL file, it stopped trying to archive the files, but the number of logfiles in the pg_xlog directory keep growing. Any ideas of what is going on? Norberto -- Sent via pgsql-general mai

Re: [GENERAL] Failover on Windows

Em 1/11/2010 09:00, Fujii Masao escreveu: On Fri, Oct 29, 2010 at 9:58 PM, Norberto Delle wrote: I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2. What command (pg_standby? cp?) is supplied in restore_command for warm-standby? Or you are testing streaming replic

[GENERAL] Failover on Windows

Hi all I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2. The problem is that when I put the trigger file on the location specified in the parameter 'trigger_file' of the recovery.conf, nothing happens. No log entries, the recovery just continues as if nothing has happ

[GENERAL] Trying to stop warm standby server service

Hi all I'm trying to stop the service that controls a warm standby server, but issuing a 'net stop ' command fails to stop the service, however the service appears as stopped on the Services Snap-In. Checking the process tree, I can see that only the pg_ctl.exe process was removed from the roo

Re: [GENERAL] Autovacuum and pg_largeobject

Em 2/7/2010 13:57, Alvaro Herrera escreveu: Excerpts from Norberto Delle's message of vie jul 02 08:10:44 -0400 2010: Hi all I would like to know if the large object table pg_largeobject is routinely checked by the autovacuum daemon. I ask about this because I have a database in wich the pg

[GENERAL] Autovacuum and pg_largeobject

Hi all I would like to know if the large object table pg_largeobject is routinely checked by the autovacuum daemon. I ask about this because I have a database in wich the pg_largeobject table is being forcibly vacuumed because it's relfrozenxid is now greater than autovacuum_freeze_max_age, and

Re: [GENERAL] Could not locate a valid checkpoint record

Em 24/6/2010 11:48, Tom Lane escreveu: Norberto Delle writes: 2010-06-24 09:00:28 PANIC: could not locate a valid checkpoint record I know this error requires you to restore from backup, but, unfortunatelly, we have no backup. There is any way I can recover the data

[GENERAL] Could not locate a valid checkpoint record

Hi all I tried to start a PostgresSQL instance this morning, but it failed. So I checked the log: 2010-06-24 09:00:28 LOG: database system was shut down at 2010-06-24 08:13:58 2010-06-24 09:00:28 LOG: record with zero length at 9/E0E9D200 2010-06-24 09:00:28 LOG: invalid primary checkpo

[GENERAL] Idle in transaction connection

Hi all I have a Postgresql 8.2.10 install running on w2k3, and recently, or more precisely, after I upgraded from 8.2.5 to 8.2.10, some connections keep in the 'idle in transaction' state. The real problem is that even after I kill the connection subprocess, the pg_stat_activity reports that th

Re: [GENERAL] Dump/Restore Large Object OID

Gurjeet Singh wrote: Why not give it a try once? Dump and restore once and see for yourself. You'd have done that by now, but if you haven't do give it a try instead of waiting any more. You may learn a thing or two in the process... On 11/29/07, *Norberto Delle* <[EM

Re: [GENERAL] Dump/Restore Large Object OID

Gurjeet Singh wrote: Why not give it a try once? Dump and restore once and see for yourself. You'd have done that by now, but if you haven't do give it a try instead of waiting any more. You may learn a thing or two in the process... On 11/29/07, Norberto Delle <[EM

[GENERAL] Dump/Restore Large Object OID

Hi all If I don't use the --oids option when dumping a database with pg_dump, can I assure that the "loid" field of the pg_largeobject table will keep it's value when restoring? Thanks in advance Norberto ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] WAL Archiving problem

Tom Lane writes: Norberto Delle <[EMAIL PROTECTED]> writes: I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL archiving activated. But at some point Postgres began to ask to archive a WAL segment that isn't in the pg_xlog directory. I thought that a segment