Is there any built-in support for pljava in your release?
Peter Mengaziol | 04.02.08 - 2:46 pm | #

No, pljava not yet part of the PostgreSQL core distribution.
Anonymous | 04.02.08 - 8:27 pm | #

Err? No robust server environment for osx? Just install mysql? If you like postgres (and I do as well) then just use mac ports, 'port install portgresql', and done...?
ryan | 04.05.08 - 3:13 pm | #

ryan,

MySQL is well suited to some environments, but there are many at which it is not, and in terms of robust, in testing I know that personally, I found MySQL not to scale as we..

As to the just use mac ports comment, that's fine tool for a developer or a refugee from Linux where build from source is the only distribution model. Not everyone is comfortable with that approach, nor are they comfortable with the Command Line. Those are the folks this distribution is aimed at.
Anonymous | 04.07.08 - 10:37 am | #

I think you may be confusing compiling from source with MacPorts. The MacPorts collection has a GUI install program. After it's installed, installing PostgreSQL really is just as easy as:

1. Open a Terminal window.
2. Type: sudo port install postgresql83-server
3. Enter your password.

And that's it. MacPorts takes care of all of the heavy lifting behind the scenes, and displays only about seven lines of text--in total--that explain in simple terms what's happening.

The nice thing about MacPorts is it makes everything a breeze. Changed your mind and want to remove PostgreSQL? No problem, just go to the Terminal and type: sudo port uninstall postgresql83-server.
Solomon Ford | 04.11.08 - 5:29 pm | #

Running Mac OS10.4.11 on a PPC machine. I get a crash message whenever I try to launch Create User or Create Database. Backup and Query work fine - although of course of little use without a database!

I've installed the server, but not started it.

Have I missed anything.
Bob Williams | 04.15.08 - 2:55 am | #

Solomon,

I'm fully aware of how both Ports and Fink work. They may have GUI's but they are both still building from source and require the Developer Tools to be installed.
dru_satori | Homepage | 04.22.08 - 12:19 pm | #

The ports works well on my macbook and the client tools are awesome. I cannot seem to create a database cluster on an external HFS+ formatted disk. It works fine until creating template1 database:

creating template1 database in /Volumes/ExternalHardDrive/PostgresData/base/1 ... FATAL: could not create shared memory segment: Cannot allocate memory

DETAIL: Failed system call was shmget(key=1, size=1982464, 03600).

HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 1982464 bytes), reduce PostgreSQL's shared_buffers parameter (currently 50) and/or its max_connections parameter (currently 13).

I can create the database cluster on the local macbook disk fine, but I am running out of space FAST!

Any ideas?
Ron Hulen | 05.04.08 - 9:24 am | #

Most likely, the external disk is ignoring permissions which causes odd errors.
dru_satori | Homepage | 05.05.08 - 9:01 pm | #

great work! I really would appreciate actualized packages based on 8.3.3 ( which corrects some bigger errors). Any Updates on Schedule?
wegus | 06.26.08 - 7:52 am | #

Hi. To anyone looking to install Postgresql, both Fink and Macports are painful.

Fink installs an OLD version of pgsql.

Macports are HUGE installs for nothing. I won't use 99% of the stuff they put on my computer anyway.

Just download "POstgresql on Mac":
http://www.postgresqlformac.com/

It packages stuff neatly into server and clients -- your usual DMG files, and installs everything cleanly into /Library/Postgresql8.
Shanx | 07.14.08 - 10:52 pm | #

I have installed PostgreSQLforMac on a 10.5 Server!
On the Server I can still work with Postres. The name of the Postgres Server is "local". That right

On the Clients I can't work with the PostgreS - Tools, because I need a SERVERNAME?? The query Tool does not connect

What's the Servername??? IP and DNS - Name of the Server does not work!
Did I something wrong???

Hope someone can help me!
Arnd Schröder | 07.15.08 - 4:51 am | #

By default, the server is set up to only allow connections from the localhost (server). You'll need to alter the pb_hba.conf file to allow remote connections.

It is on the list of things to create, a tool for managing that.
Anonymous | 07.15.08 - 4:47 pm | #

I've installed the server and client tools, but, I don't see pg_ctl and psql.
Shouldn't these app's always be installed?
I haven't been into postgres lately.
Mike | 07.15.08 - 8:02 pm | #