[COMMITTERS] slony1-ctl - slony-ctl: Oups, I forgot the Changelog...

2010-05-26 Thread User Sas
Log Message:
---
Oups, I forgot the Changelog...

Modified Files:
--
slony-ctl/etc:
bases.h (r1.5 - r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/slony1-ctl/slony-ctl/etc/bases.h?r1=1.5r2=1.6)
relations.h (r1.6 - r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/slony1-ctl/slony-ctl/etc/relations.h?r1=1.6r2=1.7)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: More fixes for shutdown during recovery.

2010-05-26 Thread Robert Haas
Log Message:
---
More fixes for shutdown during recovery.

1. If we receive a fast shutdown request while in the PM_STARTUP state,
process it just as we would in PM_RECOVERY, PM_HOT_STANDBY, or PM_RUN.
Without this change, an early fast shutdown followed by Hot Standby causes
the database to get stuck in a state where a shutdown is pending (so no new
connections are allowed) but the shutdown request is never processed unless
we end Hot Standby and enter normal running.

2. Avoid removing the backup label file when a smart or fast shutdown occurs
during recovery.  It makes sense to do this once we've reached normal running,
since we must be taking a backup which now won't be valid.  But during
recovery we must be recovering from a previously taken backup, and any backup
label file is needed to restart recovery from the right place.

Fujii Masao and Robert Haas

Modified Files:
--
pgsql/src/backend/postmaster:
postmaster.c (r1.608 - r1.609)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c?r1=1.608r2=1.609)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] psqlodbc - psqlodbc: 1.

2010-05-26 Thread User Hinoue
Log Message:
---
1. Use poll() instead of select() when it's available.
2. Take comments or line comments in a query into account.
3. Fix a crash bug on authentication failures.

Modified Files:
--
psqlodbc:
configure.ac (r1.86 - r1.87)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/configure.ac?r1=1.86r2=1.87)
connection.c (r1.187 - r1.188)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/connection.c?r1=1.187r2=1.188)
convert.c (r1.187 - r1.188)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/convert.c?r1=1.187r2=1.188)
socket.c (r1.70 - r1.71)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/socket.c?r1=1.70r2=1.71)
socket.h (r1.44 - r1.45)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/socket.h?r1=1.44r2=1.45)
statement.c (r1.146 - r1.147)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/statement.c?r1=1.146r2=1.147)
version.h (r1.156 - r1.157)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/version.h?r1=1.156r2=1.157)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Tell openssl to include the names of the root certs the server

2010-05-26 Thread Tom Lane
Log Message:
---
Tell openssl to include the names of the root certs the server trusts in
requests for client certs.  This lets a client with a keystore select the
appropriate client certificate to send.  In particular, this is necessary
to get Java clients to work in all but the most trivial configurations.
Per discussion of bug #5468.

Craig Ringer

Modified Files:
--
pgsql/src/backend/libpq:
be-secure.c (r1.99 - r1.100)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/be-secure.c?r1=1.99r2=1.100)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] psqlodbc - psqlodbc: Change the release note.(prep release)

2010-05-26 Thread Hiroshi Saito
Log Message:
---
Change the release note.(prep release)

Modified Files:
--
psqlodbc/docs:
release.html (r1.60 - r1.61)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/docs/release.html?r1=1.60r2=1.61)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Minor editorialization for be-secure.c: fix comments and some

2010-05-26 Thread Tom Lane
Log Message:
---
Minor editorialization for be-secure.c: fix comments and some formatting
infelicities.

Modified Files:
--
pgsql/src/backend/libpq:
be-secure.c (r1.100 - r1.101)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/be-secure.c?r1=1.100r2=1.101)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: The message style police pay a visit to hba.c.

2010-05-26 Thread Tom Lane
Log Message:
---
The message style police pay a visit to hba.c.

Modified Files:
--
pgsql/src/backend/libpq:
hba.c (r1.206 - r1.207)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/hba.c?r1=1.206r2=1.207)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix psql help: \da+ is same as \da, but \daS is not.

2010-05-26 Thread Robert Haas
Log Message:
---
Fix psql help: \da+ is same as \da, but \daS is not.

Noted by Stephen Frost.

Modified Files:
--
pgsql/src/bin/psql:
help.c (r1.158 - r1.159)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/help.c?r1=1.158r2=1.159)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: HS Defer buffer pin deadlock check until deadlock_timeout has

2010-05-26 Thread Simon Riggs
Log Message:
---
HS Defer buffer pin deadlock check until deadlock_timeout has expired.
During Hot Standby we need to check for buffer pin deadlocks when the
Startup process begins to wait, in case it never wakes up again. We
previously made the deadlock check immediately on the basis it was
cheap, though clearer thinking and prima facie evidence shows that
was too simple. Refactor existing code to make it easy to add in
deferral of deadlock check until deadlock_timeout allowing a good
reduction in deadlock checks since far few buffer pins are held for
that duration. It's worth doing anyway, though major goal is to
prevent further reports of context switching with high numbers of
users on occasional tests.

Modified Files:
--
pgsql/src/backend/storage/ipc:
standby.c (r1.23 - r1.24)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/standby.c?r1=1.23r2=1.24)
pgsql/src/backend/storage/lmgr:
proc.c (r1.218 - r1.219)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/proc.c?r1=1.218r2=1.219)
pgsql/src/include/storage:
proc.h (r1.121 - r1.122)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/proc.h?r1=1.121r2=1.122)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix bogus error message for SSL-cert authentication, due to lack

2010-05-26 Thread Tom Lane
Log Message:
---
Fix bogus error message for SSL-cert authentication, due to lack of
a uaCert entry in auth_failed().  Put the switch entries into a sane
order, namely the one the enum is declared in.

Modified Files:
--
pgsql/src/backend/libpq:
auth.c (r1.200 - r1.201)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/auth.c?r1=1.200r2=1.201)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Rearrange libpq's SSL initialization to simplify it and make it

2010-05-26 Thread Tom Lane
Log Message:
---
Rearrange libpq's SSL initialization to simplify it and make it handle some
additional cases correctly.  The original coding failed to load additional
(chain) certificates from the client cert file, meaning that indirectly signed
client certificates didn't work unless one hacked the server's root.crt file
to include intermediate CAs (not the desired approach).  Another problem was
that everything got loaded into the shared SSL_context object, which meant
that concurrent connections trying to use different sslcert settings could
well fail due to conflicting over the single available slot for a keyed
certificate.

To fix, get rid of the use of SSL_CTX_set_client_cert_cb(), which is
deprecated anyway in the OpenSSL documentation, and instead just
unconditionally load the client cert and private key during connection
initialization.  This lets us use SSL_CTX_use_certificate_chain_file(),
which does the right thing with additional certs, and is lots simpler than
the previous hacking about with BIO-level access.  A small disadvantage is
that we have to load the primary client cert a second time with
SSL_use_certificate_file, so that that one ends up in the correct slot
within the connection's SSL object where it can get paired with the key.
Given the other overhead of making an SSL connection, that doesn't seem
worth worrying about.

Per discussion ensuing from bug #5468.

Modified Files:
--
pgsql/src/interfaces/libpq:
fe-connect.c (r1.392 - r1.393)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-connect.c?r1=1.392r2=1.393)
fe-secure.c (r1.133 - r1.134)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-secure.c?r1=1.133r2=1.134)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: In walsender, don't sleep if there's outstanding WAL waiting to

2010-05-26 Thread Heikki Linnakangas
Log Message:
---
In walsender, don't sleep if there's outstanding WAL waiting to be sent,
otherwise we effectively rate-limit the streaming as pointed out by
Simon Riggs. Also, send the WAL in smaller chunks, to respond to signals
more promptly.

Modified Files:
--
pgsql/src/backend/replication:
walsender.c (r1.20 - r1.21)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/replication/walsender.c?r1=1.20r2=1.21)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Thinko in previous commit: ensure that MAX_SEND_SIZE is always

2010-05-26 Thread Heikki Linnakangas
Log Message:
---
Thinko in previous commit: ensure that MAX_SEND_SIZE is always greater
than XLOG_BLCKSZ, by defining it as 16 * XLOG_BLCKSZ rather than directly
as 128k bytes.

Modified Files:
--
pgsql/src/backend/replication:
walsender.c (r1.21 - r1.22)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/replication/walsender.c?r1=1.21r2=1.22)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Document pgFouine and check_postgres as log analysis options.

2010-05-26 Thread Bruce Momjian
Log Message:
---
Document pgFouine and check_postgres as log analysis options.

Modified Files:
--
pgsql/doc/src/sgml:
maintenance.sgml (r1.103 - r1.104)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/maintenance.sgml?r1=1.103r2=1.104)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Improve SSL-related documentation.

2010-05-26 Thread Tom Lane
Log Message:
---
Improve SSL-related documentation.  Explain how to deal with certificate
chains, do assorted wordsmithing.

Modified Files:
--
pgsql/doc/src/sgml:
client-auth.sgml (r1.137 - r1.138)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/client-auth.sgml?r1=1.137r2=1.138)
config.sgml (r1.278 - r1.279)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.278r2=1.279)
libpq.sgml (r1.305 - r1.306)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml?r1=1.305r2=1.306)
runtime.sgml (r1.435 - r1.436)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml?r1=1.435r2=1.436)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix SGML markup

2010-05-26 Thread Bruce Momjian
Log Message:
---
Fix SGML markup

Modified Files:
--
pgsql/doc/src/sgml:
maintenance.sgml (r1.104 - r1.105)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/maintenance.sgml?r1=1.104r2=1.105)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Adjust comment to reflect that we now have Hot Standby.

2010-05-26 Thread Heikki Linnakangas
Log Message:
---
Adjust comment to reflect that we now have Hot Standby. Pointed out by
Robert Haas.

Modified Files:
--
pgsql/src/backend/access/transam:
xlog.c (r1.413 - r1.414)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.413r2=1.414)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Avoid starting walreceiver in states where it shouldn't be

2010-05-26 Thread Robert Haas
Log Message:
---
Avoid starting walreceiver in states where it shouldn't be running.

In particular, it's bad to start walreceiver when in state
PM_WAIT_BACKENDS, because we have no provision to kill walreceiver
when in that state.

Fujii Masao

Modified Files:
--
pgsql/src/backend/postmaster:
postmaster.c (r1.609 - r1.610)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c?r1=1.609r2=1.610)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers