PgSql

[HACKERS] Protecting against case where shmget says EINVAL instead of EEXIST
The thread here http://archives.postgresql.org/pgsql-admin/2010-04/msg00358.php shows that current OS X contains the same issue that was complained of a year or so ago with respect to NetBSD. Namely, that if shmget finds an existing shared memory segment that is smaller than the current request, it will return EI... 1 May 2010 12:03

HS - odd process listing
Stefan Kaltenbrunner <stefan(a)kaltenbrunner.cc> writes: While playing with HS/SR on -HEAD I noticed that setting setting max_standby_delay to "-1" leads to the following kind of odd ps display: 1000 20254 9.2 11.3 8625164 5600644 ? Rs 21:22 1:50 postgres: startup process waiting for max... 30 Apr 2010 18:33

[HACKERS] HS - odd process listing
While playing with HS/SR on -HEAD I noticed that setting setting max_standby_delay to "-1" leads to the following kind of odd ps display: 1000 20254 9.2 11.3 8625164 5600644 ? Rs 21:22 1:50 postgres: startup process waiting for max_standby_delay (4294967295 s) This seems fairly confusing fro... 30 Apr 2010 17:26

pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
Kevin Grittner wrote: Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Yeah, min_wal_segments or something would make sense. Surely it would confuse people to see they have fewer than min_wal_segments WAL segments. Umm, they wouldn't see that, that's the point of the setting. Th... 30 Apr 2010 16:18

pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Yeah, min_wal_segments or something would make sense. Surely it would confuse people to see they have fewer than min_wal_segments WAL segments. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make change... 3 May 2010 15:22

WAL page magic number (was Re: [HACKERS] Re: [COMMITTERS]pgsql: Make CheckRequiredParameterValues() depend upon correct)
Heikki Linnakangas wrote: Tom Lane wrote: Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> writes: Browsing the history of XLOG_PAGE_MAGIC, it used to be incremented by one whenever the format changes, at least as long as it has been been in xlog_internal.h. It started at 0xD05B in 200... 30 Apr 2010 12:50

[HACKERS] Synchronous replication patch built on SR
Resending, my ISP lost my mail yesterday. :-( =========================================================== Hi, attached is a patch that does $SUBJECT, we are submitting it for 9.1. I have updated it to today's CVS after the "wal_level" GUC went in. How does it work? First, the walreceiver and the walsend... 30 Apr 2010 12:50

[HACKERS] Synchronous replication patch built on SR
Hi, attached is a patch that does $SUBJECT, we are submitting it for 9.1. I have updated it to today's CVS after the "wal_level" GUC went in. How does it work? First, the walreceiver and the walsender are now able to communicate in a duplex way on the same connection, so while COPY OUT is in progress from t... 30 Apr 2010 12:50

[HACKERS] missing file in git repo
I think postgres git repo is broken. The compilation of REL7_4_STABLE from git fails on my system with: make -C src all make -C port all make[2]: *** No rule to make target `sprompt.o', needed by `libpgport.a'. Stop. There is no sprompt.c in src/port in the sources obtained from git. However, there is one i... 30 Apr 2010 07:17

[HACKERS] Patch for PKST timezone
Hi all, Please accept attached patch for the following problem. aftab(a)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ aftab(a)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./psql postgres psql (9.0beta1) Type "help" for help. postgres=# SHOW timezone; TimeZone -------------- Asia/Karachi (1 row)... 30 Apr 2010 06:12