Hello,
"pg_ctl -w -D ... start" doesn't work when unix_socket_directory is set
to somewhere else than the compiled in default ("/tmp"). Having this is
useful for the startup scripts, so the status "DONE" actually means
success, instead of "maybe".
Jeff Davis wrote about it a while ago:
http://sv
Andrew Dunstan <[EMAIL PROTECTED]> [18-09-2007 23:42]:
> This has a trivial workaround - just set PGHOST for pg_ctl:
> [EMAIL PROTECTED] inst.codfix.5705]$
> PGHOST=/home/andrew/pgl/inst.codfix.5705 bin/pg_ctl -D data/ -l logfile -w
> start
That would be fine for a particular installation, but
Hello,
Beta2 crashes on restoring a dump of tsearch2-enabled database, as
produced by 8.2.x (x==5 IIRC) pg_dump; the shortest way I know to get
the SIG11:
SET search_path = public, pg_catalog;
CREATE TYPE tsvector;
CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
AS '$libdir/ts
Hello,
Beta2 crashes on restoring a dump of tsearch2-enabled database, as
produced by 8.2.x (x==5 IIRC) pg_dump; the shortest way I know to get
the SIG11:
SET search_path = public, pg_catalog;
CREATE TYPE tsvector;
CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
AS '$libdir/ts
Tom Lane <[EMAIL PROTECTED]> [07-11-2007 05:24]:
> Jeff Davis <[EMAIL PROTECTED]> writes:
>> I agree that a dump/restore from 8.2 with tsearch2 to 8.3 with built-in
>> tsearch should not SIGSEGV.
> That's not what he did, though. Force-feeding contrib/tsearch2 into 8.3
> will not work.
That is wh
Hello,
I'm building beta2 --with-system-tzdata, my /usr/share/zoneinfo/posixrules
is a symbolic link to localtime, which is Europe/London; the horology test
fails in three places:
--- expected/horology.out 2007-07-25 18:22:36.0 +0100
+++ results/horology.out 2007-11-10 21:15: