[DOCS] INSTALL file nits
I just grabbed a copy of PostgreSQL from http://www.apple.com/downloads/macosx/unix_open_source/postgresql.html and installed it on my Mac OS X (Tiger; 10.4.2) machine. I followed the "Short Version" in the INSTALL file until I ran into problems, then did some workarounds, as discussed below. Perhaps this file should be made a bit more explicit or an INSTALL.OSX file could be generated... ./configure No reported problems. gmake No such command, but I ran "make --version" and saw that it was GNU Make, so I used it. No reported problems. su This command requires a root password, which does not exist. OSX uses "sudo -s" for this sort of thing. gmake install Used make; no reported problems. adduser postgres No such command. I considered using System Preferences > Accounts to add a user, but this seemed like a rather bogus approach, as it would put a user in the Login dialog (unlike lp, postfix, ...). I found a (slightly dated) note from Apple, however, that suggested just this approach, so I gave it a try. http://developer.apple.com/internet/opensource/postgres.html mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data No reported problems. su - postgres No reported problems (when run under sudo). /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test No reported problems, but the last command left me at a prompt with no particular instructions as to what I should do next. -r -- email: [EMAIL PROTECTED]; phone: +1 650-873-7841 http://www.cfcl.com- Canta Forda Computer Laboratory http://www.cfcl.com/Meta - The FreeBSD Browser, Meta Project, etc. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] INSTALL file nits
At 10:59 AM +0900 9/29/05, Michael Glaesemann wrote: Not clear if you're new to PostgreSQL or not, but regardless, a warm welcome is extended. Thanks! I've been lurking on this list for quite a while. I published the PostgreSQL manuals a few years ago (under the PTF/Dossier imprint), but that enterprise wasn't profitable enough to sustain itself. I also hang out with some PostgreSQL types in the SF Bay Area and have been looking at using PostgreSQL with Ruby on Rails, because it handles some things that neither MySQL nor Rails does (in any reasonable fashion :-). The short version is definitely that: short. It ceases to be short when one adds all of the caveats for all of the various systems and environments in which PostgreSQL will run. Yeah, well, I _did_ scan down the file in search of specific OSXisms. One of the joys of open source is that the community can contribute, be that source code or documentation. (hint hint) Well, I'm not really expert enough to document the "right" Way To Do It, but reporting bugs isn't chopped liver... adduser postgres No such command. I considered using System Preferences > Accounts to add a user, but this seemed like a rather bogus approach, as it would put a user in the Login dialog (unlike lp, postfix, ...). I found a (slightly dated) note from Apple, however, that suggested just this approach, so I gave it a try. To get around this, ... See, you have all this wonderful arcana at your fingertips. Why not put it in an OSX-specific README, let it bounce across the list a few times, and put it in the distro (or on a wiki, if that's preferable)? Thanks, in any case, for the useful hints... -r -- email: [EMAIL PROTECTED]; phone: +1 650-873-7841 http://www.cfcl.com- Canta Forda Computer Laboratory http://www.cfcl.com/Meta - The FreeBSD Browser, Meta Project, etc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [DOCS] INSTALL file nits
Actually, it's version 8.0.3, as of 2005.09.21. Izzat OK? -r At 9:27 AM -0700 9/29/05, Josh Berkus wrote: There's a much *bigger* issue than the ones you mention. That's PostgreSQL 7.3, 3 years old. I've written Apple several times about updating it, but no response. -- email: [EMAIL PROTECTED]; phone: +1 650-873-7841 http://www.cfcl.com- Canta Forda Computer Laboratory http://www.cfcl.com/Meta - The FreeBSD Browser, Meta Project, etc. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[DOCS] Commented, loadable databases as examples?
I would like to see some commented, loadable databases that folks can set up, play with, break, etc. They needn't be huge, just big enough to show off the feature(s) that are being demonstrated. I think this would be a good way to make the documentation a bit more concrete. -r -- email: [EMAIL PROTECTED]; phone: +1 650-873-7841 http://www.cfcl.com- Canta Forda Computer Laboratory http://www.cfcl.com/Meta - The FreeBSD Browser, Meta Project, etc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
