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 pg
> '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
-
Is someone keeping a "hopeful" todo list?
- Brandon
c: 917-697-8665h: 201-798-4983
b. palmer, [EMAIL PROTECTED] pgp:crimelabs.net/bpalmer.pgp5
-
> * 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]
> > 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
Are snapshots still being generated on ftp.postgresql.org (and rsync)?
I've just noticed that the date for the last /dev/*-snapshot* is May 8th.
What's the deal?
- Brandon
c: 917-697-8665
> 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
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: 646-456-5
> 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 t
> 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 thi
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: 646-456-5455
> 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
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
> 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:
>
> http://developer.
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
alt
> > 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
> lik
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 PROTECTED]
>
> 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: www.crimelabs.net/b
>
> 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 horolog
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
--- resultmap.n
> 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
se
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 sp
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 change
$ 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: www.crimelabs.net/bpalmer.pgp5
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
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 whee
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 serve
> 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,
> whi
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 /usr
anks, looks like 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/regress>diff -c resultmap resultmap.orig
*** resultmap Sat Jan
> 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
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/pgsql>diff 1 2
1c1
&
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-snapshot>uname -a
OpenBSD mizer 2.8 GENERIC#399 i386
bpalmer@mizer:~/PG7.1/postgresql-snaps
> Yes, postgresql requires vacuum quite often otherwise queries and
> updates start taking ungodly amounts of time to complete. If you're
> having problems because vacuum locks up your tables for too long
> you might want to check out:
But why? I don't know of other databases that need to be 'v
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, [EM
Can we PLEASE kill this thread? There are only a handful of people who
are making contributions here and nothing really new is being said. I
agree that the issue should be discussed, but this does not seem like the
right forum.
Thanks.
- brandon
b. palmer, [EMAIL PROTECTED]
pgp: www.crimel
43 matches
Mail list logo
