[COMMITTERS] pgsql: Add REPLICATION privilege for ROLEs

2010-12-29 Thread Magnus Hagander
Add REPLICATION privilege for ROLEs This privilege is required to do Streaming Replication, instead of superuser, making it possible to set up a SR slave that doesn't have write permissions on the master. Superuser privileges do NOT override this check, so in order to use the default superuser ac

Re: [COMMITTERS] pgsql: Ooops, no DATE_IS_NOBEGIN/DATE_IS_NOEND in 8.3 or 8.2 ...

2010-12-29 Thread Robert Haas
On Wed, Dec 29, 2010 at 12:10 AM, Tom Lane wrote: > Andrew Dunstan writes: >> On 12/28/2010 11:50 PM, Tom Lane wrote: >>> Think I'll use -n in future. > >> Would not git reset have undone the faulty commit if necessary? > > Possibly.  I looked at git revert, concluded it wouldn't do what > I want

[COMMITTERS] pgsql: Support unlogged tables.

2010-12-29 Thread Robert Haas
Support unlogged tables. The contents of an unlogged table are WAL-logged; thus, they are not available on standby servers and are truncated whenever the database system enters recovery. Indexes on unlogged tables are also unlogged. Unlogged GiST indexes are not currently supported. Branch -

[COMMITTERS] pgsql: Bump XLOG_PAGE_MAGIC.

2010-12-29 Thread Robert Haas
Bump XLOG_PAGE_MAGIC. The unlogged tables patch (commit 53dbc27c62d8e1b6c5253feba04a5094cb8fe046, 2010-12-29) should have done this, since it changes the format of an XLOG_SMGR_CREATE record. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d2

Re: [COMMITTERS] pgsql: Support unlogged tables.

2010-12-29 Thread Robert Haas
On Wed, Dec 29, 2010 at 6:49 AM, Robert Haas wrote: > The contents of an unlogged table are WAL-logged; thus, they are not > available on standby servers and are truncated whenever the database > system enters recovery.  Indexes on unlogged tables are also unlogged. > Unlogged GiST indexes are not

Re: [COMMITTERS] pgsql: Add REPLICATION privilege for ROLEs

2010-12-29 Thread Magnus Hagander
On Wed, Dec 29, 2010 at 11:08, Magnus Hagander wrote: > Add REPLICATION privilege for ROLEs Yeah, I forgot to bump catversion.h for this. But since Robert did that in the unlogged tables patch, we should be ok again now. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpi

[COMMITTERS] pgsql: Improve pg_upgrade's checks for required executables.

2010-12-29 Thread Tom Lane
Improve pg_upgrade's checks for required executables. Don't insist on pg_dumpall and psql being present in the old cluster, since they are not needed. Do insist on pg_resetxlog being present (in both old and new), since we need it. Also check for pg_config, but only in the new cluster. Remove t

[COMMITTERS] pgsql: Improve pg_upgrade's checks for required executables.

2010-12-29 Thread Tom Lane
Improve pg_upgrade's checks for required executables. Don't insist on pg_dumpall and psql being present in the old cluster, since they are not needed. Do insist on pg_resetxlog being present (in both old and new), since we need it. Also check for pg_config, but only in the new cluster. Remove t

[COMMITTERS] pgsql: Doc wording improvement: taken -> accepted

2010-12-29 Thread Bruce Momjian
Doc wording improvement: taken -> accepted with time zone.) timestamptz is accepted as an Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0be88f8739813067207314b3f88424ee8568d206 Modified Files -- doc/src/sgml/datatype.sgm

[COMMITTERS] pgsql: Tag refs/tags/REL9_1_ALPHA3 was created

2010-12-29 Thread pgsql
Tag refs/tags/REL9_1_ALPHA3 was created. -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers