I'm trying to port some replication code from 7.2 - 7.4 and am running
into a block.
In the file:
/src/backend/tcop/postgres.c
My diff was for:
void
pg_exec_query(char *query_string)
{
pg_exec_query_string(query_string, whereToSendOutput,
QueryContext);
}
But the
'k, I just tag'd REL7_4 and built the bundles ... the files are available
under ftp://ftp.postgresql.org/pub/source/v7.4beta, and I've open'd up the
ftp server there to 100 connections so that ppl can get in and test it ...
ftp3.us.postgresql.org is in sync as well if anyone is interested.
No luck on general, so I'll try here:
I'm trying to figure out what version of a source code I have. I know
it's a 7.2 release, but how can I find out of it's 7.2, 7.2.3, 7.2.4,
etc. FROM THE SOURCE CODE, not from compiling (it doesn't compile, it's
testing code).
Thanks
- Brandon
* Compliant ADD COLUMN
I've missed the thread (if there was one), how is it non-compliant?
Thanks,
- Brandon
c: 917-697-8665h: 201-798-4983
b. palmer, [EMAIL PROTECTED]
Is someone keeping a hopeful todo list?
- Brandon
c: 917-697-8665h: 201-798-4983
b. palmer, [EMAIL PROTECTED] pgp:crimelabs.net/bpalmer.pgp5
D'Arcy,
In production the database servers are seperate multi-processor machines
with mirrored disks linked via Gigabit ethernet to the app server.
In development I have people extremely familiar with MS, but not very hot
with Unix in any flavour, who are developing Java and PHP code
We'll need a good beta period this time, because of:
I know it's a sore subject, but how about ALTER TABLE DROP COLUMN this
time around? I've been hearing about it for years now. :)
- brandon
c: 646-456-5455
Is there some formal place to make comments on how 7.2b1 works? I'm about
to run it through it's paces on OBSD. Or is this just a 'it's broked'
testing time?
- Brandon
c: 646-456-5455
I'm working on making some changes to the top level configure.in and m4
has now been running for 17 minutes on a 1.4G tbird. Am I missing
something or is this know to take forever?
For me, the autoconf run is instantaneous. Make sure you're using
Autoconf 2.13, and you don't have
I'm working on making some changes to the top level configure.in and m4
has now been running for 17 minutes on a 1.4G tbird. Am I missing
something or is this know to take forever?
Thanks guys,
- Brandon
c:
You can find a snapshot that should be pretty durn close to 7.2beta1
at ftp://ftp2.us.postgresql.org/pub/dev/postgresql-snapshot.tar.gz
(note that at last word, other mirrors were not up to date --- if
the doc/TODO file doesn't contain a date in October, it's stale).
I think the only thing
I've been looking for documents and other info on replication efforts in
PostgreSQL. If anyone here can point me to places where I can find
these, it would be really appreciated.
It really depends on your replication needs. I would suggest taking a
look at gborg.postgresql.org for any of the
Since there have been drastic CVS changes, the web page doc should REALLY
be updated...
Withdrawn, I notive Bruce made the changes, but I guess they havn't hit
yet. My bad.
- Brandon
c: 646-456-5455
For OpenBSD to work, we need a change from LOCAL_CREDS to SCM_CREDS.
Bruce, I think you are familure with this one. Care to make the change?
(I have no idea where to make it!).
Thanks all,
- Brandon
c:
Since there have been drastic CVS changes, the web page doc should REALLY
be updated...
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html
- Brandon
c: 646-456-5455
On Fri, 7 Sep 2001, Bruce Momjian wrote:
gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o hba.o hba.c
hba.c: In function `ident_unix':
hba.c:923: sizeof applied to an incomplete type
hba.c:960: dereferencing pointer to incomplete type
The developer's corner will soon be going away. I'm in the process of
putting together a developer's site. Different URL, different look,
beta announcements will be there, regression database will be there,
developement docs, etc. If you want a sneak preview:
My nightly regression tests for OBSD failed for i386 and sparc. Attached
is the regression.diff, I don't know what to make of it.. Looks like
problems w/ foreign keys.
...
parallel group (5 tests): portals_p2 rules select_views alter_table
foreign_key
select_views ... ok
I'm starting to throw together a web site relating to postgresql
replication, trying to bring together the ideas we have thrown around so
far. If anyone has any good docs (on replication not relating to
postgresq too), please send me the links.
Thanks.
- Brandon
b. palmer, [EMAIL
This behavior raises the question about file system usage in Postgres. Many
databases, such as Oracle, create table space files and operate directly on the
raw blocks, bypassing the file system altogether.
OK, we have considered this, but frankly, the new, modern file systems
like
Does anyone have any outstanding fixes for v7.1.x that they want to see in
*before* we do this release? Any points unresolved that anyone knows
about that we need to look at?
Is there a list of what IS getting changed? Can this be posted somewhere
or is the changelist enough?
- Brandon
I know this isn't really hackers traffic, but...
one of the servers in www.postgresql.org is
http://postgresql.bbksys.com/
which is giving me 404 errors..
I've mailed webmaster@, but thought this should be mailed on anyway..
- brandon
b. palmer, [EMAIL PROTECTED]
pgp:
I just ran the "make check" (paralell regression tests) - instead of the
"make installcheck" that I'd run previously...
[nobody@web-cache regress]$ grep 'FAILED' regression.out
test geometry ... FAILED
test horology ... FAILED
The relevant diff for horology seem
I posted this to the list a few days ago, but it was not addressed. Can
someone please make the changes to the src/test/regress/resultmap?
Thanks.
- brandon
b. palmer, [EMAIL PROTECTED]
pgp: www.crimelabs.net/bpalmer.pgp5
*** resultmap.orig Fri Mar 23 12:34:56 2001
---
OpenBSD 2.8 x867.1 2001-03-22, Brandon. Palmer
OBSD checks out for sparc and i386. We did need to make a change to the
resultmap file to make the regression tests clean for the sparc. I have
attached the diff.
Also, on the sparc that i'm using (sparc4/110), make check takes 1950
On Thu, 22 Mar 2001, Thomas Lockhart wrote:
OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)
Though it does work, like FBSD, there are some changes that need to be
made to the system. Need max proc / files changes and a kernel recompile
with SEMMNI and SEMMNS changes.
On Thu, 22 Mar 2001, Thomas Lockhart wrote:
OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)
Though it does work, like FBSD, there are some changes that need to be
made to the system. Need max proc / files changes and a kernel recompile
with SEMMNI and SEMMNS changes. Anywhere
$ uname -a
OpenBSD mizer 2.8 a#0 i386
P3, default 2.8 install. Problems w/ TCL, but I think it's a local
problem.
System needs kernel changes as noted at www.crimelabs.net. (shared mem
stuff).
OBSD-sparc comming soon.
- b
b. palmer, [EMAIL PROTECTED]
pgp:
Worked fine for me...
% uname -a
SunOS lancelot 5.7 Generic_106541-14 sun4m sparc SUNW,SPARCstation-4
% ls -l
-rw-r--r-- 1 bpalmer staff32860160 Jan 23 16:45
postgresql-snapshot.tar
...
...
...
transactions ... ok
random ... failed (ignored
On Tue, 23 Jan 2001, Bruce Momjian wrote:
I have added this to /contrib for 7.1.
Not sure if you know this, but you checked in the code compiled and w/
the .o file...
FYI.
b. palmer, [EMAIL PROTECTED]
pgp: www.crimelabs.net/bpalmer.pgp5
I object. The code displays oids and tablenames or relnames. Oid is just
the initial, default filename for tables, and may change to something other
than the oid. Currently, the reindex code is the only place that could change
the relfilenode without changing the oid, but I think there may be
On older versions of PG, 7.0 included, in the $PDGATA/base folder you
could see the names of the databases for that $PGDATA. Now all I see is:
$ ls -l
total 16
drwx-- 2 postgres wheel 1536 Jan 12 15:42 1
drwx-- 2 postgres wheel 1536 Jan 12 15:41 18719
drwx-- 2 postgres
Speaking of which..
rpm -ivh ftp://ftp.postgresql/pub/whatever/postgresql-\*.rpm
Is there a clearing house for packages? I have made some for OpenBSD
(www.crimelabs.net/postgresql.shtml), but I wouldn't even know where to
get the rpm or deb files. Should there be a folder on the ftp server
A few problems came up with 7.1CVS for i86 OpenBSD. Here is a writeup on
what I learned and how I solved the problems.
- Brandon
b. palmer, [EMAIL PROTECTED]
pgp: www.crimelabs.net/bpalmer.pgp5
Added gmake and gettext. (if you don't have it)
Added bison and replaced /usr/bin/yacc with
Can you check
http://www.postgresql.org/devel-corner/docs/postgres/kernel-resources.htm#SYSVIPC
to see if the description for FreeBSD is also applicable (at least in
similar form) to OpenBSD?
Close enough.
I'm currently writing up a section about the process and file limit issue,
which
When I run 'make check' on the CVS version (today and for the last
serveral days), I have been getting interesting failures. Some of the
tests fail, but the interesting part is that not the same tests always
fail. Example:
bpalmer@mizer:~/APPS/pgsqldiff 1 2
1c1
boolean
In the postmaster: the fork() to launch a backend is failing. There
should be a more detailed message in the postmaster's stderr log,
but almost certainly it's a resource-exhaustion issue. Does your
kernel enforce a per-userid limit on the number of processes, for
example?
Looks like that
the problem is solved. Should me make note of
the changes what were needed for OBSD somewhere?
b. palmer, [EMAIL PROTECTED]
pgp: www.crimelabs.net/bpalmer.pgp5
bpalmer@mizer:~/APPS/pgsql/src/test/regressdiff -c resultmap resultmap.orig
*** resultmap Sat Jan 6 19:35:02 2001
Is this bad, or are there expected to be known problems like this for
OBSD?
7.1beta1 had roughly the same errors..
- BEGIN ---
bpalmer@mizer:~/PG7.1/postgresql-snapshotuname -a
OpenBSD mizer 2.8 GENERIC#399 i386
bpalmer@mizer:~/PG7.1/postgresql
I noticed the other day that one of my pg databases was slow, so I ran
vacuum on it, which brought a question to mind: why the need? I looked
at my oracle server and we aren't doing anything of the sort (that I can
find), so why does pg need it? Any info?
Thanks,
- brandon
b. palmer,
40 matches
Mail list logo