On 11-04-13 12:37 PM, Kevin Grittner wrote:
Eric Comeau wrote:
We currently have statement timeout set
statement_timeout = 1080 # 3 hrs
and we receive the following in the postgresql.log
[1-1] ERROR: canceling statement due to statement timeout
Is there a way to have the
Alanoly Andrews writes:
> Hello,
>
> Is it possible to set up a warm standby pair of postgres instances
> without using the pg_standby utility? The PG manuals appear to say it
> is possible. But I dont see the details of how to set this up. How
> do you keep the standby instance in permanent reco
On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews wrote:
> Thanks, Simon, for your quick response. I'll try it out with your pg_standby
> utility. And...if I may ask you one more question on the subject, once the
> standby is up and running, is there a way to determine whether it is in synch
>
Hi,
I just noticed this thread today.
I am running 9.0.3. I Read the 20110408 upgrade fix announcement, checked
pg_clog/ and noticed that it show only a single file.
I understand I may be hit by the mentioned problem.
Yes, I do have all tar archives available, but since my Database is
re
"Carlos Sotto Maior (SIM)" wrote:
> If I run a database wise 'vacuum freeze' and all goes well does it
> means I do not have to take any action?
If you run it in all databases except template0, and it doesn't
generate any errors, you are good.
> Dumping and recreating the data base would be
Hi, list
We're attempting to change the version string for a Postgres Plus instance
to sort of trick a standard Postgres ODBC driver into connecting to the
pgplus instance. I know there is a postgres plus ODBC driver out there,
but, while I don't know the specifics of why, it's currently not bei
Sam Nelson writes:
> Hi, list
>
> We're attempting to change the version string for a Postgres Plus
> instance to sort of trick a standard Postgres ODBC driver into
> connecting to the pgplus instance. Â I know there is a postgres
> plus ODBC driver out there, but, while I don't know the specific
On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote:
> Simon Riggs writes:
> > 2011/4/13 Tom Lane :
> >> Short answer is to test the case you have in mind and see.
>
> > That's the long answer, not least because the absence of a failure in
> > a test is not conclusive proof that it won't fail at so
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> alter function pg_catalog.version() rename to version_old;
>
> create function pg_catalog.version() returns text
> as $$select 'fake version goes here'::text$$ language sql;;
Alternatively, you could create a public version and create
a user
The cookbook text says, log shipping "is mostly superseded by streaming
replication in 9.0, though is still useful as part of a comprehensive
backup strategy." The implication is that the WAL archive might be
needed for recovery in some cases:
1. Under what circumstances might the WAL archive com
10 matches
Mail list logo
