On Sat, December 4, 2010 01:11, Tom Lane wrote: > "James B. Byrne" <byrnejb@xxxxxxxxxxxxx> writes: >> I wrote too soon. What I did was uncomment the ssl option. I >> neglected to change the setting from off to on. > >> When I try to start the server with ssl=on it fails with this >> error: > >> Auto configuration failed >> 29006:error:0E065068:configuration file routines:STR_COPY:variable >> has no value:conf_def.c:629:line 207 > > AFAIK there is no place in the standard Postgres sources that could > emit an error message even vaguely like that. I'm guessing that > you are using some add-on code that tries to parse postgresql.conf, > but I don't know what that would be. Whose init script are you > using? > > regards, tom lane > I see some familiar names. . . # cat postgresql #!/bin/sh # postgresql This is the init script for starting up the PostgreSQL # server # # chkconfig: - 64 36 # description: Starts and stops the PostgreSQL backend daemon that handles \ # all database requests. # processname: postmaster # pidfile: /var/run/postmaster.pid # Version 6.5.3-2 Lamar Owen # Added code to determine if PGDATA exists, whether it is current version # or not, and initdb if no PGDATA (initdb will not overwrite a database). # Version 7.0 Lamar Owen # Added logging code # Changed PGDATA. # Version 7.0.2 Trond Eivind Glomsrd <teg@xxxxxxxxxx> # use functions, add conditional restart # Version 7.0.3 Lamar Owen <lamar@xxxxxxxxxxxxxx> # Check for the existence of functions before blindly using them # in particular -- check for success () and failure () before using. # More Cross-distribution support -- PGVERSION variable, and docdir checks. # Version 7.1 Release Candidate Lamar Owen <lamar@xxxxxxxxxxxxxx> # initdb parameters have changed. # Version 7.1.2 Trond Eivind Glomsrd <teg@xxxxxxxxxx> # Specify shell for su # Handle stop better - kill unwanted output, make it wait until the database is ready # Handle locales slightly differently - always using "C" isn't a valid option # Kill output from database initialization # Mark messages for translation # Version 7.1.2-2.PGDG Lamar Owen <lamar.owen@xxxxxxxx> # sync up. # Karl's fixes for some quoting issues. # Version 7.2b2 Lamar Owen <lamar.owen@xxxxxxxx> # version change. # Version 7.2 final. Lamar Owen <lamar.owen@xxxxxxxx> # reload from Peter E. # Eliminate the pidof postmaster test in stop -- we're using pg_ctl so we don't need pidof. # Tested the $? return for the stop script -- it does in fact propagate. # TODO: multiple postmasters. # Version 7.3 Lamar Owen <lamar.owen@xxxxxxxxxxxxxxxxx> # Multiple postmasters, courtesy Karl DeBisschop # Version 7.4 Lamar Owen. # Version 7.4.3 Tom Lane <tgl@xxxxxxxxxxxxx> # Support condstop for uninstall # Minor other changes suggested by Fernando Nasser. # Version 7.4.5 Tom Lane <tgl@xxxxxxxxxxxxx> # Rewrite to start postmaster directly, rather than via pg_ctl; this avoids # fooling the postmaster's stale-lockfile check by having too many # postgres-owned processes laying about. # Version 8.1 Devrim Gunduz <devrim@xxxxxxxxxxxxxx> # Increased sleep time from 1 sec to 2 sec. # Version 8.2 Devrim Gunduz <devrim@xxxxxxxxxxxxxxxxx> # Set initdb as a seperate option. # Version 8.3 Devrim Gunduz <devrim@xxxxxxxxxxxxxxxxx> # Version 8.4 Devrim Gunduz <devrim@xxxxxxxxxxxxxxxxx> # Remove "sameuser" from initdb, to match the new hba conf file. # Get rid of duplicate PGDATA assignment. # Ensure pgstartup.log gets the right ownership/permissions during initdb # PGVERSION is the full package version, e.g., 8.4.0 # Note: the specfile ordinarily updates this during install PGVERSION=8.4.4 # PGMAJORVERSION is major version, e.g., 8.4 (this should match PG_VERSION) PGMAJORVERSION=`echo "$PGVERSION" | sed 's/^\([0-9]*\.[0-9]*\).*$/\1/'` -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@xxxxxxxxxxxxx Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
