[GENERAL] howto? Fine Debugging control at cmd line

hi all, per the docs, i understand i *can* define/change the global pgsql debugging level at the cmd line by passing, say, pg_ctl the '-o "-d 5"' option, AND, that i can finely change loglevel options in postgresql.conf, e.g.: client_min_messages = debug5 # debug5, debug4, debug3, debug2, de

[GENERAL] Changing Run-time parameters at command line

Hi, another simple question: what's the correct command line syntax to change specific run-time parameters, e.g. 'client_min_messages'. I understand you can define/change them in the .conf file ... an example, or a pointer to RTFM would be great =) thanks, richard ---(end

Re: [GENERAL] PostgreSQL still for Linux only?

Tope, As someone who's been on these lists for several years now, I can honestly say they're among the friendliest and most helpful I've found. i can certainly echo that sentiment. from what i can tell, Tom in particular (since he's been 'called out' here) has (most of the time ...) the patience

[GENERAL] help w/ a little naive brainstorming ...

hi all, i've two random, not-completely-disjointed questions that have arisen in a recent, off-the-cuff discussion. any/all initial pointers/comments would be much appreciated ... while i slog through Google, etc. trying to learn more ... (1) does pgsql have/plan an equivalent of Oracle's Exter

Re: [GENERAL] help w/ a little naive brainstorming ...

hi michael, (1) does pgsql have/plan an equivalent of Oracle's External Tables? "The External Table feature allows for flat files, which reside outside the database, to be accessed just like relational tables within the datab

[GENERAL] pgsql config flag update: apple rendezvous renamed bonjour

hi all, fyi: "Apple's Rendezvous renamed 'Bonjour'" since it's now official, might it be time to add a conditional for: --with-rendezvous || --with-bonjour in configure? sorry if its 'old news' =) chee

Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4

hi all, reading here, it seems builds on 'virgin' Tiger are behaving themselves ... just fyi & fwiw, a pgsql v803 build on OSX 10.4.1 is also very nicely tolerant of a /usr/local mod'd system, resulting in: % otool -L /usr/local/pgsql/bin/postgres /usr/local/pgsql/bin/postgres: /usr/lib/libSyste

Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4

hi tom, OpenMacNews <[EMAIL PROTECTED]> writes: reading here, it seems builds on 'virgin' Tiger are behaving themselves ... The short answer seems to be "when you update to 10.4, don't forget to update to Xcode 2 as well". regards, tom lane does it make sense

Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4

OpenMacNews <[EMAIL PROTECTED]> writes: The short answer seems to be "when you update to 10.4, don't forget to update to Xcode 2 as well". does it make sense to have configure check for min req'ts of xcode2 if os >= v10.4? No, I don't think so. There is such

[GENERAL] portable pgsql binary/pkg building on OSX ...

hi all, i've been happily building runing ver's of pgsql (current 81b2) on my OSX 10.4.2 on G4 boxes. to date, always linked/built to my /usr/local dev tree of libs, headers, etc. now, i'd like to build once, pkg and deploy to other boxes. admittedly, dylibs/libtool/etc which have been standard

Re: [GENERAL] portable pgsql binary/pkg building on OSX ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi john, >> is '--disable-rpath' necessary/sufficient? > I don't think so, but I'm hardly and expert here. I was able to build > psql with libq as a single executable, but in the end I found it easier > to do the standard compile and then have a sc

Re: [GENERAL] portable pgsql binary/pkg building on OSX ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi john > There a couple of packages out there which may provide some useful hints: > > http://sourceforge.net/projects/pgsqlformac/ > http://perso.wanadoo.fr/bruno.gaufier/xhtml/downloads.xhtml > http://www.entropy.ch/software/macosx/postgresql/ u

[GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6

hi all, i've a successful install of pgsql 8b5 on OSX 10.3.6. trying to install pl/pgsql: % createlang plpgsql template1 results in an immediate error: createlang: language installation failed: ERROR: could not load library "/usr/local/pgsql/lib/plpgsql.so": dyld: /usr/local/pgsql/bin/post

Re: [GENERAL] createlang fails w/ 'undef ref to

hi tom, thx for the reply =) You seem to be trying to load a current plpgsql.so into a less than current backend. SPI_restore_connection() was just added a few days ago ... just getting used to pgsql terminology, but i presume by 'backend' you simply mean version of pgsql iteslf, yes? to that en

Re: [GENERAL] createlang fails w/ 'undef ref to

Maybe you didn't restart your beta4-or-older postmaster after updating? SPI_restore_connection definitely exists in the beta5 sources ... all ok now. restarting wasn't doing the trick ... same errors. still able to access/read/write to my db's but nada else. but, looking in my logs i noted a slew

[GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi all, i've a new install of pgsql8b5 running on OSX 10.3.6. i can readily start it from the command line with: sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf >/var/devlogs/postgres.log &" after whic

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, -- On Thursday, December 2, 2004 12:33:48 PM PST -0500 Tom Lane <[EMAIL PROTECTED]> wrote: OpenMacNews <[EMAIL PROTECTED]> writes: sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/post

[SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, LOG: 0: logger shutting down LOCATION: SysLoggerMain, syslogger.c:361 I should have twigged to that before --- if you're running the syslogger, then nothing except very early startup messages is going to go to stderr. Look in wherever you told it to put the log output. i thou

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi tom, In that case it's a problem in your launch script. The postmaster doesn't even know that such a file exists; it keeps its lock file in the data directory. well, h. the launch script is currently simplified (for testing) to just the pid-checking-if-stmt + the single line launch cmd. t

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi, note that my cmd line refers to the conf file, which has the external PID id'd in it: external_pid_file = '/var/run/postgresql.pid' Oh, now you tell us ;-) heh. sorry -- just thought it was SOP. in case you haven't noticed, i'm at that 'wunnerful' ramp-up stage that i dunno what i dunn

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi, But who is it owned by, and with what permissions? same owner as postmaster, 0644 or 0600 If you do the "touch" as some other user than the postmaster runs as, it's very plausible the postmaster can't write the file. (That doesn't yet explain why it goes south afterward, but first we need to

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start

hi joel, just checked -- looks ok. PID is properly 'owned & operated' by the postmaster superuser defined in the launch command Who owns /var/run? What group? Does testuser have permission to delete files there? (May need to add testuser to the wheel or admin group?) good points =) already done,

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, however, if i place an identical startup string in my OSX's StartupItem for pgsql & reboot, pgsql does not start on boot. I was trying to reproduce this on my own machine, but couldn't get out of the starting gate. I put an executable shell script into "/System Folder/Startup Items", but I

[GENERAL] RFDs, Lists & Usenet: One Non-Advanced, Non-Developer User's Perspective

hi all, after a fairly long hiatus from pgsql, i've recently (re)joined the community, and have dropped into the middle of the what-do-we-do-abt-newsgroups thread. i thought i'd add my lil' ol' voice w/ some 'objective, unbiased' (yeah, right ...) comments. (1) in general, i honestly don't care

[GENERAL] initdb error: "could not identify current directory" (or, what have i done now?)

hi all, i just clean-rebuilt pgsql8b5 os OSX 10.3.6 the build went fine as before -- no errors reported. per instruction, i've created an unpriv'd user: testuser. now, however, when i try to 'initdb', creating in '/var/data/pgsql': su testuser % /usr/local/pgsql/bin/initdb --pgdata=/var/data/pgsql

Re: [GENERAL] initdb error: "could not identify current directory" (or,

hi there, % /usr/local/pgsql/bin/initdb --pgdata=/var/data/pgsql --username=testuser could not identify current directory: Permission denied What directory are you in when you give this command? (AFAIR su doesn't change directory ... you might be better off with su - testuser ...) h, that'

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, After eyeballing that, I think I have no hope of reproducing your test conditions unless you show me the exact script and property list files you used. certainly easy enuf. thought *i'm* not certain *i* have hope of reproducing much after today's shenanigans ... jeeesh! fyi, the latest v

Re: [GENERAL] initdb error: "could not identify current directory" (or,

hi tom, % ls -ald /Volumes/data/pgsql drwxrwxr-x 12 testuser testuser 408 Nov 25 09:12 /Volumes/data/pgsql Huh? Why didn't the rm -rf remove both of those? Or are you skipping some steps? oops, sorry, copy-n-paste-itis: % rm -rf /var/data/pgsql/* /Volumes/data/pgsql/* % cd /var/data/pg

Re: [GENERAL] initdb error: "could not identify current directory" (or,

hi tom, per this thread, i've been googl'ing on 'getcwd initdb permissions parent' and find lots of refs ... issues with folks having 'permission denied' errors if parent directories don't have correct permissions, etc. this 'smells' pretty much like the issue at hand here ... tho' i dunno (yet)

[SOLVED] Re: [GENERAL] initdb error: "could not identify current directory" (or, what have i done now?)

hi tom, i think i got it ... keeping in mind your question re: read perms, & reading this thread: and noting

Re: [SOLVED] Re: [GENERAL] initdb error: "could not identify current

hi tom, % ls -ald /Volumes/data drwxr-x--x 12 openmac wheel 408 Nov 27 15:25 /Volumes/data/ Ah-hah, yes that's undoubtedly it. and, since i've cleared that up pgsql is, again, behaving. yay. for posterity's -- and other OSX users' -- sake, that's: for the relevant drives/mounts in /Volu

Re: [SOLVED] Re: [GENERAL] initdb error: "could not identify current

tom, We're doing the best we can already: when the failure occurs, we really don't know which directory is the problem, and cannot find out because we can't navigate above it to find out its name. good point. catch-22. at the very least, some knowledgeable commentary in docs/FAQ/howto/Troubleshoo

Re: [GENERAL] initdb error: "could not identify current directory"

hi joel, It looks to me like you are attempting to mount a few volumes under /var? actually, no. i'm symlinking local volumes mounted where they're supposed to be, in /Volumes, to ny /var/sub-hierarchy. I think that's going to wrinkle your handkerchief in Darwin. it's all been settled, actually (

[GENERAL] using SSL client certs?

.7/16.9 don't clarify at all ... thx! richard - -- /"\ \ / ASCII Ribbon Campaign X against HTML email, vCards / \ & micro$oft attachments [GPG] OpenMacNews at gmail dot com fingerprint: 50C9 1C46 2F8F DE42 2EDB D

Re: [GENERAL] using SSL client certs?

t' -- probably in postgresql.conf -- at other paths/filenames for the certs/keys? e.g., other than "/path/to/DATA_DIR/server.crt" etc etc? thx! richard - -- /"\ \ / ASCII Ribbon Campaign X against HTML email, vCards / \ & micro$oft attachments [GPG] OpenMacNews at