Hi,
I have a web-based application (drupal) which uses PHP to make connections to a
back-end postgresql 8.3 server. The application and database are on separate
servers, but as we can get 20+ concurrent connections on the database I've
looked at pgBouncer to try and reduce the overhead of new
Many thanks.
> Subject: Re: [ADMIN] pgBouncer for connection pooling
> From: j...@commandprompt.com
> To: kierensc...@hotmail.com
> CC: pgsql-admin@postgresql.org
> Date: Mon, 23 Aug 2010 09:02:31 -0700
>
> On Mon, 2010-08-23 at 14:38 +, Kieren Scott wrote:
> >
Hi,
What would be the best course of action for resolving a situation whereby your
postgres instance had crashed due to the wal disk and archive wal disk becoming
100% full? Say
your backups have been failing and your 'monitoring' had not reported it
correctly.
You can't start the instance be
ubject: Re: [ADMIN] WAL and archive disks full
>
> Kieren Scott wrote:
>
> > What would be the best course of action for resolving a situation
> > whereby your postgres instance had crashed due to the wal disk and
> > archive wal disk becoming 100% full? Say your backu
and archive disks full
>
> Kieren Scott wrote:
>
> > Sorry it's a bit of a what-if scenario. I can envisage
> > encountering a situation in the future whereby we hit this
> > problem, and I was trying to put a plan in place for how to deal
> > with it.
>
Hi,
I was interested in finding out how other people are monitoring their postgres
database estates.
We use psql and pgAdmin for day to day dba admin tasks, but I was wondering if
there were any
good tools available for monitoring such things as whether all of my postgres
cluster's were up an
Thank you.
Kieren
> To: kierensc...@hotmail.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] WAL and archive disks full
> Date: Mon, 23 Aug 2010 20:17:02 -0400
> From: t...@sss.pgh.pa.us
>
> Kieren Scott writes:
> > [ hypothetical scenario: ]
>
stgresql.org
> Subject: Re: [ADMIN] Enterprise pg database monitoring
>
> Le 24/08/2010 11:44, Jens Wilke a écrit :
> > Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
> >
> > Hi Kieren,
> >
> >> but I was wondering if there were any good tools
kends to
handle the cases where I have a high oncurrency of data coming in at once, but
usually the # non-idle connections is < 10.
From:
pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On
Behalf Of Kieren Scott
Sent: Monday, August 23, 2010 8:38 AM
To: pgs
Hi,
I'm interested in finding a way of gathering and retaining system statistics in
my
postgres instances, so I can see how certain things are changing over time. I
know
postgres provides a range of pre-defined views for viewing current activity,
but are
there any modules/scripts that are a
15 AM, Kieren Scott wrote:
Hi,
I'm interested in finding a way of gathering and retaining system
statistics in my
postgres instances, so I can see how certain things are changing
over time. I know
postgres provides a range of pre-defined
erver stats collection
On 10-08-26 05:15 AM, Kieren Scott wrote:
Hi,
I'm interested in finding a way of gathering and retaining system
statistics in my
postgres instances, so I can see how certain things are changing
ov
Hi,
I'm trying to understand what is going on internally when doing a VACUUM FULL
on a table in 8.3.
I have a table that is 1GB in size, 500M is used, and 500M is free space. When
I do a vacuum full
on this table, will it either: -
1) Compact all of the used tuples into free space within the
icourts.gov
> To: kierensc...@hotmail.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] vacuum full table - internals in 8.3
>
> Kieren Scott wrote:
>
> > I'm trying to understand what is going on internally when doing a
> > VACUUM FULL on a table in 8.3.
>
Hi,
What is the best way to restrict/limit the size that a schema can grow too in
Postgresql?
If I want to have a scratchpad area within my database to allow users to create
tables,
how can I control the size of the objects they can create?
Would I have to create a dedicated filesystem and t
00
From: g...@2ndquadrant.com
To: kierensc...@hotmail.com
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Restricting schema sizes
Kieren Scott wrote:
What
is the best way to restrict/limit the size that a schema can grow too
in Postgresql?
...
The other option I can think of is writin
Hi,
I'm looking to implement LDAP authentication againt Active Directory for my
Postgresql databases. What's people experiences of using LDAP for
authenticating logins with AD?
Is it easy to setup and is there anything to watch out for e.g. does Postgresql
do anything
intrusive on Active Dire
Hi,
I've setup LDAP on Postgresql 8.3.6 by adding the following line to
pg_hba.conf. My Active Directory has a group called 'users group' which
contains an entry for user pgtest.
host all pgtestxx.xxx.x.x/xx ldap
"ldap://server.mydomain.com:389/basedn;cn=;,ou=users group,dc=mydom
Hi,
I have made some progress on this, in that I've managed to get LDAP
authentication working, but not quite as I expected.
I found out that the Canonical Name in AD was set to "PG Test" for the account
name "pgtest".
If I add "PG Test" as the user in pg_hba.conf and create a login "PG Test"
Hi,
I need to migrate some data (a few GB's) from an 8.4 database to an 8.3
database using pg_dump. What is the best way to acheive this?
E.g. Run pg_dump from the 8.3 host pointing it at the 8.4 host and include the
version mismatch parameter?
Or, run pg_dump on the 8.4 host, then zip the 8.4
20 matches
Mail list logo
