I was wondering if we can query/obtain the high-water mark of number of
sessions or connections reached in a Postgres database. Is there a view or
command that can provide this information. The pg_stat_database shows the
current number of connections, but not the high-water mark a database had
On Fri, Aug 6, 2010 at 12:28 PM, Burgholzer, Robert (DEQ)
wrote:
> I am trying to get my head around what causes catalog corruption. I
> have posted before with regard to recovering from corruptions (if that
> is what indeed happened to me), and was given much help.
>
> Does anyone know why a dat
On Fri, Aug 6, 2010 at 12:28 PM, Burgholzer, Robert (DEQ)
wrote:
> I am trying to get my head around what causes catalog corruption. I
> have posted before with regard to recovering from corruptions (if that
> is what indeed happened to me), and was given much help.
>
> Does anyone know why a dat
On 06/08/10 17:31, Fujii Masao wrote:
On Fri, Aug 6, 2010 at 10:10 PM, Alanoly Andrews wrote:
I’m testing “hot standby” using “streaming WAL records”. On trying to bring
(dbx) where
_alloc_initial_pthread(??) at 0x949567c
__pth_init(??) at 0x9493ba4
uload(??, ??, ??, ??, ??, ??,
Thanks Kevin, that gives me more than enough things to pepper my
sysadmin with. :)
r.b.
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
rwburghol...@deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourcef
"Burgholzer, Robert (DEQ)"
wrote:
> I am trying to get my head around what causes catalog corruption.
>From what I've seen many are caused by things outside of PostgreSQL
-- like bad disk, bad drivers, OS bugs, running on network drives
which aren't reliable, write caches without battery back-
I am trying to get my head around what causes catalog corruption. I
have posted before with regard to recovering from corruptions (if that
is what indeed happened to me), and was given much help.
Does anyone know why a database catalog will get corrupted? As I
mentioned previously, my db involve
Excerpts from Silvio Brandani's message of vie ago 06 07:56:53 -0400 2010:
> it seems the execution plan is different for this query when run from
> the application versus the psql . How can I check the execution plan of
> a query run by a user??
> I can set explain analyze for the query via psq
Thanks. Yes, the LOAD command does work, on another database cluster on the
same AIX machine.
-Original Message-
From: Fujii Masao [mailto:masao.fu...@gmail.com]
Sent: Friday, August 06, 2010 10:31 AM
To: Alanoly Andrews
Cc: pgsql-admin@postgresql.org; PostgreSQL-development
Subject: Re:
On Fri, Aug 6, 2010 at 10:10 PM, Alanoly Andrews wrote:
> I’m testing “hot standby” using “streaming WAL records”. On trying to bring
> up the hot standby, I see the following error in the log:
Thanks for the report!
> LOG: database system was interrupted; last known up at 2010-08-05 14:46:36
>
Hello,
OS level = AIX 5.3 ML-8
Postgres version = 9.0 beta-4
I'm testing "hot standby" using "streaming WAL records". On trying to bring up
the hot standby, I see the following error in the log:
LOG: database system was interrupted; last known up at 2010-08-05 14:46:36 EDT
LOG: entering stan
Silvio Brandani ha scritto:
Bob Lunney ha scritto:
Silvio ,
I had a similar problem when starting the database from an account
that didn't have the appropriate ulimits set. Check the ulimit
values using ulimit -a.
HTH,
Bob Lunney
--- On Thu, 8/5/10, Silvio Brandani wrote:
From: Silvi
Bob Lunney ha scritto:
Silvio ,
I had a similar problem when starting the database from an account that didn't
have the appropriate ulimits set. Check the ulimit values using ulimit -a.
HTH,
Bob Lunney
--- On Thu, 8/5/10, Silvio Brandani wrote:
From: Silvio Brandani
Subject: [ADMIN]
13 matches
Mail list logo
