Skip site navigation (1)Skip section navigation (2)
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>