Thread: filemaker front-end?

filemaker front-end?

From
Russ McBride
Date:
Hi,

Has anyone tried using FileMaker Pro as a front-end via ODBC? (or
perhaps even JDBC?)


Russ

postgres 7.1on Mac OS 10.1

From
Steven Lane
Date:
Hello all:

I'm struggling trying to get postgres 7.1 (7.1rc4 actually) to run on Mac
OS 10.1.I had been running a snapshot of 7.2, but it imposes stricter
checks on some of my code and also seems to break with PHP 4.0.6 (really
it's PHP that seems to break).

I struggled for a while to even get 7.1rc4 to  build under Mac OS 10.1 due
to the two-level namespace problem. What I finally did was to configure
7.1rc4 and a 7.2 snapshot, then copy src/Makefile.shlib abd
src/makefiles/Makefile.Darwin to their respective locations in the 7.1
source and build from there. 7.1rc built fine this way, and I can start up
the postmaster, but I can't make a new database. I get this every time:

[localhost:~] postgres% /usr/postgres/bin/createdb -e test2
CREATE DATABASE "test2"
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
connection to server was lost
Server process (pid 28773) exited with status 11 at Sat Dec 22 08:31:25 2001
Terminating any active server processes...
Server processes were terminated at Sat Dec 22 08:31:25 2001
Reinitializing shared memory and semaphores
DEBUG:  database system was interrupted at 2001-12-22 08:30:52 CST
DEBUG:  CheckPoint record at (0, 1522728)
DEBUG:  Redo record at (0, 1522728); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 615; NextOid: 18720
DEBUG:  database system was not properly shut down; automatic recovery in
progress...
DEBUG:  ReadRecord: record with zero len at (0, 1522792)
DEBUG:  redo is not required
createdb: database creation failed

The relevant directory in the data directory is created, because subsequent
attempts to createdb fail. But the database itself is still not in the
system catalog. Any ideas?

-- sgl

----------
Steve Lane
Vice President
Chris Moyer Consulting, Inc.
833 West Chicago Ave Suite 203
(312) 433-2421
http://www.fmpro.com



Re: postgres 7.1on Mac OS 10.1

From
Tom Lane
Date:
Steven Lane <slane@mail.fmpro.com> writes:
> ... 7.1rc built fine this way, and I can start up
> the postmaster, but I can't make a new database.

The system() library function is broken in OSX 10.1.  There's a
workaround in the backend/ports/darwin directory in 7.2beta4,
which you should be able to transpose into 7.1.

BTW, *please* use 7.1.3 not 7.1rc4 as your starting point.
There are some nontrivial bug fixes between.

            regards, tom lane