Date: Wed, 27 Feb 2002 20:24:31 -0600 From: GB Clark <gclarkii@vsservices.com> To: Mike Dewhirst <Dewhirst.M@UCLES.org.uk> Cc: questions@FreeBSD.ORG Subject: Re: postgresql start Message-ID: <20020227202431.7c0808a7.gclarkii@vsservices.com> In-Reply-To: <0B0368CED76DD4118E1200D0B73E9B5D02AFD093@MAIL1> References: <0B0368CED76DD4118E1200D0B73E9B5D02AFD093@MAIL1>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. --Multipart_Wed__27_Feb_2002_20:24:31_-0600_08182200 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit On Wed, 27 Feb 2002 21:18:59 -0000 Mike Dewhirst <Dewhirst.M@UCLES.org.uk> wrote: > another sysadmin has just installed postgresql 7.2 on our 4.4 box. > > I am trying to start it by: > > #su pgsql > $ /usr/local/etc/rc.d/010.pgsql.sh start > ldconfig: mkstemp(/var/run/ld-elf.so.hints.xRrSxZ): Permission denied > Password: > Sorry > $ The script is trying to ldconfig the postgreSQL library directory and of course you can not do this as a non-root account. You should be able to just remove the ldconfig from the script since looks like the system already knows where the librarys are since your command below works. What I do is the following: Set the following in rc.conf ldconfig_insecure="YES" # Set to YES to disable ldconfig security checks ldconfig_paths="/usr/lib/compat /usr/X11R6/lib /usr/local/lib /home/postgres/lib" NOTE: The reason I do this is that I install via the raw source and NOT the port. With the port, just use the the attached startup file and it should work. Works for me. Attached is my startup file > This however works: > > postmaster -D /usr/local/pgsql/data > > > permissions for /usr/local/pgsql/data: > 1 drwx------ 6 pgsql wheel 512 Feb 27 22:18 data > > Any ideas what I need to check to find out why this is happening? > > Many thanks in advance for any help > > Mike Hope it helps. GB -- GB Clark II | Roaming FreeBSD Admin gclarkii@VSServices.COM | General Geek CTHULU for President - Why choose the lesser of two evils? --Multipart_Wed__27_Feb_2002_20:24:31_-0600_08182200 Content-Type: application/octet-stream; name="postgresnew.sh" Content-Disposition: attachment; filename="postgresnew.sh" Content-Transfer-Encoding: base64 IyEvYmluL3NoCgojCiMgIC91c3IvbG9jYWwvZXRjL3JjLmQgc3RhcnR1cCBzY3JpcHQKIwojICRX aW50ZWxjb206IHNyYy9wYXljb3VudGVyX2JhY2tlbmQvZGJzY3JpcHRzL3BnLnNoLHYgMS40IDIw MDAvMDcvMDQgMDk6MTM6NDkgYnJpZ2h0IEV4cCAkCiMgCgpQR1VTRVI9cG9zdGdyZXMKREFUQT0v aG9tZS9wb3N0Z3Jlcy9kYXRhCkRBRU1PTj0vaG9tZS9wb3N0Z3Jlcy9iaW4vcGdfY3RsCkxPR0ZJ TEU9L2hvbWUvcG9zdGdyZXMvbG9ncy9wb3N0Z3Jlcy5sb2cKClBHT1BUUz0iLUQgJERBVEEgLWwg JExPR0ZJTEUiCgpjYXNlIGAvdXNyL2Jpbi93aG9hbWlgIGluCiAgICAgICAgcm9vdCkKICAgICAg ICAgc3UgLSAkUEdVU0VSIC1jICJleGVjICR7REFFTU9OfSAke1BHT1BUU30gc3RhcnQgJiIgCiAg ICAgICAgOzsKICAgICAgIHBvc3RncmVzKQogICAgICAgICAke0RBRU1PTn0gJHtQR09QVFN9IHN0 YXJ0ICYgCiAgICAgICAgOzsKCiAgICAgICAgKikKICAgICAgICAgICAgICAgIGVjaG8geW91IGVp dGhlciBuZWVkIHRvIGJlIHJvb3Qgb3IgJFBHVVNFUiB0byBzdGFydCBwb3N0Z3Jlc3FsCiAgICAg ICAgICAgICAgICBleGl0CiAgICAgICAgOzsKZXNhYwoKCg== --Multipart_Wed__27_Feb_2002_20:24:31_-0600_08182200-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020227202431.7c0808a7.gclarkii>